Brief Introduction to SQL
Concepts to introduce:
- SELECT (aggregations)
- FROM
- JOIN ON
- WHERE
- GROUP BY and HAVING
- ORDER BY
- LIMIT
Introduce some common functions in SQL: COALESCE, AVG, MIN, MAX, SUM, CASE WHEN, COUNT (DISTINCT) In where clause: IN, INTERVAL UNION ALL
Link to full SQL tutorial and reference: CASE WHEN