WITH tmp AS(
SELECT
CLASS_CODE,
CLASS_NAME AS CLASS,
PERSON_NAME AS PERSON,
SUM(AMT) AS AMT
FROM HOUSEHOLD
WHERE PERSON_CODE != "1" AND CLASS_CODE != "01"
GROUP BY CLASS,PERSON
),
tmp2 AS(
SELECT
CLASS_CODE,
CLASS,
PERSON,
AMT,
MAX(AMT) OVER(PARTITION BY CLASS) AS HOUSEHOLDS
FROM tmp
)
SELECT 
CLASS,PERSON,HOUSEHOLDS
FROM tmp2 WHERE AMT = HOUSEHOLDS
ORDER BY CLASS_CODE