SQL cheat sheet

SQL cheat sheet

Practice SELECT, aggregation, LEFT JOIN, common table expressions, and ranking in SQLite.

1. Open latihan.sqlite with a SQLite-compatible tool and read latihan.sql.
2. Inspect table keys and row counts before joining or aggregating data.
3. Compare query results with expected totals and explain how NULL values are handled.