with 
t as (
    select 
        class_name
        , max(amt) as max_amt
    from household
    where 
        PERSON_CODE <> '1'
        and CLASS_CODE <> '01'
    group by class_name
)
select 
    CLASS_NAME as CLASS
    , PERSON_NAME as PERSON
    , amt
from HOUSEHOLD
left join t using(class_name)
where 
    household.amt = t.max_amt
order by class_code 
;