Cacher is the code snippet organizer for pro developers

-- To know first order 
 
 SELECT MIN(OrderDate) FROM Sales.SalesOrderHeader

-- to know latest order

SELECT MAX(OrderDate) FROM Sales.SalesOrderHeader

-- to know orders count by year

SELECT FORMAT( min(OrderDate) , 'yyyy') As [Month],
       Count(*) As Orders
FROM
	Sales.SalesOrderHeader

GROUP BY YEAR(OrderDate)

ORDER BY [Month] DESC