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.
Bu egzersiz
Introduction to Snowflake SQL
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
SELECT COUNT(o.order_id) AS total_orders,
AVG(p.price) AS average_price,
-- Calculate total revenue
___ AS total_revenue
FROM orders AS o
LEFT JOIN order_details AS od
ON o.order_id = od.order_id
-- Use an appropriate JOIN with the pizzas table
___ AS p
ON od.pizza_id = p.pizza_id