1. Learn
    2. /
  2. Courses
    3. /
  3. Data Manipulation in Snowflake
Connected

Exercise

Identifying large transactions

When customers buy a lot, you want to know why! In this exercise, you'll practice using subqueries to retrieve details about transactions with more than 10 line items.

Instructions 1/2

undefined XP
    1
    2
  • Update the query below to retrieve the invoice_id and number of line items for invoices for with more than 10 total_invoice_lines.