49. Top 3 money making movie categories

medium

***********

  • *************************************************************************************************
  • *********************************************
  • *****************************************
  • *******************************************

Table 1: category

*****************


**************************************************************************************************************

Table 2: film


**********************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

Table 3: film_category

**************************************


*******************************************************************************************************************

Table 4: inventory

*****************************************************************


************************************************************************************************************************************************

Table 5: payment

***************************************


********************************************************************************************************************************************************************************************************************************************

Table 6: rental


*************************************************************************************************************************************************************************************************************************************************************

Sample results




Last Submission postgres

Expected results



More INNER JOIN questions

ID Title Level FTPR
213 Interchange revenue by issuer and merchant category visa easy
70%
179 Members who ever moved from Microsoft to Google linkedin medium
31%
162 Number of orders per brand walmart easy
41%
150 Countries with above average customers google easy
15%
99 Page recommendation facebook medium
13%
91 same day friend request acceptance rate spotify easy
13%
50 Top 5 cities for movie rentals easy
22%
48 Movie and TV actors easy
38%
40 Top 2 most rented movie in June 2020 medium
14%
39 Most productive actor with inner join easy
22%
38 Most popular movie category (name and id) medium
19%
37 Most popular movie category easy
15%
36 Actors from film 'AFRICAN EGG' easy
32%