Module 3 - Graded lab

Course Q&A Data Analytics Professional Certificate Data I/O and Processing with Python and SQL
,
1

Hi all,

So, there’s that Ex 6: Critiques with most likes, where the instructions as are follows:

  1. Write a SQL query to:
    • Select the movie_id, critique and critique_likes from the ratings 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.
  2. 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.

2

Hi. I think that part is for practicing filtering the results. We’ll check if the wording needs to be revised based on your report here. Thanks!