Cheapest pick in every category
Marketing is launching a «start cheap in every category» promo — they need one minimum-priced product per category. Return id, name, category and price of such products, sort by category.
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.
| id | name | price | category |
|---|---|---|---|
| 4 | Книга | 450.00 | books |
| 1 | Кружка | 350.00 | home |
| 8 | Йога-коврик | 990.00 | sport |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid