A easy SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

easy

Problem

The merchandising team is negotiating shelf-space contracts and only wants to discuss product categories that have meaningful scale. For each category, show the number of products, the average rating, and the average price. Only include categories with more than eight products. Present them from highest average rating to lowest.

Summary

Merchandising only cares about categories big enough to negotiate shelf space.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.