SELECT 
CLASS_NAME CLASS
,PERSON_NAME PERSON
,AMT HOUSEHOLDS
FROM (SELECT 
        CLASS_CODE
        ,PERSON_NAME
        ,CLASS_NAME
        ,AMT
        ,row_number() over (partition by CLASS_NAME order by AMT desc) RANK
        FROM HOUSEHOLD
        WHERE PERSON_CODE <> '1'
        AND CLASS_CODE<> '01'
        ORDER BY CLASS_CODE) A
WHERE RANK = 1
ORDER BY CLASS_CODE