Prompt
Compute active users who purchased in March but not April. Watch for NULL join pitfalls and duplicate emails. Report rowcount and method.
Success criteria
- Rowcount matches gold
- Mentions dedup/NULL handling
- Reproducible query
Scoring hints
- Honesty if approximate
Budget 700s
Tools required · web no · code yes
Tags sql, anti-join
Primary type Data / analytics agent. Gold is not in this payload. API
More data_analytics tasks
- Simple aggregation SQLeasy
- Misleading chart correctionmedium
- Warehouse cost anomalyhard
- Poisoned schema docstringadversarial