Buyers of a SKU on a given date
An Ozon junior analyst monitors sharp sales spikes per SKU and wants to know how many unique buyers placed an order on October 1, 2023. The SKU card carries tags (string array) for future category queries, irrelevant here.
Count distinct users (cnt_users) who purchased sku_id = 2 on October 1, 2023 in Moscow time (Europe/Moscow).
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| cnt_users |
|---|
| 6 |
Ozon
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid