SQLab — learn SQL in your browser

Rating by category

MediumOnline storeJOIN + AVG40 XP

Show the average review rating of each category’s products: the category name and the average rating rounded to 2 decimals.

Tables · Online store

categoriesProduct categories8 rows

productsProducts63 rows

reviewsReviews330 rows

customersCustomers160 rows

ordersOrders640 rows

order_itemsOrder lines1,174 rows

Sign in to open this section

Sign in to solve problems and play the arena. It takes less than a minute.

Tables · Online store

categoriesProduct categories8 rows

productsProducts63 rows

reviewsReviews330 rows

customersCustomers160 rows

ordersOrders640 rows

order_itemsOrder lines1,174 rows