SQL

1. 1. Basic query

1.1. Select

1.2. Distinct

1.3. Order by

1.4. Limit

2. 2. Filter data

2.1. Where

2.2. And/Or

2.3. Between

2.4. In

2.5. Like

3. 3. Built-in funtions

3.1. AGGREGATE FUNCTIONS

3.1.1. MAX, MIN, AVG, SUM, COUNT

3.2. SCALAR FUNTIONS

3.2.1. STRING

3.2.1.1. LENGHT/LOWER/UPPER

3.2.1.2. LEFT/RIGHT

3.2.1.3. CONCAT/POSITION/SUBSTRING/REPLACE

3.2.1.4. CAST

3.2.2. DATE/TIME

3.2.2.1. EXTRACT/INTERVALS/TIMESTAMP

3.2.3. LOGICAL FUNTIONS & PIVOT TABLE

3.2.3.1. CASE-WHEN, COALESE

4. JOIN AND UNION

4.1. JOIN

4.1.1. INNER JOIN

4.1.2. LEFT JOIN

4.1.3. RIGHT JOIN

4.1.4. FULL JOIN

4.1.5. SELF JOIN

4.2. UNION

4.2.1. UNION

4.2.2. UNION ALL

5. 5. SUBQUERIES AND CTE

5.1. SUBQUERIES

5.1.1. SUBQUERIES IN WHERE

5.1.2. SUBQUERIES IN FROM

5.1.3. SUBQUERIES IN SELECT

5.2. CTES