Combos & realistic queries

4 lessons mixing assertion types across one query — a JOIN with a foreign key, an aggregate + GROUP BY, an INSERT + SELECT roundtrip, and an all-in-one comprehensive smoke test.