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

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