Community Platform

Number and Expenses of Reporting Public Charities, 2015

Elapsed time: 10:34:29 - fin: 10:34:29

SELECT CASE WHEN EXPS < 100000 THEN 'a. Under $100,000' WHEN EXPS < 500000 THEN 'b. $100,000 to $499,999' WHEN EXPS < 1000000 THEN 'c. $500,000 to $999,999' WHEN EXPS < 5000000 THEN 'd. $1 million to $4.99 million' WHEN EXPS < 10000000 THEN 'e. $5 million to $9.99 million' WHEN EXPS >= 10000000 THEN 'f. $10 million or more' ELSE 'ERROR' END AS EXPENSE_SIZE, COUNT(EIN) AS Number, SUM(EXPS) AS Total_Expenses FROM nccs.CoreEfile2015_pc A WHERE (A.OUTNCCS IS NULL OR A.OUTNCCS <> 'OUT') AND A.FNDNCD NOT IN ('02','03','04') AND GRREC >=50000 AND fips='12009' GROUP BY EXPENSE_SIZE