-- 1. Which customer has the most late fees.  And the amount of late fees

 

 

-- 2. List the movie title, the movie year, the movie star rating, and the

-- runtime minutes for all movies order by star rating.

 

 

-- 3. List all the movies in which Carl Reiner is the director

 

 

 

-- 4. List the names of all the movies and the person's name who were

-- both a director and cast member simultaneously.

 

 

 

-- 5. List all the comedies rated PG for the year 1989

 

 

 

-- 6. List all the comedies rated PG for the year 1989, and list all the

-- other genres for those comedies

 

 

-- 7. List the customers and the number of movies they have rented

 

 

 

-- 8. Who has rented the most movies? List the number of movies too.

 

 

-- 9. List the customers in reverse order of late_fees

 

 

 

-- 10. Choose a customer!  List the genres rented by that customer.

 

 

 

-- 11. Choose a customer!  List the genres and number of movies rented by

-- that customer, and list the genres most popular first.  Note that a

-- movie may count more than once.

 

 

 

-- 12. List the genres and number of movies rented, and list the genres

-- most popular first.  Note that a movie may count more than once.

 

 

 

-- 13. List the number of movies rented by customers in each city. 

-- Arrange the results geographically

 

 

 

-- 14. List the actors that had movies in 1988, in order of popularity

-- (i.e., number of movies in which they appear)

 

 

 

-- 15. List all movies in which Kevin Bacon acted

 

 

 

-- 16. List all actors that have acted in movies with Kevin Bacon

 

 

-- 17. List the average number of days that a movie is late.  Separate

-- your answers by rental type.

 

 

 

-- 18. It's February 1st, 2003.  List the customer and the movies they

-- rented that are overdue and have not been returned.

 

 

 

-- 19. Get the contact information for all customers whose cards are

-- expired.

 

 

 

-- 20. List the number of rentals by day of week