Clean Averages

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

Domain

SQL

Difficulty

easy

Seniority

L3

Problem

The merchandising team is benchmarking product quality across the catalog. For each category, they need the average customer rating rounded to one decimal place, but only for products that have actually received a rating. Leave out any category with fewer than three rated products. List the results from highest average rating to lowest.

Summary

Merchandising only cares about the categories customers actually rate.

Practice This Problem

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