rsvp movies sql assignment

SQL-RSVP-Movies-Case-Study

Sql rsvp movies case study.

SQL queries performed on the IMDb database to provide recommendations to RSVP Movies based on insights.

Problem Introduction

RSVP Movies is an Indian film production company that has produced many super-hit movies. They have usually released movies for the Indian audience but for their next project, they are planning to release a movie for the global audience in 2022.

The production company wants to plan its every move analytically based on data and has approached you for help with this new project. You have been provided with the data on the movies that have been released in the past three years. You must analyze the data set and draw meaningful insights that can help them start their new project.

You are a data analyst and an SQL expert. You must use SQL to analyze the given data and give recommendations to RSVP Movies based on the insights. For your convenience, the entire analytics process has been divided into four segments, where each segment leads to significant insights from different combinations of tables. The questions in each segment with business objectives are written in the script.

Data Set and Database Creation

• Download the IMDb dataset.
• The first tab contains the ERD and the table details. Study that carefully and understand the relationships between the table.
• Inspect each table given in the subsequent tabs and understand the features associated with each of them.
• Open your MySQL Workbench and start writing the DDL and DML commands to create the database.

If you don’t wish to perform the data loading part, you can directly download the SQL script file containing all the commands and data required for the database creation and start directly with the querying.

SQL_RSVP_Movies

Problem statement:.

RSVP Movies is an Indian film production company that wants to release a movie for the global audience in 2022. They have approached you, a data analyst and SQL expert, to help them analyze data from the past three years of movies to draw meaningful insights that can help them with their new project.

The problem statement is divided into four segments:

Segment 1: Analyze the number of movies released each year and month to identify the most popular time of year for movie releases.

Segment 2: Analyze the genres of movies released to identify the most popular genres.

Segment 3: Analyze the production houses that have released the most successful movies to identify the most successful production houses.

Segment 4: Analyze the actors and actresses who have starred in the most successful movies to identify the most popular actors and actresses.

• Executive Summary PDF.
• README File.

Hurry Up! And Get Flat 10% Discount On Your First Order                                    We are available by 24/7 for your support!

RealCode 4 You

+91 82 67 81 38 69

[email protected]

• realcode4you
• May 15, 2022
• 11 min read

Post analysis on IMDB data by RSVP Movies | Database Assignment and Homework Help

Updated: May 27, 2022

Requirement

Most of the movies were produced in the month of March with an average of about 2300 movies per year.

Drama was the most popular genre with 4285 number of movies and an avg duration of 106.7746. RSVP movies can focus on this genre for its future films. Action and Thriller genres also hold potential.

Most of the movies were rated between 6-8 on a median rating scale. Aiming for 8+ on a median rating will increase chances of a superhit movie.

Dream warrior Pictures and National Theatre Live had produced highest rated films. Star Cinema and Twentieth Century Fox are also good contenders due to high number of multilingual movies as the movie will be for Indian audience primarily.

Top directors observed from the analysis are James Mangold, Anthony Russo, Joe Russo and Soubin Shahir. With the later 3 tied at #2 spot. RSVP can have its future projects with them.

Mammooty and Mohanlal are the top actors with highest number of rating.

Taapsee Pannu can be chosen as actress as she is on the top of the list with average rating 7.74 and maximum votes.

Marvel Studios(1st) Twentieth Century Fox(2nd) & Warner Bros.(3rd) can be chosen as its Global Partners as number of votes received is maximum of their movies.

In India, Vijay Sethupati can be focused on as he his popular here.

10.Star Cinema and Twentieth Century Fox are the top two production houses that have produced the highest number of hits (median rating >= 8) among multilingual movies

Creating Tables:

/******************************************************************************************

/ Queries to create a smaller version of IMDB database

/ For SQL Assignment from UpGrad. Created by Shreyas M

/*****************************************************************************************/

Inserting Values

-- Inserting values into genre

-- Inserting values into director_mapping

-- Inserting values into role_mapping

-- Inserting values into names

-- Inserting values into ratings

/* Now that you have imported the data sets, let’s explore some of the tables.

To begin with, it is beneficial to know the shape of the tables and whether any column has null values.

Further in this segment, you will take a look at 'movies' and 'genre' tables.*/

-- Segment 1:

-- Q1. Find the total number of rows in each table of the schema?

-- Type your code below:

-- Q2. Which columns in the movie table have null values?

-- Now as you can see four columns of the movie table has null values. Let's look at the at the movies released each year.

-- Q3. Find the total number of movies released each year? How does the trend look month wise? (Output expected)

/* Output format for the first part:

+---------------+-------------------+

| Year | number_of_movies|

+-------------------+----------------

| 2017 | 2134 |

| 2018 | . |

| 2019 | . |

Output format for the second part of the question:

| month_num | number_of_movies|

+---------------+----------------

| 1 | 134 |

| 2 | 231 |

+---------------+-------------------+ */

/*The highest number of movies is produced in the month of March.

So, now that you have understood the month-wise trend of movies, let’s take a look at the other details in the movies table.

We know USA and India produces huge number of movies each year. Lets find the number of movies produced by USA or India for the last year.*/

-- Q4. How many movies were produced in the USA or India in the year 2019??

/* USA and India produced more than a thousand movies(you know the exact number!) in the year 2019.

Exploring table Genre would be fun!!

Let’s find out the different genres in the dataset.*/

-- Q5. Find the unique list of the genres present in the data set?

/* So, RSVP Movies plans to make a movie of one of these genres.

Now, wouldn’t you want to know which genre had the highest number of movies produced in the last year?

Combining both the movie and genres table can give more interesting insights. */

-- Q6.Which genre had the highest number of movies produced overall?

/* So, based on the insight that you just drew, RSVP Movies should focus on the ‘Drama’ genre.

But wait, it is too early to decide. A movie can belong to two or more genres.

So, let’s find out the count of movies that belong to only one genre.*/

-- Q7. How many movies belong to only one genre?

/* There are more than three thousand movies which has only one genre associated with them.

So, this figure appears significant.

Now, let's find out the possible duration of RSVP Movies’ next project.*/

-- Q8.What is the average duration of movies in each genre?

-- (Note: The same movie can belong to multiple genres.)

/* Output format:

| genre | avg_duration |

| thriller | 105 |

/* Now you know, movies of genre 'Drama' (produced highest in number in 2019) has the average duration of 106.77 mins.

Lets find where the movies of genre 'thriller' on the basis of number of movies.*/

-- Q9.What is the rank of the ‘thriller’ genre of movies among all the genres in terms of number of movies produced?

-- (Hint: Use the Rank function)

+---------------+-------------------+---------------------+

| genre | movie_count | genre_rank |

|drama | 2312 | 2 |

+---------------+-------------------+---------------------+*/

/*Thriller movies is in top 3 among all genres in terms of number of movies

In the previous segment, you analysed the movies and genres tables.

In this segment, you will analyse the ratings table as well.

To start with lets get the min and max values of different columns in the table*/

-- Segment 2:

-- Q10. Find the minimum and maximum values in each column of the ratings table except the movie_id column?

+---------------+-------------------+---------------------+----------------------+-----------------+-----------------+

| min_avg_rating| max_avg_rating | min_total_votes | max_total_votes |min_median_rating|min_median_rating|

| 0 | 5 | 177 | 2000 | 0 | 8 |

+---------------+-------------------+---------------------+----------------------+-----------------+-----------------+*/

/* So, the minimum and maximum values in each column of the ratings table are in the expected range.

This implies there are no outliers in the table.

Now, let’s find out the top 10 movies based on average rating.*/

-- Q11. Which are the top 10 movies based on average rating?

| title | avg_rating | movie_rank |

| Fan | 9.6 | 5 |

| . | . | . |

-- It's ok if RANK() or DENSE_RANK() is used too

/* Do you find you favourite movie FAN in the top 10 movies with an average rating of 9.6? If not, please check your code again!!

So, now that you know the top 10 movies, do you think character actors and filler actors can be from these movies?

Summarising the ratings table based on the movie counts by median rating can give an excellent insight.*/

-- Q12. Summarise the ratings table based on the movie counts by median ratings.

| median_rating | movie_count |

| 1 | 105 |

-- Order by is good to have

/* Movies with a median rating of 7 is highest in number.

Now, let's find out the production house with which RSVP Movies can partner for its next project.*/

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

+------------------+-------------------+---------------------+

|production_company|movie_count | prod_company_rank|

| The Archers | 1 | 1 |

+------------------+-------------------+---------------------+*/

-- Answer can be Dream Warrior Pictures or National Theatre Live or both

-- Q14. How many movies released in each genre during March 2017 in the USA had more than 1,000 votes?

| genre | movie_count |

-- Lets try to analyse with a unique problem statement.

-- Q15. Find movies of each genre that start with the word ‘The’ and which have an average rating > 8?

| title | avg_rating | genre |

| Theeran | 8.3 | Thriller |

-- You should also try your hand at median rating and check whether the ‘median rating’ column gives any significant insights.

-- Q16. Of the movies released between 1 April 2018 and 1 April 2019, how many were given a median rating of 8?

-- Once again, try to solve the problem given below.

-- Q17. Do German movies get more votes than Italian movies?

-- Hint: Here you have to find the total number of votes for both German and Italian movies.

-- Answer is Yes

/* Now that you have analysed the movies, genres and ratings tables, let us now analyse another table, the names table.

Let’s begin by searching for null values in the tables.*/

-- Segment 3:

-- Q18. Which columns in the names table have null values??

/*Hint: You can find null values for individual columns or follow below output format

+---------------+-------------------+---------------------+----------------------+

| name_nulls | height_nulls |date_of_birth_nulls |known_for_movies_nulls|

| 0 | 123 | 1234 | 12345 |

+---------------+-------------------+---------------------+----------------------+*/

/* There are no Null value in the column 'name'.

The director is the most important person in a movie crew.

Let’s find out the top three directors in the top three genres who can be hired by RSVP Movies.*/

-- Q19. Who are the top three directors in the top three genres whose movies have an average rating > 8?

-- (Hint: The top three genres would have the most number of movies with an average rating > 8.)

| director_name | movie_count |

+---------------+-------------------|

|James Mangold | 4 |

/* James Mangold can be hired as the director for RSVP's next project. Do you remeber his movies, 'Logan' and 'The Wolverine'.

Now, let’s find out the top two actors.*/

-- Q20. Who are the top two actors whose movies have a median rating >= 8?

| actor_name | movie_count |

|Christain Bale | 10 |

/* Have you find your favourite actor 'Mohanlal' in the list. If no, please check your code again.

RSVP Movies plans to partner with other global production houses.

Let’s find out the top three production houses in the world.*/

-- Q21. Which are the top three production houses based on the number of votes received by their movies?

+------------------+--------------------+---------------------+

|production_company|vote_count | prod_comp_rank|

| The Archers | 830 | 1 |

+-------------------+-------------------+---------------------+*/

/*Yes Marvel Studios rules the movie world.

So, these are the top three production houses based on the number of votes received by the movies they have produced.

Since RSVP Movies is based out of Mumbai, India also wants to woo its local audience.

RSVP Movies also wants to hire a few Indian actors for its upcoming project to give a regional feel.

Let’s find who these actors could be.*/

-- Q22. Rank actors with movies released in India based on their average ratings. Which actor is at the top of the list?

-- Note: The actor should have acted in at least five Indian movies.

-- (Hint: You should use the weighted average based on votes. If the ratings clash, then the total number of votes should act as the tie breaker.)

+---------------+-------------------+---------------------+----------------------+-----------------+

| actor_name | total_votes | movie_count | actor_avg_rating |actor_rank |

| Yogi Babu | 3455 | 11 | 8.42 | 1 |

| . | . | . | . | . |

+---------------+-------------------+---------------------+----------------------+-----------------+*/

-- Top actor is Vijay Sethupathi

-- Q23.Find out the top five actresses in Hindi movies released in India based on their average ratings?

-- Note: The actresses should have acted in at least three Indian movies.

| actress_name | total_votes | movie_count | actress_avg_rating |actress_rank |

| Tabu | 3455 | 11 | 8.42 | 1 |

/* Taapsee Pannu tops with average rating 7.74.

Now let us divide all the thriller movies in the following categories and find out their numbers.*/

/* Q24. Select thriller movies as per avg rating and classify them in the following category:

Rating > 8: Superhit movies

Rating between 7 and 8: Hit movies

Rating between 5 and 7: One-time-watch movies

Rating < 5: Flop movies

--------------------------------------------------------------------------------------------*/

/* Until now, you have analysed various tables of the data set.

Now, you will perform some tasks that will give you a broader understanding of the data in this segment.*/

-- Segment 4:

-- Q25. What is the genre-wise running total and moving average of the average movie duration?

-- (Note: You need to show the output table in the question.)

| genre | avg_duration |running_total_duration|moving_avg_duration |

| comdy | 145 | 106.2 | 128.42 |

| . | . | . | . |

-- Round is good to have and not a must have; Same thing applies to sorting

-- Let us find top 5 movies of each year with top 3 genres.

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

-- (Note: The top 3 genres would have the most number of movies.)

| genre | year | movie_name |worldwide_gross_income|movie_rank |

| comedy | 2017 | indian | $103244842 | 1 |

-- Top 3 Genres based on most number of movies

-- Finally, let’s find out the names of the top two production houses that have produced the highest number of hits among multilingual movies.

-- Q27. Which are the top two production houses that have produced the highest number of hits (median rating >= 8) among multilingual movies?

+-------------------+-------------------+---------------------+

|production_company |movie_count | prod_comp_rank|

-- Multilingual is the important piece in the above question. It was created using POSITION(',' IN languages)>0 logic

-- If there is a comma, that means the movie is of more than one language

-- Q28. Who are the top 3 actresses based on number of Super Hit movies (average rating >8) in drama genre?

| actress_name | total_votes | movie_count |actress_avg_rating |actress_rank |

| Laura Dern | 1016 | 1 | 9.60 | 1 |

/* Q29. Get the following details for top 9 directors (based on number of movies)

Director id

Number of movies

Average inter movie duration in days

Average movie ratings

Total votes

total movie durations

+---------------+-------------------+---------------------+----------------------+--------------+--------------+------------+------------+----------------+

| director_id | director_name | number_of_movies | avg_inter_movie_days | avg_rating | total_votes | min_rating | max_rating | total_duration |

|nm1777967 | A.L. Vijay | 5 | 177 | 5.65 | 1754 | 3.7 | 6.9 | 613 |

| . | . | . | . | . | . | . | . | . |

-- Type you code below:

To Get solution of above queries or need any other database related help then you can send your requirement details at:

And get complete solution without any plagiarism issue with an affordable price.

Recent Posts

Design and Construct a Database System for Rapid Bikes | Realcode4you

Practical Coding Assignment Using SQL | Realcode4you

MySQL Installation Guide | What is Database Management System? | Realcode4you

IMDB-Data-Analysis-in-SQL

This project was carried out to answer a set of analytical questions to suggest a movie production house on which set of actors, directors, and production houses would be the best fit for a super hit commercial movie..

Table of Content (TOC)

• Database Creation for the Project
• Table Creation
• Data Insertion

Data Analysis

• EXECUTIVE SUMMARY AND RECOMMENDATIONS

1. Overview

This analysis is carried out to support RSVP Movies with a well-analyzed list of global stars to plan a movie for the global audience in 2022.

With this, we will be able to answer a set of analytical questions to suggest RSVP Production House on which set of actors, directors, and production houses would be the best fit for a super hit commercial movie.

RSVP Movies is an Indian film production company that has produced many super-hit movies. They have usually released movies for the Indian audience but for their next project, they are planning to release a movie for the global audience in 2022.

Why this Analysis?

The production company wants to plan its every move analytically based on data and has approached for help with this new project.

We have been provided with the data of the movies that have been released in the past three years. Let’s analyze the data set and draw meaningful insights that can help them start their new project.

We will use SQL to analyze the given data and give recommendations to RSVP Movies based on the insights.

We will be carrying out the entire analytics process into four segments, where each segment leads to significant insights from different combinations of tables.

2. Database Creation for the Project

A. check the list of database.

• The very first step of any MySQL analysis is to access the database and check if related data is available or not.
• Use show databases; to access the list of databases:

b. Create Database

• Create a new database for this project.
• Use Create database IMDB;
• Use show databases; to confirm the list of databases:

c. Use Database

• Instruct the system to use *IMDB Database* by running use imdb;

3. Table Creation

Steps to follow before creating the table:.

• Download the IMDb dataset. And try to understanding every table and its importance.
• Understand the ERD and the table details. Study them carefully and understand the relationships between the table.

• Inspect each table given in the subsequent tabs and understand the features associated with each of them.
• Draft your table with the correct Data Type and Constraints in a paper or note file.
• Open your MySQL Workbench and start writing the DDL and DML commands to create the database.

Create Table

For this project we need a total of 6 tables:

a. Create Table Movie

b. Create Table Genre

c. Create Table director_mapping

| Table Name: director_mapping | Column Description | | ———– | ———– | | movie_id | Movie Id of the movie directed by a director | | name_id | Name ID of the director |

d. Create Table role_mapping

e. Create Table names

f. Create Table ratings

Now, Run show tables; to ensure that all the six tables are created.

4. Data Insertion

In the previous steps, we created six tables. Now, we will insert the data into these tables. Here, we will be showing the syntax of 5 rows insertion into each table. (The complete data insertion syntax is available in the Repository)

a. Inserting data into Movie Table

B. inserting data into genre table, c. inserting data into director_mapping table, d. inserting data into role_mapping table, e. inserting data into names table, f. inserting data into ratings table, checking tables for inserted values:.

Select * from Movie;

Select * from Genre;

Select * from Director_Mapping;

Select * from Role_Mapping;

Select * from Names;

Select * from Ratings;

All the sample data inserted looks good. SO, we can go ahead with insertion of complete data. For insertion to work smoothly, lets drop all data from tables using TRUNCATE :

Insert Complete data

Run the command to insert complete data: IMDB File 3 Insert all data

1. Find the total number of rows in each table of the schema?

Alternative 1:.

Number of Rows after ignoring the Null Rows

Alternative 2:

Rows count inclusive of Null Rows:

TABLE_NAME Tables_in_imdb director_mapping 3867 genre 14662 movie 8519 names 23714 ratings 8230 role_mapping 15173

2. Which columns in the movie table have null values?

id_null title_null year_null date_null duration_null country_null world_null language_null production_null 0 0 0 0 0 20 3724 194 528

3.1. Find the total number of movies released each year?

Movies per year:, 3.2. find the total number of movies released each year, movies per month, 4.1 find the count of indian movies., 4.2 find the count of movies from usa, 4.3 find the count of movies which are either from india or usa, 4.4 find the count of movies that are either from india or usa and released in 2019., 5. find the unique list of the genres present in the data set, 6.1 find the movies count for each genre., 6.2 find the genre with the maximum number of movies., 6.3 find the genre with minimum number of movies., 6.4 find the top-3 genre with the maximum number of movies., 6.4 find the movies count for action genre., 6.5 find the genre count for each movie., 6.6 find the list of indian movies that belongs to 3 genre., 6.7 longest indian movie tagged with 3 genre..

‘tt6200656’, ‘Kammara Sambhavam’, ‘182’, ‘3’

6.8 Which genres are tagged with ‘Kammara Sambhavam’ movie.

genre Action Comedy Drama

7.1. How many movies belong to only one genre?

Create a list of Movies with a genre count

Restrict the list to Genre count = 1

Count the total number of rows

7.2. How many movies belong to two genres?

7.3. how many movies belong to three genres, 8.1. what is the average duration of movies in each genre, 8.2. rank the genre by the average duration of movies in each genre., 9. what is the rank of the ‘thriller’ genre of movies among all the genres in terms of the number of movies produced, 10. find the minimum and maximum values in each column of the rating table except the movie_id column, 11. which are the top 10 movies based on average rating, 12. summarize the ratings table based on the movie counts by median ratings., 13. which production house has produced the most number of hit movies (average rating > 8).

Create list of production house with count of movies where average rating > 8 and Ranked over “Movies count”

Applied CTE to pull the production house with Rank = 1

NOTE: applied (production_company IS NOT NULL) as there are few movies without production house name

14. How many movies released in each genre during March 2017 in the USA had more than 1,000 votes?

15. find movies of each genre that start with the word ‘the’ and which have an average rating > 8, 16. of the movies released between 1 april 2018 and 1 april 2019, how many were given a median rating of 8, 17. do german movies get more votes than italian movies, q18. which columns in the names table have null values, 19. who are the top three directors in the top three genres whose movies have an average rating > 8.

Pull the Top three Genre by Movie count where avg_rating > 8

Pull the Directors with Movie count where avg_rating > 8

Keeping “top_3_genres” as CTE, restrict the 2nd code to avg_rating > 8 and directors of top_3_genre

Trying Row_Number() function:

20. who are the top two actors whose movies have a median rating >= 8, 21. which are the top three production houses based on the number of votes received by their movies, 22. rank actors with movies released in india based on their average ratings. which actor is at the top of the list.

– Note: The actor should have acted in at least five Indian movies.

ALTERNTIVE 1 (Using Rank Window Function):

Alternative 2 (using cte):, 23.find out the top five actresses in hindi movies released in india based on their average ratings.

– Note: The actresses should have acted in at least three Indian movies.

24. Select thriller movies as per avg rating and classify them in the following category:

Rating > 8: Superhit movies

Rating between 7 and 8: Hit movies

Rating between 5 and 7: One-time-watch movies

Rating < 5: Flop movies

——————————————————————————————–*/

EXECUTIVE SUMMARY AND RECOMMENDATIONS {##-EXECUTIVE-SUMMARY-AND-RECOMMENDATIONS}

1. insights.

Based on 7,997 released and recorded on IMDB between 2017 and 2019, a summary of audience interest and recommendations are mentioned as below:

• Average Duration: 103.89359
• Total number of Actors: 12611 (7445 actor & 5166 Actress)

1. Year and Month wise Movie Release Pattern:

• A year wise record of movies indicates a slight decrease in number of movies from 3052 movies in 2017 to 2001 movies in 2019.
• Maximum number of movies were released in March, followed by September, October, and January. While more interesting fact is about the least number of movies being released in mid-year and end of year months, could be because of more people prefer vacation and family time in this time of year.

2. Geographical Region Distribution

• USA and India produced 1059 movies together in 2019 alone, way above half of total movies released (2001) in the year.

3. Genre Popularity

• Movies were tagged with genre tags as Drama, Fantasy, Thriller, Comedy, Horror, Family, Romance, Adventure, Action, Sci-Fi, Crime, and Mystery.
• Drama is most popular genre among all the genre with 4285 tags across three years, followed by Comedy and Thriller.
• There were 3289 movies with only one genre tags, while remaining were tagged with multiple genres.

4. The average duration of movies are around 103.89359 minutes, and even genre vise average revolves around the same figure.

5. top production houses.

• Marvel Studios rules the best Production House category with 551245 votes based on the number of votes received by the movies they have produced, followed by Syncopy, and New Line Cinema.
• Star Cinema, and Twentieth Century Fox are the top 2 multi-Lingual production house based on the most number of superhit movies.

6. Top Director

• James Mangold has given most number of Superhit Movies, followed by Soubin Shahir, Joe Russo, and Anthony Russo.
• A.L. Vijay, Andrew Jones, and Chris Stokes are the top directors based on number of movies.

7. Top Actors and Actress

• Mammootty with 8 Superhit movies is most successful actor followed by Mohanlal with 5 Superhits.
• There are quite a few number of actors with 4 Superhit movies under their name, which include Amrinder Gill, Amit Sadh, Johnny Yong Bosch, Tovino Thomas, Dulquer Salmaan, Siddique, Rajkummar Rao, Fahadh Faasil, Pankaj Tripathi, Dileesh Pothan, Joju George, and Ayushmann Khurrana.
• Vijay Sethupathi, Fahadh Faasil, and Yogi Babu are the top three Indian actors who have acted atleast in five movies.
• Taapsee Pannu, Divya Dutta, and Kriti Kharbanda are the top three Hindi Speaking actress who have acted at least in three movies.
• Parvathy Thiruvothu, Susan Brown, and Amanda Lawrence are the best rated actresses in Drama genre.

8. Top-10 movies based on average rating are: Kirket, Love in Kilnerry, Gini Helida Kathe, Runam, Fan, Android Kunjappan Version 5.25, Yeh Suhaagraat Impossible, Safe, The Brighton Miracle, and Shibu

• Based on Median rating counts, most of the movies are rated between 5 and 8, and falls under hit movie categories.

9. Top Grossing Movies

The highest-grossing movies of each year are:

i. Thank You for Your Service, a comedy movie released in 2017

ii. The Villain, a thriller movie released in 2018

iii. Joker, a drama movie released in 2019

2. Recommendation:

Based on Insights, the recommendations for RSVP are as following:

• Concentrate on multi-genre drama-comedy movies with a pinch of thriller, keeping an average duration of around 104 minutes.
• Plan for release of movie between January to March. Focus on multilingual movies which can be launched in India and USA as preferred audience market.
• Rope in either Star Cinema or Twentieth Century Fox as the production house, under the directorial of James Mangold with assistance of A.L. Vijay.
• Mammootty and Mohanlal can be the lead actors along with assistance from other side actors. Inclusion of Vijay Sethupathi would act as stardom promotion for the movie.
• Parvathy Thiruvothu is one of the most rated drama actresses to be brought in.

Navigation Menu

Search code, repositories, users, issues, pull requests..., provide feedback.

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly.

To see all available qualifiers, see our documentation .

• Notifications You must be signed in to change notification settings

RSVP_assignment_upgrad.sql

Latest commit, file metadata and controls.