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