Aggregates collapse many rows into summary numbers, and joins stitch tables together. This cheatsheet puts both on one page, each snippet annotated line by line, including the fan-out trap that quietly inflates totals after a join. Keep it open while you query, or save the image and pin it nearby.
For the full background, read the guide to aggregates and joins in BigQuery. To run these patterns yourself, work through the 10 code-along examples.
[…] BigQuery Aggregates and Joins Cheatsheet […]