SELECT
     HH.CLASS_NAME AS CLASS
    ,HH.PERSON_NAME AS PERSON
    ,MAIN.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 MAIN
    LEFT JOIN
        HOUSEHOLD AS HH
    ON
        MAIN.CLASS_CODE = HH.CLASS_CODE
    AND MAIN.AMT = HH.AMT
WHERE
        HH.PERSON_CODE <> '1'
    AND HH.CLASS_CODE <> '01'
ORDER BY
    MAIN.CLASS_CODE ASC