1. WHERE, AND, OR, NOT, IN 2. ORDER BY, ASC, DESC 3. IS NULL 4. LIMIT 5. MIN, MAX, COUNT, AVG, SUM 6. LIKE, WILDCARDS 7. IN BETWEEN 8. JOINs - INNER, LEFT, RIGHT, FULL 9. Subqueries & CTEs 10. UNION 11. GROUP BY 12. HAVING 13. PARTITION BY, OVER 14. LEAD, LAG 15. RANK, DENSE_RANK, PERCENT_RANK 16. ROW_NUMBER, CUME_DIST 17. FIRST_VALUE, LAST_VALUE

 1. WHERE, AND, OR, NOT, IN

2. ORDER BY, ASC, DESC
3. IS NULL
4. LIMIT
5. MIN, MAX, COUNT, AVG, SUM
6. LIKE, WILDCARDS
7. IN BETWEEN
8. JOINs - INNER, LEFT, RIGHT, FULL
9. Subqueries & CTEs
10. UNION
11. GROUP BY
12. HAVING
13. PARTITION BY, OVER
14. LEAD, LAG
15. RANK, DENSE_RANK, PERCENT_RANK
16. ROW_NUMBER, CUME_DIST
17. FIRST_VALUE, LAST_VALUE