Rockbuster Stealth

PROBLEM

Rockbuster Stealth LLC is a movie rental company that used to have stores around the world. Facing stiff competition from streaming services such as Netflix and Amazon Prime, the Rockbuster Stealth management team is planning to use its existing movie licenses to launch an online video rental service in order to stay competitive.

DATA

This dataset is provided by Career Foundry, and contains several files.

PROCESS

• Database querying in SQL.

• Filtering data.

• Cleaning data in SQL.

• Joining tables.

• Performing subqueries.

• Common Table Expression.

• SQL results.

RESULTS

• Which movies contributed the most revenue gain?

  • Telegraph Voyage

• Which movies contributed the lest to revenue gain?

  • Texas Watch

• Which countries are Rockbuster customer based in?

  • India