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

SQL Coding Challenge – February 2020

Introduction
4. The table ingredient
Tasks

Instruction

The third table, ingredient, stores details about the products from which pizza is made.

Exercise

The table ingredient contains these columns:

  • id – the unique ID of the ingredient.
  • name – the name of the ingredient.
  • type – the ingredient category among 'dairy product', 'vegetable', 'spice', 'fruit', 'fat', 'meat'.

Select all data from the table ingredient.