WITH r_table AS
(SELECT
 CLASS_NAME AS CLASS,
 PERSON_NAME AS PERSON,
 AMT,
 ROW_NUMBER()OVER(PARTITION BY CLASS_NAME ORDER BY AMT DESC) AS rn
FROM
 HOUSEHOLD
WHERE
 PERSON_CODE <> '1'
AND
 CLASS_CODE <> '01'
ORDER BY
 CLASS_CODE
)
SELECT
 CLASS,
 PERSON,
 AMT AS HOUSEHOLDS
FROM
 r_table
WHERE
 rn = 1