SELECT A.CLASS_NAME AS CLASS, B.PERSON_NAME AS PERSON, MAX(A.AMT) AS HOUSEHOLDS
FROM HOUSEHOLD A
INNER JOIN HOUSEHOLD B
ON A.PERSON_CODE=B.PERSON_CODE AND A.CLASS_CODE=B.CLASS_CODE
WHERE A.PERSON_CODE!='1' AND A.CLASS_CODE!='01'
GROUP BY A.CLASS_CODE, A.CLASS_NAME
ORDER BY A.CLASS_CODE ASC