Only this week, get the SQL Complete Track of 9 courses in a special prize of $330 $89!
4. Exercise 2


Excellent! Let's move on.


The IQ society created a dating website for its members. We need to anonymize the user data before members go on their first date. For each person, show the following sentence:

XYZ lives in A and weighs B kilograms.

XYZ are the person's initials (XZ if a person has no middle name), A is the city and B is the weight, rounded to the nearest whole number.

Don't forget about the period at the end of the sentence! Name the column Candidate.