SELECT YEAR([OrderDate]) AS 'Year',
	   MONTH([OrderDate]) AS 'Month',
	   DAY([OrderDate]) AS 'Day',
	   COUNT(*) 'Amount of orders',
	   SUM([SubTotal]) 'Total Price'
FROM [Sales].[SalesOrderHeader]
LEFT JOIN [Sales].[SalesOrderDetail]
	ON [Sales].[SalesOrderDetail].[SalesOrderID] = [Sales].[SalesOrderHeader].[SalesOrderID]
GROUP BY YEAR([OrderDate]),
		 MONTH([OrderDate]),
		 DAY([OrderDate])
ORDER BY YEAR([OrderDate]),
		 MONTH([OrderDate]),
		 DAY([OrderDate]);