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