Introduction
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.
