Question

See which episode has the most 10 star ratings sql

a) SELECT episode FROM ratings WHERE stars = 10 ORDER BY COUNT(*) DESC LIMIT 1;
b) SELECT episode FROM ratings GROUP BY episode ORDER BY MAX(stars) DESC LIMIT 1;
c) SELECT episode FROM ratings ORDER BY SUM(stars) DESC LIMIT 1;
d) SELECT episode FROM ratings WHERE stars = 10 ORDER BY MAX(stars) DESC LIMIT 1;

Answer 1

The correct SQL query to find the episode with the most 10 star ratings would involve selecting the episode and counting the number of 10 star ratings, ordered in descending order and limited to the top result.

Step-by-step explanation:

The student has asked a question related to an SQL (Structured Query Language) problem about finding the episode with the most 10 star ratings from a database. Among the options given, the correct one is the query that both filters for 10 star ratings and also groups by the episode to then count the number of such ratings. Here's the corrected form of the query:

SELECT episode, COUNT(*) as count FROM ratings WHERE stars = 10 GROUP BY episode ORDER BY count DESC LIMIT 1;

This SQL statement selects the episode column from the ratings table and counts the number of occurrences of 10 star ratings for each episode. The results are grouped by episode and the count is ordered in descending order to get the episode with the most 10 star ratings, with LIMIT 1 used to return only the top result.