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
Tasks
12. Task 7

Instruction

Great! Now Mark knows what ingredients he needs for the new order. Maybe he'll finally have enough to buy that new oven. To know for sure, Lisa needs to find the profit on cheesecake sales. Profit is calculated as 10% of the sale revenue.

Exercise

Write a query to show the profit made on all cheesecake sales. (It is 10% of the total sale price.) Name this column profit.

Stuck? Here's a hint!

Use the expression ...

SUM(purchase.amount * cake.price) * 0.1

... to calculate the profit from the sale of cheesecakes.