with base as (
select
    PERSON_CODE
    ,CLASS_CODE
    ,PERSON_NAME
    ,CLASS_NAME
    ,AMT
    ,rank() over(partition by class_code order by AMT desc) as RANK_
from
    HOUSEHOLD
where
    PERSON_CODE!=1 and CLASS_CODE!="01"
)
select
    CLASS_NAME as CLASS
    ,PERSON_NAME as PERSON
    ,AMT as HOUSEHOLDS
from
    base
WHERE
    RANK_=1
order by
    CLASS_CODE