SELECT 
    CLASS_NAME AS CLASS ,
    PERSON_NAME AS PERSON ,
    AMT AS HOUSEHOLDS
FROM
    HOUSEHOLD AS  HOUSEHOLD_1
    INNER JOIN (
                SELECT
                    CLASS_NAME AS CLASS_NAME_2 ,
                    PERSON_NAME AS PERSON_NAME_2 ,
                    MAX(AMT) AS MAX_AMT
                FROM 
                    HOUSEHOLD
                WHERE 
                    PERSON_CODE <> '1' AND 
                    CLASS_CODE <> '01'
                GROUP BY
                    CLASS_NAME
                ) AS  HOUSEHOLD_2
    ON 
        HOUSEHOLD_1.CLASS_NAME = HOUSEHOLD_2.CLASS_NAME_2 AND
        HOUSEHOLD_1.AMT = HOUSEHOLD_2.MAX_AMT
ORDER BY 
    CLASS_CODE