Fazer consulta para agrupar dados por mes

Segue: 8)


drop table nova;

create temp table nova (data date, valor decimal(10,2));

insert into nova values (´01/05/2009´,200.00);
insert into nova values (´26/05/2009´,133.00);
insert into nova values (´05/06/2009´,25.00);
insert into nova values (´30/01/2009´,13.00);

select *from nova;

select month(data) meses,
sum(case when month(data) = 1 then valor
when month(data) = 2 then valor
when month(data) = 3 then valor
when month(data) = 4 then valor
when month(data) = 5 then valor
when month(data) = 6 then valor
when month(data) = 7 then valor
when month(data) = 8 then valor
when month(data) = 9 then valor
when month(data) = 10 then valor
when month(data) = 11 then valor
when month(data) = 12 then valor end )as valor
from nova
group by 1

union all

select distinct 2 as meses,0.00
from nova

union all

select distinct 3 as meses,0.00
from nova

union all

select distinct 4 as meses,0.00
from nova

union all

select distinct 7 as meses,0.00
from nova

union all

select distinct 8 as meses,0.00
from nova

union all

select distinct 9 as meses,0.00
from nova

union all

select distinct 10 as meses,0.00
from nova

union all

select distinct 11 as meses,0.00
from nova

union all

select distinct 12 as meses,0.00
from nova

order by 1