Dawn Choo | Data Interview Tips on Instagram: "SQL concepts you need to know vs. don’t need to know… for your first Data Analyst job. ✅ Must know SQL concepts 1. SELECT statements 2. WHERE clauses 3. GROUP BY 4. ORDER BY 5. JOINs (INNER, LEFT, RIGHT, FULL) 6. Aggregate functions (COUNT, SUM, AVG, etc) 7. Aliases (AS) 8. Filtering with HAVING 9. Subqueries 10. CASE WHEN logic 11. Data types (VARCHAR, INT, DATE, etc.) 12. NULL handling (IS NULL, COALESCE) 13. LIMIT / OFFSET 14. Basic date function