Use the Instant SQL Formatter to Format the SQL below. Just copy and paste into the Formatter at: http://www.dpriver.com/pp/sqlformat.htm
SELECT DISTINCT a.eeo_cls,
a.classification,
(SELECT Count(b.prem_emp)
FROM #ee05temp b
WHERE b.[hispanic or latino] = 1
AND b.prem_gender = 'M'
AND b.eeo_cls = a.eeo_cls) AS 'M-H',
(SELECT Count(b.prem_emp)
FROM #ee05temp b
WHERE b.[hispanic or latino] = 1
AND b.prem_gender = 'F'
AND b.eeo_cls = a.eeo_cls) AS 'F-H',
(SELECT Count(b.prem_emp)
FROM #ee05temp b
WHERE b.[white] = 1
AND b.[hispanic or latino] <> 1
AND b.[black or african american] <> 1
AND b.asian <> 1
AND b.[native hawaiian or other pacific islander] <> 1
AND b.[american indian or alaska native] <> 1
AND b.prem_gender = 'M'
AND b.eeo_cls = a.eeo_cls) AS 'M-W',
(SELECT Count(b.prem_emp)
FROM #ee05temp b
WHERE b.[black or african american] = 1
AND b.[hispanic or latino] <> 1
AND b.[white] <> 1
AND b.asian <> 1
AND b.[native hawaiian or other pacific islander] <> 1
AND b.[american indian or alaska native] <> 1
AND b.prem_gender = 'M'
AND b.eeo_cls = a.eeo_cls) AS 'M-B',
(SELECT Count(b.prem_emp)
FROM #ee05temp b
WHERE b.[asian] = 1
AND b.[hispanic or latino] <> 1
AND b.[white] <> 1
AND b.[black or african american] <> 1
AND b.[native hawaiian or other pacific islander] <> 1
AND b.[american indian or alaska native] <> 1
AND b.prem_gender = 'M'
AND b.eeo_cls = a.eeo_cls) AS 'M-A',
(SELECT Count(b.prem_emp)
FROM #ee05temp b
WHERE b.[native hawaiian or other pacific islander] = 1
AND b.[hispanic or latino] <> 1
AND b.[white] <> 1
AND b.[black or african american] <> 1
AND b.[asian] <> 1
AND b.[american indian or alaska native] <> 1
AND b.prem_gender = 'M'
AND b.eeo_cls = a.eeo_cls) AS 'M-H',
(SELECT Count(b.prem_emp)
FROM #ee05temp b
WHERE b.[american indian or alaska native] = 1
AND b.[hispanic or latino] <> 1
AND b.[white] <> 1
AND b.[black or african american] <> 1
AND b.[asian] <> 1
AND b.[native hawaiian or other pacific islander] <> 1
AND b.prem_gender = 'M'
AND b.eeo_cls = a.eeo_cls) AS 'M-I',
(SELECT Count(b.prem_emp)
FROM #ee05temp b
WHERE b.[white] = 1
AND b.[hispanic or latino] <> 1
AND b.[black or african american] <> 1
AND b.asian <> 1
AND b.[native hawaiian or other pacific islander] <> 1
AND b.[american indian or alaska native] <> 1
AND b.prem_gender = 'F'
AND b.eeo_cls = a.eeo_cls) AS 'F-W',
(SELECT Count(b.prem_emp)
FROM #ee05temp b
WHERE b.[black or african american] = 1
AND b.[hispanic or latino] <> 1
AND b.[white] <> 1
AND b.asian <> 1
AND b.[native hawaiian or other pacific islander] <> 1
AND b.[american indian or alaska native] <> 1
AND b.prem_gender = 'F'
AND b.eeo_cls = a.eeo_cls) AS 'F-B',
(SELECT Count(b.prem_emp)
FROM #ee05temp b
WHERE b.[asian] = 1
AND b.[hispanic or latino] <> 1
AND b.[white] <> 1
AND b.[black or african american] <> 1
AND b.[native hawaiian or other pacific islander] <> 1
AND b.[american indian or alaska native] <> 1
AND b.prem_gender = 'F'
AND b.eeo_cls = a.eeo_cls) AS 'F-A',
(SELECT Count(b.prem_emp)
FROM #ee05temp b
WHERE b.[native hawaiian or other pacific islander] = 1
AND b.[hispanic or latino] <> 1
AND b.[white] <> 1
AND b.[black or african american] <> 1
AND b.[asian] <> 1
AND b.[american indian or alaska native] <> 1
AND b.prem_gender = 'F'
AND b.eeo_cls = a.eeo_cls) AS 'F-H',
(SELECT Count(b.prem_emp)
FROM #ee05temp b
WHERE b.[american indian or alaska native] = 1
AND b.[hispanic or latino] <> 1
AND b.[white] <> 1
AND b.[black or african american] <> 1
AND b.[asian] <> 1
AND b.[native hawaiian or other pacific islander] <> 1
AND b.prem_gender = 'F'
AND b.eeo_cls = a.eeo_cls) AS 'F-I',
(SELECT Count(C.prem_emp)
FROM #ee05_multiple C
WHERE C.prem_gender = 'M'
AND C.eeo_cls = a.eeo_cls) AS 'M-O',
(SELECT Count(C.prem_emp)
FROM #ee05_multiple C
WHERE C.prem_gender = 'F'
AND C.eeo_cls = a.eeo_cls) AS 'F-O'
FROM #ee05temp a
INNER JOIN #ee05temp b
ON a.prem_emp = b.prem_emp
INNER JOIN #ee05_multiple
ON a.prem_emp = b.prem_emp
GROUP BY a.classification,
a.eeo_cls
ORDER BY a.eeo_cls
