SELECT DATEPART(YY, TOHOSPITAL_TIME), (DATEPART(MM,TOHOSPITAL_TIME)-1)/6, COUNT( *)
FROM TOHOSPITAL_TBL
group by DATEPART(YY, TOHOSPITAL_TIME), (DATEPART(MM,TOHOSPITAL_TIME)-1)/6
FROM TOHOSPITAL_TBL
group by DATEPART(YY, TOHOSPITAL_TIME), (DATEPART(MM,TOHOSPITAL_TIME)-1)/6