Concatenation
Simple text functions
How to modify strings
Instruction
Right! Let's move on, there are other functions you should learn too. One of them is lower(). Whatever is put inside the parentheses of lower() will be written in lowercase letters. For example:
SELECT lower(last_name) AS last_name_lowercase FROM copywriter;
will produce 'turner' for the last name 'Turner'. Shall we try it in an exercise?
Exercise
The boss of the marketing agency heard that it's now very fashionable to write magazine and newspaper ads in lowercase letters. Let's check how it would look.
For every slogan of the type 'newspaper ad' or 'magazine ad', show the slogan id and its text in lowercase as text_lowercase.
Stuck? Here's a hint!
Use two conditions in the WHERE clause, joined with OR.
