Schema
Table
Setup
| Column Name | Type | Description |
|---|---|---|
| content_id | integer | Reviewed content identifier. |
| rating | integer | Rating value. |
Top
Rated
Content
Find the content with the highest average rating.
Table
Sample Data
Input
Output
Sample Input: reviews
| content_id | rating |
|---|---|
| 1 | 4 |
| 1 | 5 |
| 1 | 3 |
| 2 | 3 |
| 2 | 4 |
| 3 | 2 |
| 3 | 3 |
| 4 | 5 |
| 4 | 4 |
Expected Output
| content_id | avg_rating |
|---|---|
| 4 | 4.5 |
SQL Editor
Run
Query
Waiting for query
| content_id | avg_rating |
|---|---|
| 4 | 4.5 |
Hints
Unlock
Clues
Hint 01: Average ratings at the content level.
Hint 02: Use AVG(rating).
Hint 03: Order by avg_rating descending and keep one row.
Solution
Locked
Answer
Solution is locked until you decide to reveal it. Try the editor first, then open this when you want the reference answer.
SELECT content_id, AVG(rating) AS avg_rating FROM reviews GROUP BY content_id ORDER BY avg_rating DESC LIMIT 1;
Explanation
Step By
Step
01
Group review rows by content_id.
02
Calculate average rating for each content_id.
03
Return the highest-rated content.
Related Questions