SELECT
    CLASS_NAME AS CLASS,
    PERSON_NAME AS PERSON,
    AMT AS HOUSEHOLDS
FROM
    (
        SELECT
            CLASS_CODE,
            max(AMT) AS AMT
        FROM
            HOUSEHOLD
        WHERE
            PERSON_CODE <> '1'
            AND CLASS_CODE <> '01'
        GROUP BY
            CLASS_CODE
    )sub    
    INNER JOIN HOUSEHOLD
        USING (CLASS_CODE, AMT)
ORDER BY
    CLASS_CODE
;