Quze

the database: https://drive.google.com/file/d/1OFkxASqJqAmCv1sRR…

Quze. 1. (1 pt) Select the payments that are greater than or equal to 9.99 2. (1 pt) Select the most expensive rental payment (what is the max price paid), and use it to find out which films were rented for this price. 3. (2 pts) Show a roster for the staff that includes their full name, email, address, city, and country (not ids). 4. (1 pts) What sort of companies/industries are you interested in working for/in? 5. (1 pt) explain the crows foot notation between two tables in dvdrental and why it is what it is. Homework: 1. (2 pt) Show all customers whose last names start with T. Order them by first name from A-Z. 2. (2 pts) Show all rentals returned from 5/28/2005 to 6/1/2005 3. (3 pts) What query would you use to determine which movies are rented the most? Show the top 10 movies rented the most. 4. (3 pts) Show how much each customer spent on movies (for all time). Order them from least to most. 5. (3 pts) Which actor was in the most movies in 2006 (based on this dataset)? Be sure to alias the actor name and count as a more descriptive name. Order the results from most to least. 6. (4 pts) Write an explain plan for 4 and 5. Show the queries and explain what is happening in each one. Use the following link to understand how this works http://postgresguide.com/performance/explain.html 7. Links to an external site. 8. (4 pts) What is the average rental rate per genre? 9. (4 pts) What categories are the most rented and what are their total sales? Show the top 5 most rented categories. 10. (2 pts): Write a query that shows how many total films were rented each month. Group them by category and month. So, you want to show January in general regardless of year, etc. Useful references: ● https://www.w3schools.com/sql/