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_CODE ORDER BY AMT DESC) AS RANKING
        FROM
            HOUSEHOLD
        WHERE
            PERSON_CODE != '1'   -- '総数'以外
            AND
            CLASS_CODE != '01'  -- '総数'以外
        ORDER BY
            CLASS_CODE ASC
    )
WHERE
    RANKING = 1 -- 世帯数が最大
;