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.

artikulvescena
KM-0011500549.00
KM-00232001290.00
KM-0034599.50
PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid