Only this week, get the SQL Complete Track of 9 courses in a special prize of $330 $89!
Introduction
Quiz
5. Exercise 1
Congratulations

Instruction

Good job! Let's start with our quiz.

Exercise

Select name and type of ingredient to obtain the following types: vegetable, fruit or sweets.

Stuck? Here's a hint!

To filter the ingredients use WHERE clause. Use the IN operator to test for appropriate types. If you don't remember how get data from a table, look at SQL Basics course, Part 2: Selecting from a table.