Average Rating per Product - Easy SQL Grouping Interview Problem

Problem

Before Airbnb's e-commerce team promotes anything on their homepage, they want to know which products actually rate well and how many reviews back that up. A 5-star average from one review and a 4.8 from hundreds are very different things! Using the reviews table, return product_id, avg_rating (rounded to 2 decimal places), and review_count, ordered by avg_rating descending.

Schema

reviews

column	type
id	INTEGER
product_id	INTEGER
user_id	INTEGER
rating	INTEGER
created_at	DATE

Sample Data

id	product_id	user_id	rating
1	1	101	5
2	1	102	4
3	2	103	3
4	2	104	2
5	3	105	5

Expected Output

product_id	avg_rating	review_count
3	5.00	1
1	4.50	2
2	2.50	2

Hints