36 questions, graded against hidden datasets
| 23.9% |
| Easy |
| ○ | 5.Top N products per category |  | Aggregation | 26.7% | Easy |
| ○ | 59.Late arriving events per visitor | | Window functions | 33.3% | Medium |
| ○ | 7.Flatten nested JSON into a fact table |  | Data modeling | 37.5% | Medium |
| ○ | 1.Deduplicate customers, keep latest record |  | Window functions |  Amazon+2 | 38.1% | Medium |
| ○ | 14.Month-over-month revenue growth | | Window functions | Amazon+2 | 41.2% | Medium |
| ○ | 2.Rolling 7-day active users | | Window functions | Amazon | 50.0% | Medium |
| ○ | 16.Running balance per account | | Window functions | 50.0% | Medium |
| ○ | 15.Find duplicate invoices | | Deduplication | 53.8% | Easy |
| ○ | 21.Validate JSON records against a schema | | Data modeling | 100.0% | Easy |
