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:
Maria SCHMIDT
To have only one space between the first name and last name if the middle name is NULL, use the CONCAT_WS() function.
