SELECT CLASS_NAME CLASS,
    PERSON_NAME PERSON,
    AMT HOUSEHOLDS
FROM (
        SELECT CLASS_NAME,
            PERSON_NAME,
            AMT,
            CLASS_CODE,
            PERSON_CODE,
            rank() OVER(
                PARTITION BY CLASS_CODE
                ORDER BY AMT DESC
            ) as rank_amt
        FROM HOUSEHOLD
        where CLASS_CODE <> '01'
            and PERSON_CODE <> '1'
    )
WHERE rank_amt = 1
-- GROUP BY CLASS_CODE
ORDER BY CLASS_CODE