WITH T1 AS (
    SELECT *
    FROM HOUSEHOLD
    WHERE PERSON_CODE <> "1" AND CLASS_CODE <> "01"
)
SELECT CLASS_NAME AS CLASS, PERSON_NAME AS PERSON, AMT AS HOUSEHOLDS
FROM T1 AS A
WHERE AMT = (
    SELECT MAX(AMT) FROM T1 AS B
    WHERE A.CLASS_CODE = B.CLASS_CODE
)
ORDER BY CLASS_CODE