Kotomarket showcase: three categories with IN
Kotomarket showcase: three categories with IN
The Kotomarket catalogue has a single flat table products with columns id, name, category, and price (in rubles).
A manager is building a "For cat and owner" showcase and wants to display only products from three categories: корм (food), игрушки (toys), and лежанки (beds).
Write a query that returns the columns name, category, and price only for products whose category is in that list of three values. All other categories must be excluded.
Hint: it is cleanest to list the categories in a single IN (...) clause rather than chaining three OR conditions.
Lesson limits: only SELECT and WHERE. No ORDER BY, no aggregates, JOIN, DISTINCT, CASE, or subqueries. Row order does not matter.
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.
| name | category | price |
|---|---|---|
| Сухой корм Acana 2кг | корм | 2890.00 |
| Паучи с курицей 12шт | корм | 640.00 |
| Дразнилка-удочка | игрушки | 320.00 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in