try with nerd Sri lanak http://nerdc.lk/en/sub_pgs/2_projects_Success_details.php?pid=80
http://nerdc.lk/rdb/upload/Industrial%20Type%20Coconut%20De.pdf
SELECT DATEPART(yy, [birthday]) AS [Year],DATEPART(MM, [birthday]) AS [Month],Count([birthday]) AS [Count]
FROM [dbo].[testt]
group by DATEPART(yy, [birthday]),DATEPART(MM, [birthday])