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
) AS HH
JOIN HOUSEHOLD USING(CLASS_CODE, AMT)
ORDER BY CLASS_CODE;