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