Execute the following Microsoft SQL Server T-SQL script in SSMS Query Editor to demonstrate the application of GROUP BY year and month.

-- T-SQL GROUP BY MONTH applying year(), month() datetime functions
SELECT YEAR = YEAR(OrderDate),
       MONTH = MONTH(OrderDate),
       MMM = UPPER(left(DATENAME(MONTH,OrderDate),3)),
       Sales = convert(VARCHAR,floor(sum(TotalDue)),1),
       OrderCount = count(* )
FROM     AdventureWorks2008.Sales.SalesOrderHeader
GROUP BY YEAR(OrderDate),
         MONTH(OrderDate),
         DATENAME(MONTH,OrderDate)
ORDER BY YEAR,
         MONTH
/*
YEAR  MONTH MMM   Sales             OrderCount
2001  7     JUL   1,172,359.00      184
2001  8     AUG   2,605,514.00      231
2001  9     SEP   2,073,058.00      206
2001  10    OCT   1,688,963.00      201
2001  11    NOV   3,690,018.00      259
2001  12    DEC   3,097,637.00      298
2002  1     JAN   1,605,782.00      228
2002  2     FEB   3,130,823.00      250
.....

*/