Hi all,
So, there’s that Ex 6: Critiques with most likes, where the instructions as are follows:
- Write a SQL query to:
- Select the
movie_id
,critique
andcritique_likes
from theratings
table - Keep only the reviews with the 50 highest number of comments.
- Order the results by
critique_likes
in descending order to identify the most commented movies.
- Select the
- Run the query using Pandas
I passed the lab and all, but I still cannot understand why the ‘Keep only the reviews with the 50 highest number of comments’ step is even there. It’s not the part about ‘50’ that bothers me, but the one about the ‘number of comments’. In my solution, which was graded 10/10, I did not provide any reference to the number of comments whatsoever. What I effectively did (and which seems to be correct as per grading) was to get the 50 highest number of critique likes.