Average Product Review Ratings

Amazon

Foundations Track · Easy · 15 min

Amazon is reviewing average product review ratings through a scorecard. The product quality team wants monthly review score reporting. For each product and m...

Foundations Track

Easy

15 min

aggregation

date functions

Company labels are directional practice context, not official interview guidance.

Timer 00:00

Back to practice

Objective

Practice aggregation through a Amazon-tagged business scenario.

Approach

Use this track to lock in clean query structure, basic filtering logic, and confidence with grouped output.

Company context

Company labels are directional practice context, not official interview guidance.

Prereq: query basics

Prereq: filtering

Amazon is reviewing average product review ratings through a scorecard. The product quality team wants monthly review score reporting. For each product and month, return the month number, product_id as product, and the average star rating rounded to two decimal places. Sort by month, then product.

reviews

review_id INTEGER

user_id INTEGER

submit_date DATE

product_id INTEGER

stars INTEGER

Editor

SQL workspace

Run queries against the protected question data, then submit once the result shape looks right.

Sign in to run SQL

Create a free account or sign in before running queries against protected question data.