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