WITH TMP_HOUSEHOLD AS (
    SELECT
        CLASS_NAME,
        MAX(AMT) AS AMT
    FROM
        HOUSEHOLD
    WHERE
        PERSON_CODE != '1'
        AND CLASS_CODE != '01'
    GROUP BY
        CLASS_NAME
    ORDER BY
        CLASS_CODE ASC
)

SELECT
    T_H.CLASS_NAME AS CLASS,
    H.PERSON_NAME AS PERSON,
    T_H.AMT AS HOUSEHOLDS
FROM
    TMP_HOUSEHOLD T_H
    INNER JOIN HOUSEHOLD H
     ON H.CLASS_NAME = T_H.CLASS_NAME
     AND H.AMT = T_H.AMT
;