[SQL] Sort Month Name in SQL Query

My Current Query is :

SELECT FORMAT(Date, 'MMM') as 'Date', FORMAT(Date, 'yyy') as 'Year'
,COUNT(*)
as 'Tickets Generated'
FROM [SambaData2].[dbo].[Tickets]
GROUP BY FORMAT(Date, 'MMM'), FORMAT(Date, 'yyy')
ORDER BY Date


It returns the values:



I would like the same query to return sorted month name with Year!

Continue reading...