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.

titlepricecategory
Корм «Сытый кот» 2кг890корм
Игрушка «Мышка»150игрушки
Шампунь «Чистый мех»320уход
PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid