SELECT CONVERT(VARCHAR(10), dtCreateTime, 120) AS dtStatisticsCreateDate, COUNT(1) AS nStatisticsCount
FROM Web_Statistics
WHERE datepart(hh,dtCreateTime)>=10 AND datepart(hh,dtCreateTime)<11 AND dtCreateTime>'2015-01-01' AND dtCreateTime<'2015-01-03'
FROM Web_Statistics
WHERE datepart(hh,dtCreateTime)>=10 AND datepart(hh,dtCreateTime)<11 AND dtCreateTime>'2015-01-01' AND dtCreateTime<'2015-01-03'