Summary Financial Report by NAICS
SELECT CONCAT(b.naics4,': ',b.naicsName) AS NAICS, count(*) as Number_of_Orgs, sum(totrev) as Total_Revenue, sum(DirSupEstimate) as Private_Direct_Contributions, sum(ass_eoy) as Total_Assets, sum(fundbal) as Net_Assets from nccs.core2008pc a LEFT JOIN lookup.naics4ntee3Xwalk b ON LEFT(a.nteeFinal,3)=b.ntee3 GROUP BY b.naics4;