WITH max_setai 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 ranks
    FROM
        HOUSEHOLD
    WHERE
        PERSON_CODE != '1'
        AND
        CLASS_CODE != '01'
)
SELECT
    CLASS
    , PERSON
    , HOUSEHOLDS
FROM
    max_setai
WHERE
    ranks = 1
ORDER BY
    CLASS_CODE
;