SELECT
    T01.CLASS_NAME AS CLASS
  , T01.PERSON_NAME AS PERSON
  , T01.AMT AS HOUSEHOLDS
FROM
    HOUSEHOLD T01
, (
SELECT
    CLASS_CODE
  , MAX(AMT) AS 世帯数
FROM
    HOUSEHOLD
WHERE
    PERSON_CODE <> '1'
AND CLASS_CODE <> '01'
GROUP BY
    CLASS_CODE
) T02
WHERE
    T01.CLASS_CODE = T02.CLASS_CODE
AND T01.AMT = T02.世帯数
ORDER BY
    T01.CLASS_CODE ASC