Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
6. Exercise 2


Fantastic! Let's go on to another exercise. Now we'll test your knowledge of using the COUNT() aggregate function.


For each ingredient type, find the number of individual ingredients with that type. Name the columns Type and NumberOfIngredients.

Stuck? Here's a hint!

Use the COUNT() aggregate function. For grouping, you must know how to use GROUP BY clause. If you don't, just take a look at SQL Basics in SQL Server course, Part 4: Aggregation and grouping.