Calculations and Functions
You can calculate in a query, rename results with AS, and use built-in functions such as UPPER, LENGTH and ROUND.
Examplesql
Examplesql
|| joins pieces of text together. SELECT DISTINCT city FROM customers; lists each city once.
Examplesql
Quick check
What does `AS` do in `price * 2 AS double_price`?
Your turn: write the code
Return every customer name in upper case, sorted alphabetically.
Finish the quick check (and any code exercise) to complete this lesson, or mark it done yourself.
Tip: use the left and right arrow keys to move between lessons.