Functions & Grouping
You're examining pizza order details at Pissa. The team is interested in investigating revenue generated by different pizza sizes per month.
Complete the query using your knowledge of aggregate functions, sorting, and grouping to support the team with their analysis.
Deze oefening maakt deel uit van de cursus
Introduction to Snowflake SQL
Oefeninstructies
- Get the
monthfrom theorder_datecolumn. - Use appropriate Snowflake SQL keywords to group the query results.
- Arrange your results by
revenuein descending sequence.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
-- Get the month from order_date
SELECT ___(___ FROM ___) AS order_month,
p.pizza_size,
-- Calculate revenue
___(p.price * od.quantity) AS revenue
FROM orders o
INNER JOIN order_details od USING(order_id)
INNER JOIN pizzas p USING(pizza_id)
-- Appropriately group the query
___
-- Sort by revenue in descending order
___