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.
Este ejercicio forma parte del curso
Analyzing Business Data in SQL
Ejercicio interactivo práctico
Prueba este ejercicio y completa el código de muestra.
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;