UPDATE nccs.nteedocNoEin c, lookup.lu_zip2006 z SET c.fips = z.fips where c.zip5 = z.zip5
UPDATE nccs.nteedocNoEin c SET c.nteefinal = 'B29' WHERE STATE='DC' AND name like '% PCS%'
UPDATE nccs.nteedocNoEin c SET c.nteefinal = 'B24' WHERE STATE='DC' AND CONCAT(' ',name,' ') like '% ES %'
UPDATE nccs.nteedocNoEin c SET c.nteefinal = 'B25M' WHERE STATE='DC' AND CONCAT(' ',name,' ') like '% MS %' 
UPDATE nccs.nteedocNoEin c SET c.nteefinal = 'B25' WHERE STATE='DC' AND CONCAT(' ',name,' ') like '% HS %' 
UPDATE nccs.nteedocNoEin c SET c.nteefinal = 'B25' WHERE STATE='DC' AND CONCAT(' ',name,' ') like '%SHS %' 
SELECT COUNT(*) FROM nccs.nteedocNoEin  WHERE STATE='DC' AND NTEEFINAL LIKE 'B2%'
SELECT zip5, COUNT(*) FROM nccs.nteedocNoEin  WHERE STATE='DC' AND NTEEFINAL LIKE 'B2%' group by zip5

