number of product orders received by month and year - Cacher Snippet

3/11/2017 - 5:51 PM

number of product orders received by month and year

number of product orders received by month and year

Superstore_2.SQL

--  Orders recieved by month and year

SELECT YEAR([Order Date]) As 'Year' ,
       month([Order Date]) As ' Month',
	   count( [Order ID]) As ' Orders Recieved'
	   FROM Orders
GROUP BY Year([Order Date]),MONTH( [Order Date])
Order BY Year([Order Date]) , Month([Order Date])