Total Point: 70/70

Section 1: 46/46

• Type 1 & Type 2: The design is correct in the written text, but mislabelled in the diagram. Won’t take any point out of it, just letting you know.

Section 2: 8/8

• WINDOW FUNCTION Q1: When use ROW_NUMBER, the data of customer_id and market_date is not unique. We need to use GROUP BY to get the unique combination of customer_id and market_date in data. (Point not taken out as the other approach is correct).

Section 3: 8/8

Section 4: 8/8