Pro exercise
Filter rows, then filter groups
List repeat customers: people with at least two paid orders, and what they spent. Unpaid orders must be removed before counting (WHERE), and customers with fewer than two paid orders after counting (HAVING). Doing either at the wrong stage changes who qualifies.
- aggregation
- where vs having
- scope
Sign in with a Pro or Lifetime plan to open the rules, the dataset and the workspace.