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