It's Autumn! Prices fall like leaves! - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Quiz
7. Exercise 3
Congratulations

Instruction

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

Exercise

Find the number of ingredients in each ingredient type. Name the columns type and number_of_ingredients.

Stuck? Here's a hint!

Use the COUNT aggregate function.

To group results by type, you must know how to use the GROUP BY clause. If you don't, take a look at Basics of PostgreSQL Part 4: Aggregation and grouping.