1. 学ぶ
    2. /
  2. コース
    3. /
  3. Data Manipulation in Snowflake
Connected

演習

Building a detailed invoice

In the store schema, you have the invoice, invoiceline, and track table. However, these don't quite stand on their own. To get a better idea of customer behavior, we're going to "recreate" each of these invoices with a bit more detail. We'll do this using two common table expressions, which you'll build from the ground up.

指示1 / 3

undefined XP
    1
    2
    3
  • Create a CTE with the name cleaned_invoices that retrieves the invoice_id and invoice_date from the invoice table.