Using Character Functions

Sheila needs to add more functionality to her reports. Her employee report needs to display the first name, followed by a space, followed by the last name, all in proper case. In addition, she needs the e-mail data to appear in lowercase.

She has looked up the syntax for functions and created a small sheet on them:

Show Me and Try It: Use SQL Workshop to display the employee names separated by spaces and in proper case

Show Me and Try It: Use Query Builder to display the e-mail addresses in lowercase