Cheapest pick in every category
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. Your answer must use the same column names as this sample — alias them with AS if needed.
| id | name | category | price |
|---|---|---|---|
| 4 | Книга | books | 450.00 |
| 1 | Кружка | home | 350.00 |
| 8 | Йога-коврик | sport | 990.00 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid