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
2. The cake table
Tasks

Instruction

Before you start, let's get to know the database. It's named confectionary and it stores four tables: cake, ingredient, cake_ingredient and purchase.

In the cake table, you'll find data about the cakes Mark bakes.

Exercise

The table cake has the following columns:

  1. id – A unique ID for each cake.
  2. name – The name of the cake.
  3. price – The price per one cake tray.

Explore the details of this table by selecting all its data.