Skip to main content

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