8-14 using sample database from www.postgresqltutorial.com/PostgreSQL-sample-database/

amount > 0; 7 Return the number of movies present in each category SELECT category id, COUNT) FROM film. category GROUP BY film category.category id 8 Return the title of the movies that have a rental rate equal to the maximum rental rate for their category 9 Return a list of all the different first 3 numbers of a zipcode (something that can be used to determine the number of different cities, do not worry about the fact that they are in different countries) 10 Find the total revenue (the sum of all the rentals) for each store (characterized by store id) 11 Return a list of all the customers that performed more than 10 rentals 12 Using Union, Except, or Intersect provide the name of the customers that never performed a rental 13 Provide the titles of all the movies rented by Nicholas Barfield. 14 Provide a summary table using GROUPING SETS where the different movies are counted by rental ate, and by category (the first part must count how many movies exist with rental rate sg 4.99 and then how many movies exist for a category e.g Horror)