Even more efficient for the test data supplied is this one - almost 9 times faster than the original -- look at the execution plan of the batch when you...

A much more efficient version of this takes about 1/6 of the processing:

SELECT G.OrderDate, G.ProductKey, QtyOrdered = SUM(F.QtyOrdered), G.MTD

FROM

(

SELECT

...