Q#3: Chocolate Bar Reviews

You have the following dataset of chocolate bar ratings. You can assume you have this data in a table called InternationalChocolateRatings.

Can you write a SQL query to summarize the BroadBeanOrigin for US manufactured chocolate bars and provide the number of reviews, average rating, and average cocoa percent?

ANSWER:

SELECT COUNT(ReviewDate) as Number_of_Reviews, AVG(Rating) as Average_Rating, AVG(CocoaPercent) as Average_Cocoa_Percent 
FROM InternationalChocolateRatings;