SELECT
        CLASS
        , PERSON
        , HOUSEHOLDS
    FROM
        (
            SELECT
                CLASS_CODE
                , PERSON_CODE
                , PERSON_NAME PERSON
                , CLASS_NAME CLASS
                , AMT HOUSEHOLDS
                , ROW_NUMBER() OVER (
                    PARTITION BY CLASS_CODE
                    ORDER BY AMT DESC) AS PRIORITY
            FROM
                HOUSEHOLD
            WHERE
                CLASS_CODE <>'01'
                AND PERSON_CODE <> '1'
        ) T
    WHERE
        PRIORITY = 1
    ORDER BY
        CLASS_CODE
;