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


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


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:


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.