Concatenation
Simple text functions
How to modify strings
Instruction
Great! If there is a function for lowercase letters, there must be a function for uppercase letters too, right? It's called upper() and works in a similar way:
SELECT upper(last_name) AS last_name_uppercase FROM copywriter;
The above query will show 'TURNER' for the last name 'Turner'.
Exercise
The lowercase fashion is now passé. Everybody started to use upper case. Show the id of each 'newspaper ad' or 'magazine ad' slogan together with its text in capital letters. Name the second column text_uppercase.
Stuck? Here's a hint!
Use two conditions in the WHERE clause, joined with OR.
