How complete are Charity Commission returns
Owned by david, visibility: Public
select case when extract(month from fin_period_end_date) < 4 then concat(extract(year from fin_period_end_date)-1,'-',extract(year from fin_period_end_date)) else concat(extract(year from fin_period_end_date),'-',extract(year from fin_period_end_date)+1) end as "Financial year", count(*) filter (where extract(month from fin_period_end_date)=4) as "April", count(*) filter (where extract(month from fin_period_end_date)=5) as "May", count(*) filter (where extract(month from fin_period_end_date)=6) as "June", count(*) filter (where extract(month from fin_period_end_date)=7) as "July", count(*) filter (where extract(month from fin_period_end_date)=8) as "August", count(*) filter (where extract(month from fin_period_end_date)=9) as "September", count(*) filter (where extract(month from fin_period_end_date)=10) as "October", count(*) filter (where extract(month from fin_period_end_date)=11) as "November", count(*) filter (where extract(month from fin_period_end_date)=12) as "December", count(*) filter (where extract(month from fin_period_end_date)=1) as "January", count(*) filter (where extract(month from fin_period_end_date)=2) as "February", count(*) filter (where extract(month from fin_period_end_date)=3) as "March", count(*) as "All data" from charity_ccewcharityarparta where total_gross_income is not null group by "Financial year"
17 rows
Duration: 810.38ms
select case when extract(month from fin_period_end_date) < 4 then concat(extract(year from fin_period_end_date)-1,'-',extract(year from fin_period_end_date)) else concat(extract(year from fin_period_end_date),'-',extract(year from fin_period_end_date)+1) end as "Financial year", count(*) filter (where extract(month from fin_period_end_date)=4) as "April", count(*) filter (where extract(month from fin_period_end_date)=5) as "May", count(*) filter (where extract(month from fin_period_end_date)=6) as "June", count(*) filter (where extract(month from fin_period_end_date)=7) as "July", count(*) filter (where extract(month from fin_period_end_date)=8) as "August", count(*) filter (where extract(month from fin_period_end_date)=9) as "September", count(*) filter (where extract(month from fin_period_end_date)=10) as "October", count(*) filter (where extract(month from fin_period_end_date)=11) as "November", count(*) filter (where extract(month from fin_period_end_date)=12) as "December", count(*) filter (where extract(month from fin_period_end_date)=1) as "January", count(*) filter (where extract(month from fin_period_end_date)=2) as "February", count(*) filter (where extract(month from fin_period_end_date)=3) as "March", count(*) as "All data" from charity_ccewcharityannualreturnhistory group by "Financial year"
21 rows
Duration: 1162.38ms
select extract(year from fin_period_end_date) as "Calendar year", count(*) filter (where extract(month from fin_period_end_date)=1) as "January", count(*) filter (where extract(month from fin_period_end_date)=2) as "February", count(*) filter (where extract(month from fin_period_end_date)=3) as "March", count(*) filter (where extract(month from fin_period_end_date)=4) as "April", count(*) filter (where extract(month from fin_period_end_date)=5) as "May", count(*) filter (where extract(month from fin_period_end_date)=6) as "June", count(*) filter (where extract(month from fin_period_end_date)=7) as "July", count(*) filter (where extract(month from fin_period_end_date)=8) as "August", count(*) filter (where extract(month from fin_period_end_date)=9) as "September", count(*) filter (where extract(month from fin_period_end_date)=10) as "October", count(*) filter (where extract(month from fin_period_end_date)=11) as "November", count(*) filter (where extract(month from fin_period_end_date)=12) as "December", count(*) as "All data" from charity_ccewcharityannualreturnhistory group by "Calendar year"
Duration: 1024.34ms