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