Introduction In this project, you will query the Sakila DVD Rental database. The Sakila Database holds information about a company that rents movie DVDs. For this project, you will be querying the database to gain an understanding of the customer base, such as what the patterns in movie watching are across different customer groups, how they compare on payment earnings, and how the stores compare in their performance. To assist you in the queries ahead, the schema for the DVD Rental database is provided below.
Queries
CRITERIA MEETS SPECIFICATIONS The student can write error-free SQL queries.
All SQL queries run without errors and produce the intended results.
The student can use JOINs correctly in SQL queries.
Each SQL query needs to include one or more explicit JOINs. The JOIN or JOINs should be necessary to the query.
If a question does not require a JOIN please change the question to be one that does.
The student can use aggregations correctly in SQL queries.
Each SQL query needs to include one or more aggregations. This could be a COUNT, AVG, SUM, or other aggregation.
The student can use subqueries and Common Table Expressions.
At least 2 of the 4 SQL queries need to include either a subquery OR a CTE.
The student can use Window Functions.
At least 1 of the 4 queries should use a Window Function.
The SQL queries are well formatted.
The SQL queries are well formatted and use aliases.