select sum(case when [date] between '2002-12-10' and '2003-1-10' then 1 else 0 end) as 'data1',sum(case when [date] between '2003-1-10' and '2003-2-10' then 1 else 0 end) as 'data2',...,sum(case when [date] between '2003-11-10' and '2003-12-10' then 1 else 0 end) as 'data12' from yourtable