WITH HOUSEHOLD2 AS (
    SELECT 
        CLASS_CODE,
        CLASS_NAME,
        PERSON_NAME,
        AMT
    FROM HOUSEHOLD
    WHERE NOT (PERSON_CODE = '1' OR CLASS_CODE = '01')
    ORDER BY CLASS_CODE ASC
)
SELECT 
    CLASS_NAME AS CLASS,
    PERSON_NAME AS PERSON,
    -- AMT AS HOUSEHOLDS
    -- CLASS_CODE,
    MAX(AMT) AS HOUSEHOLDS
FROM HOUSEHOLD2
GROUP BY 
    CLASS_NAME
ORDER BY CLASS_CODE ASC