1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to Snowflake SQL
Connected

Exercise

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.

Instructions

100 XP
  • Get the month from the order_date column.
  • Use appropriate Snowflake SQL keywords to group the query results.
  • Arrange your results by revenue in descending sequence.
Powered by Snowflake