select CONVERT(date,s.start_time),SUM(itemcount), SUM(request_count), sum(DATEDIFF(SECOND,start_time,finish_time)) from stats s where s.name='temp' group by CONVERT(date,s.start_time)