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
5. The purchase table
Tasks

Instruction

The last table, purchase, stores details about the cakes bought by clients (i.e. other companies). Every day, Mark supplies different companies with cakes.

Exercise

The table purchase has these columns:

  • id – A unique ID for each purchase.
  • cake_id – The ID of the cake purchased by the client.
  • amount – The number of pieces of cake bought by the client.
  • company_id – The ID of the company that bought the cake.
  • purchase_date – The date of the cake was purchased.
  • rating – A number (from 0 to 5) given by the client as an assessment of the cake.

Select all the info in this table.