;SELECT
A.CLASS_NAME AS CLASS
,A.PERSON_NAME AS PERSON
,A.AMT AS HOUSEHOLDS
from
HOUSEHOLD A
where
A.PERSON_CODE != '1'--(総数)
AND A.CLASS_CODE != '01'--(総数)
AND A.AMT = (
    SELECT
    MAX(B.AMT)
    FROM
    HOUSEHOLD B
    WHERE
    A.CLASS_CODE = B.CLASS_CODE
    AND  B.PERSON_CODE != '1'--(総数)
    AND B.CLASS_CODE != '01'--(総数)
    GROUP BY B.CLASS_CODE
)
ORDER BY
A.CLASS_CODE
;