SELECT
    HH.CLASS_NAME AS 'CLASS',
    HH.PERSON_NAME AS 'NAME',
    HH2.AMT AS 'HOUSEHOLDS'
FROM HOUSEHOLD AS HH
JOIN (
    SELECT 
        PERSON_CODE,
        CLASS_CODE,
        MAX(AMT) AS AMT
    FROM HOUSEHOLD
    WHERE
        CLASS_CODE <> '01'
        AND PERSON_CODE <> '1'
    GROUP BY
        CLASS_CODE) AS HH2
    ON
        HH.PERSON_CODE = HH2.PERSON_CODE
        AND HH.CLASS_CODE = HH2.CLASS_CODE
WHERE
    HH.CLASS_CODE <> '01'
    AND HH.PERSON_CODE <> '1'
GROUP BY
    CLASS_NAME
ORDER BY
    HH.CLASS_CODE