WITH temp AS (
    SELECT
        class_name AS CLASS
        , person_name AS PERSON
        , AMT AS HOUSEHOLD
        , RANK() OVER(PARTITION BY class_name ORDER BY amt DESC) AS rank
    FROM
        household
    WHERE
        person_code != '1'
        AND class_code != '01'
)
SELECT
    CLASS
    , PERSON
    , HOUSEHOLD
FROM
    temp
WHERE
    rank = 1