SELECT

1. MAX

2. MIN

3. COUNT

4. FROM

4.1. JOIN

4.1.1. INNER

4.1.2. RIGHT

4.1.3. LEFT

4.1.4. OUTER

4.2. WHERE

4.2.1. LIKE

4.2.1.1. %

4.2.1.2. ^

4.2.1.3. _

4.2.1.4. [ ]

4.2.2. BOOLEAN

4.2.2.1. IS NULL

4.2.2.2. NOT

4.2.2.3. IN

4.2.2.4. BETWEEN

4.2.2.5. OR

4.2.2.6. AND

4.3. GROUP BY

4.4. ORDER BY

5. AVG

6. SUM