Exercise

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.

Instructions 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.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions 1/3

Exercise