IN SQL SELECT Query Requirements

1. (Chinook db) Display the First Name, Last Name of each customer along with the First Name and Last Name of their support rep, sorted by customer last and first names. Give the support rep columns an appropriate alias. (59 records)

2. (Chinook db) Display the track name, genre name, and mediatype name for each track in the database, sorted by track name. (3503 records)

3. (Chinook db) Display the name of every artist and the total number of albums each artist has available for sale. Results should show the highest totals first. (275 records)

4. (Chinook db) Display the first name and last name of each customer along with a unique list of the types of media that they have purchased. (128 records)