with target as (
select 
    *
    ,rank() over(partition by CLASS_CODE order by amt desc) as ranking
from HOUSEHOLD h
where PERSON_CODE <> '1' and CLASS_CODE<>'01'
)
select 
    CLASS_NAME as CLASS
    ,PERSON_NAME as PERSON
    ,AMT as HOUSEHOLDS
from target
where ranking=1
order by CLASS_CODE
;