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