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