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

Exercise

The world of JOINS

Previously, you generated insights for Pissa around their sales and revenue by month. Now, you'll look into their most popular pizzas.

Apply your knowledge of joins to get the desired result.

Instructions 1/2

undefined XP
    1
    2
  • Calculate the total revenue using the price column from the pizzas table and the quantity column of the order_details table, respectively.
  • Use an appropriate JOIN to include all records from the pizzas table.