SELECT
    H1.CLASS_NAME AS CLASS
    , H1.PERSON_NAME AS PERSON
    , H1.AMT AS HOUSEHOLDS 
FROM
    HOUSEHOLD AS H1 ,
        (SELECT
            CLASS_CODE,MAX(AMT) AMT
        FROM
            HOUSEHOLD 
        WHERE
            CLASS_CODE <> '01' 
            AND PERSON_CODE <> '1' 
        GROUP BY
            CLASS_CODE) H2
WHERE
    H1.CLASS_CODE = H2.CLASS_CODE
    AND H1.AMT = H2.AMT
ORDER BY
    H1.CLASS_CODE;