Introduction
Quiz
6. Exercise 2
Congratulations

## Instruction

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

## Exercise

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.