SELECT
    TBLM.CLASS_NAME AS CLASS
    ,PERSON_NAME  AS PERSON
    ,AMT AS HOUSEHOLDS
FROM
    HOUSEHOLD AS H
    INNER JOIN
        (
        SELECT
            CLASS_NAME,
            MAX(AMT) AS MAX_AMT
        FROM
            HOUSEHOLD
        WHERE
            PERSON_CODE != '1'
            AND CLASS_CODE != '01'
        GROUP BY 
            CLASS_NAME
        ) AS TBLM
    ON H.CLASS_NAME = TBLM.CLASS_NAME
        AND H.AMT = TBLM.MAX_AMT
ORDER BY
    CLASS_CODE ASC