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