select
    CLASS_NAME as CLASS
    , PERSON_NAME as PERSON
    , AMT as HOUSEHOLDS
from (
    select 
        PERSON_CODE
        , CLASS_CODE
        , PERSON_NAME
        , CLASS_NAME
        , AMT
        , row_number() over(partition by CLASS_NAME order by AMT desc) rn
    from HOUSEHOLD
    where PERSON_CODE!='1' and CLASS_CODE!='01'
    )
where rn=1
order by CLASS_CODE desc