Costs
The C-level execs next tell Eve that they want a report on the total costs by eatery in the last two months.
First, write a query to get the total costs by eatery in November and December 2018, then pivot by month.
Note: Recall from Chapter 1 that total cost is the sum of each meal's cost times its stocking quantity.
Cet exercice fait partie du cours
<cours>Analyzing Business Data in SQL</cours>Exercice interactif pratique
Essayez cet exercice en complétant ce code d’exemple.
SELECT
-- Select eatery and calculate total cost
___,
DATE_TRUNC('month', stocking_date) :: DATE AS delivr_month,
___ :: FLOAT AS cost
FROM meals
JOIN stock ON meals.meal_id = stock.meal_id
-- Keep only the records after October 2018
WHERE ___
GROUP BY eatery, delivr_month
ORDER BY eatery, delivr_month;