SQL Notes — Portfolio (DuckDB)

What: 10 concise queries on a tiny dataset to demonstrate JOINs, aggregations, CTEs, and window functions.

Run (Option A — Python runner)

1. pip install duckdb pandas
2. python run_all.py
3. See outputs in expected/

Run (Option B — DuckDB CLI)

1. terminal：duckdb
2. .read queries/00_setup.sql
3. .read queries/01_joins.sql（02/03/04/05 sequentially）