RSVP Upcoming Project Analysis Using MySQL

Project Overview

RSVP Movies is a renowned Indian film production company planning to release a global movie in 2022. To aid in their planning, this project involves analyzing historical movie data to derive insights that will guide their new venture.

The database created for this analysis includes the following tables:

• movie
• genre
• director_mapping
• role_mapping
• names
• ratings

Key Questions

Here are some of the key questions addressed in the analysis:

1. Which production house has produced the most number of hit movies (average rating > 8)?

2. Summarize the ratings table based on the movie counts by median ratings.

3. Which are the five highest-grossing movies of each year that belong to the top three genres?

4. What are the average ratings of movies for each genre?

5. Identify the directors who have worked on the most number of movies with a rating above 7.

6. Find the top three actors based on the number of roles they have played in movies with an average rating above 8 , and many more questions...

Requirements

• SQL Database (e.g., MySQL)
• SQL Client or Database Management Tool (e.g., MySQL Workbench, pgAdmin)

License

This project is licensed under the MIT License - see the LICENSE file for details.

Acknowledgements

• Inspired by real-world movie production analysis.

Contact Me

email : [email protected] github : kashh56