Analysis of film inventory for video rental stores.
This repository performs queries that identify store video rental and gross revenue totals. Additionally, the queries analyze the following: locations, customer info, film genres, and more.
The purpose of developing subqueries and joins with the code is to provide a quick forecast where business is thriving as well as the most in demand customer picks. This helps plan for appropriate inventory and company growth. Included are conditional queries, subqueries, joins, and a view.