Company SQL Question
Top Rated Products by Category
Practice this Amazon style SQL interview question with live execution and instant feedback.
Problem Statement
Calculate the average rating for each product category. Show category name, number of products, and average rating. Only include categories with an average rating above 4.0.
Relevant Tables
productsreviews
SQL Concepts Used in This Question
Strengthen your understanding with these targeted learning topics: