SELECT CLASS_NAME AS CLASS, PERSON_NAME AS PERSON, AMT AS HOUSEHOLDS FROM HOUSEHOLD
WHERE (CLASS_CODE, AMT) IN (SELECT CLASS_CODE, MAX(AMT) FROM HOUSEHOLD WHERE PERSON_CODE<>1 GROUP BY CLASS_CODE)
AND PERSON_CODE<>1 AND CLASS_CODE<>'01' ORDER BY CLASS_CODE;