Catalog Without Archive
Catalog Without Archive
The cat_products table holds the product catalog of the "Kotomarket" pet store. Some products are discontinued and marked with the category 'архив' (archive) — they should not be shown to customers.
Return all products except those in the 'архив' category. For each matching product return the columns product_id, name, category, price.
Use only SELECT and WHERE — 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.
| product_id | name | category | price |
|---|---|---|---|
| 1 | Когтеточка «Башня» | мебель | 2490 |
| 2 | Корм «Сытый кот» 2кг | корм | 890 |
| 3 | Игрушка «Мышка» | игрушки | 150 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid