There seems to be a mistake on the table

Listing 5.4: The "Activity totals by date" query

Because option 2 seems more efficient on IO as it sends this results.

CREATE NONCLUSTERED...