sql v1.0A

Immutable. This exact content never changes and is served at /api/v1/blob/5a0bfb0288f4d245.

---
name: sql
description: Database query language.
license: MIT
metadata:
  author: vant
  version: "1.0"
---

# SQL

> Database query language.

---

## When To Use

- Database queries
- Data analysis
- CRUD operations

---

## What To Do

### 1. Basic

```sql
SELECT columns FROM table
WHERE condition
ORDER BY column
LIMIT n
```

### 2. Operations

| Keyword | What |
|---------|------|
| SELECT | Read |
| INSERT | Create |
| UPDATE | Update |
| DELETE | Remove |
| JOIN | Combine |

### 3. Aggregates

```sql
SELECT COUNT(*), SUM(col), AVG(col), MIN(col), MAX(col)
FROM table
GROUP BY col
HAVING count > 1
```

### 4. Subqueries

```sql
SELECT * FROM users
WHERE id IN (SELECT user_id FROM orders)
```

---

**Role**: SQL Developer  
**Input**: Query  
**Output**: Results

> Query.