Transform values with functions such as UPPER, LOWER, LENGTH and ROUND.
Transform values with functions such as UPPER, LOWER, LENGTH and ROUND. Read the query line by line and identify the input table, the transformation, and the shape of the result before running it.
SELECT UPPER(name) AS name_upper FROM customers ORDER BY name;
Before running the example, predict the output columns and whether the query returns one row, many rows, or possibly no rows.
In your own words, explain the main SQL feature in today’s lesson and why it answers the question.
Recall prompt: Use UPPER(name) and ORDER BY name. Close this page section mentally and explain the query from memory before proceeding.
Show customer names in uppercase, ordered by the original name.
Use UPPER(name) and ORDER BY name.