Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Final Quiz
3. Exercise 1

Instruction

Here's the first exercise.

Exercise

Show the first, middle, and last name of each person together in one column (name this new column full_name). Format it like this:

First_name Middle_name LASTNAME

In other words, capitalize the first letter of the first and middle names, and show the last name uppercased.

Show this information only for people whose last names are at least 7 characters long. If a person has a NULL middle name, show an empty string for this middle name.