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;