Comparing invoice totals
Previously, you worked to categorize invoices based on the number of songs sold. Now, you'll take that to the next level. Your goal is to determine just how much more customers spend when buying multiple songs. Good luck!
Bu egzersiz
Data Manipulation in Snowflake
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Run this query without editing it.
SELECT
customer_id,
total,
CASE
WHEN total IN (0.99, 1.99) THEN '1 Song'
ELSE '2+ Songs'
END as number_of_songs
FROM store.invoice;