Active warehouses per city
Samokat is a dark-store network for 15-minute delivery. An ops analyst tracks which cities have grown beyond 80 active warehouses — a key trigger for regional strategy. Warehouse geo coordinates live in POINT, the active flag in BOOLEAN.
Count currently-open warehouses (is_open = TRUE) per city and keep only those cities with strictly more than 80. Biggest cities first.
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.
| city | warehouse_count |
|---|---|
| Novosibirsk | 90 |
| Moscow | 85 |
| Kazan | 81 |
Samokat
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid