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 avaliable 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) 5. (Chinook db) Display the first name and last name of the single customer who has purchased the most video tracks. (1 record) 6. (Chinook db) Display the name of the artist and number of orders for the single artist who has had the highest number orders of his/her music placed. (1 record) 7. (Chinook db) Display the TrackID and Track Name of any tracks that have not yet been purchased, (1519 records) 8. (Bookstore db) Using the "b_" tablesi display the first and last names of all authors who currently do not have any books listed, sorted author last/first name. (2 records) 9. (Bookstore db) Using the "b_" tables, display the Customer number, First name, and last name of any customers who have yet to place an order, sorted customer last/first name. (6 records) 10. (Cars db) Using the Cars_Car_Types, Cars_Number_Of_Doors and Cars_Colors tables, create a query that returns every possible combination of the values of each table. (Hint: The result set should contain 24 rows.) 11. (Lunches db) List the employee ID, last name, and phone number of each employee with the name and phone number of his or her manager. Make sure that every employee is listed, even those that do not have a manager. Sort by the employee's id number. (10 records) 12. (Multiple dbs) Create one full list of first names and last names of all customers from the Chinook tables, all authors from the Bookstore tables, all customers from the Bookstore tables, and all employees from the Lunches tables. Sort the list by last name and first name in ascending order. (103 records) "* See note about this query below rubric" 13. (Numbers db) Using the Numbers_Twos and Numbers_Threes tables, show the results of a query that only displays numbers that do not have a matching value in the other table. (51 records) 14. (Numbers db) Using the Numbers_Twos and Numbers_threes tables, show the results of a query that only displays numbers that have a matching value in the other table. Here's the catch: You are not permitted to use a WHERE clause or JOINs for this query. (17 records)
