Design SQL statements for the following questions. Each question is $10$ points.

Q$1$: For each member, report the member name and home phone number. Concatenate the first and last name of each member with a whitespace between.

Q$2$: For each member, report the member name and the age of the member.

Q$3$: Report the studio name and the first name of each studio contact. Hint: the first name is the part before the space.

Q$4$: Report the studio name and the last name of each studio contact. Hint: the last name is the part that follows the space.

Q$5$: Report the track title with the most characters.

Q$6$: List every genre from the Genre table and the names of any titles in that genre if any. For any genre without titles, display $\text{'}$No Titles' in the Title column.

Q$7$: Report all the genres from the Genre table. Capitalize the first letter of each genre and the rest of the letters should be lower case.

Q$8$: Redo Q$6$ using CASE.

Q$9$: List each artist name and a lead source designation. If the lead source is $\text{'}$Ad$\text{'},$ then report $\text{'}$Ad$\text{'}$ for the lead source designation. If the lead source is anything else, then report 'Not Ad$\text{'}$ for the lead source designation.

Q$10$: Report the artist name and the age in years of the responsible member for each artist at the time of that artist's entry date.