USE Chinook, SELECT Query Requirements

1. (Chinook db) Display the first name and last name of the single customer who has purchased the most video tracks. (1 record) 2. (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) 3. (Chinook db) Display the TrackID and Track Name of any tracks that have not yet been purchased. (1519 records) 4. (Bookstore db) Using the b_ tables, display the first and last names of all authors who currently do not have any books listed, sorted author last/first name. (2 records)