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.
This exercise is part of the course
Introduction to Snowflake SQL
Exercise instructions
- Get the
monthfrom theorder_datecolumn. - Use appropriate Snowflake SQL keywords to group the query results.
- Arrange your results by
revenuein descending sequence.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- 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
___