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.PERSON_CODE != '1' 
            AND H2.CLASS_CODE != '01'
        GROUP BY
            H2.CLASS_CODE
        )
ORDER BY 
    H1.CLASS_CODE ASC
;