Exercise

Build a stream of events

In the prior exercise, we broke out day spa data into a stream of entrances and exits. Unpivoting the data allows us to move to the next step, which is to order the entire stream.

The results from the prior exercise are now in a temporary table called #StartStopPoints.

Instructions

100 XP

Fill out the appropriate window function (ROW_NUMBER()) to create a stream of check-ins and check-outs in chronological order.

Take Hint (-30 XP)