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