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

Instruction

Now that we know the data, let's get started!

Exercise

Show the first, middle and last name of each person together in one column. Format it like the example shown below:

Maria Elena SCHMIDT

The first letter of the first and middle name is capitalized; the entire last name is in uppercase. Name this column FullName.

Show this information only for those people whose LastName is at least 7 characters long. If someone doesn't have a middle name, show just the first name and the last name with a single space between them, like this:

Maria SCHMIDT

Stuck? Here's a hint!

To have only one space between the first name and last name if the middle name is NULL, use the CONCAT_WS() function.