SELECT 
    CLASS_NAME AS CLASS
    ,PERSON_NAME AS PERSON
    ,AMT AS HOUSEHOLDS
FROM HOUSEHOLD HH1
--世帯人員コード(PERSON_CODE) = '1'(総数)、および、所得階層コード(CLASS_CODE) = '01'(総数)のレコードは対象外
WHERE PERSON_CODE <> '1'
AND CLASS_CODE <> '01'
AND AMT = (
    SELECT MAX(AMT)
    FROM HOUSEHOLD HH2
    WHERE HH1.CLASS_CODE = HH2.CLASS_CODE 
    AND HH2.CLASS_CODE <> '01' 
    AND HH2.PERSON_CODE <> '1' 
    GROUP BY  HH2.CLASS_CODE
)
ORDER BY HH1.CLASS_CODE;