select
    CLASS, max(case when r=1 then pn else null end) as PERSON, max(case when r=1 then amt else null end) as HOUSEHOLDS
from (
    select class_name as CLASS, PERSON_NAME as pn, rank() over (partition by class_code order by AMT desc) as r, amt, CLASS_CODE
    from HOUSEHOLD where CLASS_CODE!='01'and PERSON_CODE!='1'
) as t
group by CLASS
order by t.CLASS_CODE asc