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 )