SELECT
    CLASS_NAME AS CLASS
    , PERSON_NAME AS PERSON
    , AMT AS HOUSEHOLDS
FROM
    (
        SELECT
            PERSON_CODE
            , CLASS_CODE
            , PERSON_NAME
            , CLASS_NAME
            , AMT
            , row_number() over (
                PARTITION BY
                    CLASS_NAME
                ORDER BY
                    AMT DESC
            ) AS RANK
        FROM
            HOUSEHOLD
        WHERE
            PERSON_CODE != '1'
            AND CLASS_CODE != '01'
    )
GROUP BY
    CLASS_NAME
ORDER BY
    CLASS_CODE ASC
;