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