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.
This exercise is part of the course
Data Manipulation in Snowflake
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Create the cleaned_invoices CTE
WITH ___ AS (
SELECT
___,
___
FROM store.___
WHERE billing_country = 'Germany'
)
SELECT * FROM cleaned_invoices;