Products Under 1000 Rubles
Products Under 1000 Rubles
The products table holds the product catalog of the "Kotomarket" pet store. A marketer is building a "Budget Finds" selection and wants to show only inexpensive products.
Return the title, price, and category of every product whose price is strictly less than 1000 rubles. For each matching product return the columns title, price, category in exactly this order.
Use only SELECT and WHERE with a comparison — no sorting, grouping, or other constructs.
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.
| title | price | category |
|---|---|---|
| Корм «Сытый кот» 2кг | 890 | корм |
| Игрушка «Мышка» | 150 | игрушки |
| Шампунь «Чистый мех» | 320 | уход |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid