Description
Lab #12: Selective Aggregation
Learn how to use the CASE
operator with aggregation functions to transform and report data. This type of approach is known as selective aggregation.
- Lab
- Description
- Help Section
- Instructions
Lab Description
Learn how to use the CASE
operator with aggregation functions to transform and report data.
The lab has four parts, which you find after clicking on the Lab Instructions link. The steps are:
- Step 1: Create the
calendar
table as per the specification provided. - Step 2: Seed the
calendar
table as per the specification provided. - Step 3: Create a
transaction_reversal
table that imports atransaction_upload2.csv
file from the upload virtual directory; and transfer the data from thetransaction_reversal
table to the transaction table by using anINSERT
statement. - Step 4: Create the following transformation report by a
CROSS JOIN
between thetransaction
andcalendar
tables.