[Mr. Jeeves]

Should we require all metaphors on FR to be posted in SQL? ;)

[Lazamataz]

SELECT NAME, SSN, POLITICAL_PARTY FROM 
(SELECT NAME, SSN, ADDRESS, YEARLY_INCOME, POLITICAL_PARTY from TAXPAYER
left outer join KNOWN_CORRUPT_OFFICIALS on SSN,
KNOWN_SCAMS b
where EMPLOYER = 'NOLA' 
and OCCUPATION = 'Police'
AND b.SCAMLOCATION = 'NOLA') A
GROUP BY POLITICAL PARTY, NAME, SSN
ORDER BY POLITICAL PARTY, NAME, SSN