Buyers of a SKU on a given date
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
| cnt_users |
|---|
| 6 |
Ozon
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid