Day 1 — SQL Foundations for Analytical Work

Write SELECT queries that return specified columns, calculated fields, aliases, and a required sort order.

Apply WHERE conditions correctly using comparison, Boolean, IN, BETWEEN, and pattern-matching operators.

Handle NULL values correctly with IS NULL, IS NOT NULL, COALESCE, and NULL-aware conditions.

Summarize data with COUNT, SUM, AVG, MIN, MAX, GROUP BY, and HAVING.

Combine two tables on specified keys using INNER JOIN and LEFT JOIN.

Create conditional categories and metrics with CASE expressions.

Filter and aggregate records using common date and timestamp functions.

Verify a simple reported total by comparing it with an independently written SQL query.