Investigate a Relational Movie Database

Demonstrating the ability to -

1. Write error-free SQL queries
2. Using SQL JOINS
3. Demonstrating the ability to use SQL aggregations (COUNT, AVG, SUM, etc.)
4. Creating SQL sub-queries (OR / CTE)
5. Display SQL window-function
6. Present SQL-based, Data Visualization of findings including a chart and/or table

Authorized end-users can query an SQL-database to mine business intelligence ranging from what are the top six most popular rental categories to a store-to-store performance comparison.

These and other related results are useful for inventory control and promotional campaigns to potentially increasing overall rentals and other movie-related sales.