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

Recursive Queries in MS SQL Server

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.