1) Write a SQL query to show the country name where maximum number of movies has been produced, along

with the number of movies produced.

2) Write a SQL query to show all the genre_id in one column and genre_name in second column.

3) Write a SQL query to show name of all the languages in one column and number of movies in that

particular column in another column.

4) Write a SQL query to show movie name in first column, no. of crew members in second column and

number of cast members in third column.

5) Write a SQL query to list top 10 movies title according to popularity column in decreasing order.

6) Write a SQL query to show the name of the 3rd most revenue generating movie and its revenue.

7) Write a SQL query to show the names of all the movies which have rumoured movie status.

8) Write a SQL query to show the name of the United States of America produced movie which generated

maximum revenue.

9) Write a SQL query to print the movie_id in one column and name of the production company in the second

column for all the movies.

10) Write a SQL query to show the title of top 20 movies arranged in decreasing order of their budget.

\begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ language_role } \\ \hlinePK & \( \begin{array}{l}\text { role_id } \\ \text { language_role }\end{array} \) \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ movie } \\ \hline PK & movie_id \\ title \\ budget \\ homepage \\ overview \\ popularity \\ release_date \\ revenue \\ runtime \\ movie_status \\ tagline \\ votes_avg \\ votes_count \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ gender } \\ \hline PK & gender_id \\ & gender \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ person } \\ \hline PK & person_id \\ person_name \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ keyword } \\ \hlinePK & keyword_id \\ & keyword_name \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ department } \\ \hline PK & department_id \\ & department_name \\ \hline \end{tabular}