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 – May 2020

Introduction
4. The cake_ingredient table
Tasks

Instruction

The third table, cake_ingredient, stores the ingredients for each cake.

Exercise

The cake_ingredient table contains these columns:

  • cake_id – The ID of the cake.
  • ingredient_id – The ID of the ingredient.
  • amount – How much (in the unit of the ingredient) is needed to bake one tray of a cake.

Select all data from the table cake_ingredient.