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