AS: rename columns for a marketplace template

Rizky, the marketplace admin, wants to update product prices in the Shopee store with the bulk upload feature. The upload template only recognises the column headers product_name and selling_price. In the database the same columns are called name and price, so the headers must be renamed in the query result.

Task

From the products table, show the name column with the new header product_name, then the price column with the new header selling_price. The result has 2 columns and 16 rows (every product). Any row order is fine.

Databasetokotables & columns are listed in the right panel

Required keywordsAS

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Run previewCtrlEnter
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
A new header for a result column is called an alias. An alias only changes the header in the query result, not the column name in the table itself.
Hint 2
Write an alias with the word AS after the column name: column AS new_header.
Hint 3
SELECT name AS ___, price AS ___ FROM products;

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

SELECT name AS product_name, price AS selling_price
FROM products;

Explanation

name AS product_name means "show the name column, but give it the header product_name". The data does not change, and the products table in the database still uses the name name. The alias only applies to this query's result.
Tips:

Use lowercase letters and underscores for aliases (selling_price), with no spaces. An alias with spaces must be wrapped in double quotes, such as AS "Selling Price", which is more hassle.
The word AS can actually be left out (price selling_price), but writing it makes the query much clearer. That is also why a missing comma in the previous exercise can silently create an alias.

SQL· database toko

SELECT name, price
FROM products;

Loading the SQL editor…

Write the SQL query, run it to see the result, then press Check answer.

Validation result