Warehouse shelf: SKU, weight and price under readable names
Warehouse shelf: SKU, weight and price under readable names
In the Kotomarket warehouse, items sit in a flat table goods. The columns have technical names that are hard for the shelf manager to read.
Select exactly three columns from goods and label each with a human-readable name using AS:
| From table | Alias in result |
|------------|-----------------|
| sku | artikul |
| weight_g | ves |
| price | cena |
Return all rows of the table (no filters, no sorting). Row order does not matter.
This is pure projection: nothing beyond picking the needed columns and renaming them — no WHERE, ORDER BY, or DISTINCT.
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.
| artikul | ves | cena |
|---|---|---|
| KM-001 | 1500 | 549.00 |
| KM-002 | 3200 | 1290.00 |
| KM-003 | 45 | 99.50 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in