WITH
max_amt AS(
SELECT
    CLASS_NAME,
    MAX(AMT) MAX_AMT
FROM HOUSEHOLD
WHERE
    PERSON_CODE != "1"
AND
    CLASS_CODE != "01"
GROUP BY 1
)
SELECT
    CLASS_NAME AS CLASS,
    PERSON_NAME AS PERSON,
    AMT AS HOUSEHOLDS
FROM HOUSEHOLD
LEFT JOIN max_amt
USING(CLASS_NAME)
WHERE
    AMT = MAX_AMT
ORDER BY CLASS_CODE