WITH table1 AS (
select
    CLASS_NAME AS CLASS
    ,PERSON_NAME AS PERSON
    ,AMT AS HOUSEHOLDS
    ,CLASS_CODE
FROM
HOUSEHOLD
WHERE
    PERSON_CODE != "1"
    AND
    CLASS_CODE != "01"
)

SELECT
    CLASS
    ,PERSON
    ,MAX(HOUSEHOLDS)  AS HOUSEHOLDS
FROM
    table1
GROUP BY 1
ORDER BY CLASS_CODE;