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.

namecategoryprice
Сухой корм Acana 2кгкорм2890.00
Паучи с курицей 12шткорм640.00
Дразнилка-удочкаигрушки320.00
PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid