SELECT CLASS_NAME AS CLASS, PERSON_NAME AS PERSON, AMT AS HOUSEHOLDS
    FROM HOUSEHOLD AS H1
        INNER JOIN (SELECT CLASS_CODE, MAX(AMT) AS MAX_AMT FROM HOUSEHOLD WHERE PERSON_CODE!='1' AND CLASS_CODE!='01' GROUP BY CLASS_CODE) AS H2
        ON H1.CLASS_CODE=H2.CLASS_CODE
    WHERE H1.AMT=H2.MAX_AMT AND H1.PERSON_CODE!='1' AND H1.CLASS_CODE!='01'
    ORDER BY H1.CLASS_CODE ASC;