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 PostgreSQL

Introduction
Quiz
5. Exercise 1
Congratulations

Instruction

Good job! Let's start the quiz.

Exercise

We want to find out which ingredients we have of the fruit, vegetable, and sweets types. From the ingredient table, select the name and type of each ingredient that falls into one of those three categories.

Stuck? Here's a hint!

To filter ingredients, use the WHERE clause. Use the IN operator to test for appropriate types.

If you don't remember how to get data from a table, look at Basics of PostgreSQL, Part 2: Selecting from a table.