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!
Introduction
Quiz
7. Exercise 3
Congratulations

Instruction

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

Exercise

For each ingredient type, find the number of ingredients. Name the columns type and number_of_ingredients.

Stuck? Here's a hint!

Use 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 course, Part 4: Aggregation and grouping.