Product Showcase: Rename the Columns
Product Showcase: Rename the Columns
The "Kotomarket" catalog has a products table of cat goods: id, title, price, stock.
The storefront needs human-friendly column captions. Write a query that selects three columns from products and gives them explicit aliases with AS:
- title → naimenovanie
- price → cena
- stock → ostatok
Return all rows of the table. Do not include the id column.
Row order does not matter. Column order must be exactly: naimenovanie, cena, ostatok.
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.
| naimenovanie | cena | ostatok |
|---|---|---|
| Когтеточка Башня | 2490.00 | 12 |
| Корм Сухой Индейка 1кг | 790.50 | 40 |
| Игрушка Мышка с мятой | 149.00 | 200 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid