1. Learn
  2. /
  3. Courses
  4. /
  5. Data Manipulation in Snowflake

Connected

Exercise

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!

Instructions 1/3

undefined XP
    1
    2
    3

In query.sql is the query you previously built to determine the number of songs sold captured by a single invoice.

  • Run this query and inspect the results. Next, you'll adapt this query to compare the average total for 1 Song or 2+ Songs.