38. Most popular movie category (name and id)

medium

***********

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

Table 1: category

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


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

Table 2: film_category

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


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

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%
49 Top 3 money making movie categories medium
18%
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%
37 Most popular movie category easy
15%
36 Actors from film 'AFRICAN EGG' easy
32%