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/
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
