Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

SQL Coding Challenge – May 2020

Introduction
Tasks
7. Task 2

Instruction

Great! Thanks to your SQL skills, Lisa found out which cakes will likely be purchased this month. Next, she wants to know the average assessment score given to all purchased cakes (for all months, not just May 2019).

Exercise

Find the name of the cake and its average assessment score. Round the average score to zero decimal places and name this column avg_rating. Then sort records in descending order by avg_rating.

Stuck? Here's a hint!

Use the AVG() aggregate function to calculate the average value. Use it as the argument in ROUND().

Learn more in this exercise of the SQL Basics course and this exercise of the Standard SQL Functions course.