Average Rating Per Product Category
Easy
group-by
Amazon
Apple
Spotify
Calculate the average review rating per product category. Return category and avg_rating (rounded to 1 decimal place), ordered by avg_rating descending.
Expected Output: Category with average rating.
Tables
Hints (2 available)
SQL Editor
Output
Click "Run" to see results...