SELECT SUB.CLASS_NAME AS CLASS, SUB.PERSON_NAME AS PERSON, SUB.AMT AS HOUSEHOLDS
FROM (
    SELECT CLASS_NAME, CLASS_CODE, PERSON_NAME, AMT, RANK() OVER(PARTITION BY CLASS_NAME ORDER BY AMT DESC) AS RANK
    FROM HOUSEHOLD
    WHERE PERSON_CODE <> "1" AND CLASS_CODE <> "01"
) AS SUB
WHERE RANK = 1
ORDER BY SUB.CLASS_CODE;