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