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.
Diese Übung ist Teil des Kurses
<Kurs>Analyzing Business Data in SQL</Kurs>Interaktive praktische Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
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;