Despite the outcome of my code for Exercise 6 match 100% the expected outcome, got 0 out 15 with the following message.:
"Failed test case: likes_df didn’t retrieve the correct data. Please check your query execution. ’
Passed the grade but it is a shame there is no explanation what the issue is, if there is one from my side, and it compromised my final overall grade score.
Hi Aldir. If the output matches the expected outcome, please send me your notebook via direct message. You can click my name then the blue Message button. We’ll investigate what went wrong. Thanks!
After reviewing exercise 6, I think possible mistakes are:
We made some adjustments for new learners to catch these. Hope this helps!
Hi Chris. First thank you for the FU. I changed the LIMIT to 50 and re-sumitted for grading obtaining 100% this time. THAT SAID, please notice that the wording to the bullet points in Directions " * Keep only the reviews with the 50 highest number of comments." and " * Order the results by critique_likes in descending order to identify the most commented movies." may confuse the student as ratings has already a column named “critique_comments”. I successfully used ORDER BY critiques_like DESC LIMIT 50;. Hope that helps.