Number of Organizations by Legal Type and Revenue

SELECT CASE WHEN subseccd = '03' and fndncd not in ('02','03','04') and cTotRev >= 50000 then 'Public Charity 990/Ez Filers With $50,000+ Revenue' WHEN subseccd = '03' and fndncd not in ('02','03','04') and cTotRev > 0 then 'Public Charity 990/Ez Filers -- Smaller' WHEN subseccd = '03' and fndncd not in ('02','03','04') and ifnull(cTotRev,0) = 0 then 'Public Charity Epostcard Filers OR Non-Filers' WHEN subseccd = '03' and fndncd in ('02','03','04') then 'Private Foundations' else 'Non-501(C)(3)s' end as Category, count(*) as Number_Registered_Organizations from nccs.nteedocAllEins where latestBMF = 1 AND fips='12009' GROUP BY Category;