LXLogicExcel
🔥
0
0
AS (Aliases) & Column Arithmetic1 / 10
An alias is when you use AS to change the name of a column in the results. Note that you are not changing the actual table in the database, just the way it appears to you in the results.

Select product_name and unit_price, but rename them so they are more user-friendly. Try:

SELECT product_name AS item, unit_price AS cost FROM products;

Ctrl+Enter to submit

🔥 0 streak
0 XP this lesson
All lessons