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