1. सीखें
  2. /
  3. पाठ्यक्रम
  4. /
  5. Data Manipulation in Snowflake

Connected

अभ्यास

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.

निर्देश 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.