Mark finally found out that cheesecake sells best, is highly rated, and is not as expensive as the lemon layer cake. Lisa thinks maybe they should make more cheesecakes. She's even found a new company to buy this kind of cake. How many ingredients will they need to prepare 124 cheesecakes for the new client?
Write a query selecting the name of each cheesecake ingredient, the total amount of the ingredient needed to prepare 124 cheesecakes (name this column total), and the measurement unit used for each ingredient. Sort by ingredient name.
Use the expression ...
(124 * cake_ingredient.amount) AS total
... to calculate the total value of each ingredient needed to make 124 cheesecakes.
You'll need to join three tables and make sure the cake name is 'cheesecake'.
