Clean Averages

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 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.

Practice This Problem

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