SQL根据时间划分年月日时进行累加、统计列值计算

通过时间列TimeColumn，划分年月日 时，根据ValueColumn列的某个值累加，统计TypesColumn
出现不同值的次数

select CONVERT(varchar, TimeColumn, 112) + ' ' + RIGHT('0' + CONVERT(varchar, DATEPART(hour, TimeColumn), 100), 2) AS [DateTimeGroup],
	SUM(case when ValueColumn=1 then 1 else 0 end) as myMode1,
	SUM(case when ValueColumn=2 then 1 else 0 end) as myMode2,
	COUNT(Distinct TypesColumn) as myTypes
	from myTestTable
	group by CONVERT(varchar, TimeColumn, 112) + ' ' + RIGHT('0' + CONVERT(varchar, DATEPART(hour, TimeColumn), 100), 2)