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