sqlserver 统计每个类型的每天的总数

SELECT
	type,
	CONVERT ( VARCHAR ( 100 ), t.create_time, 23 ) [date],
	COUNT ( id ) num 
FROM
	crawler_property t 
WHERE
	1 = 1 
GROUP BY
	type,
	CONVERT ( VARCHAR ( 100 ), t.create_time, 23 ) 
ORDER BY
	type,
	CONVERT ( VARCHAR ( 100 ), t.create_time, 23 )