with base as (select
    class_name,
    PERSON_NAME,
    sum(amt) as total_amt,
    ROW_NUMBER() OVER (PARTITION BY class_name ORDER BY sum(amt) DESC) as rank
from
    HOUSEHOLD
where 
    1=1
and PERSON_CODE != '1'
and CLASS_CODE != '01'
group by 
    class_name,
    PERSON_NAME
order by
    class_name,
    PERSON_NAME,
    rank
)
select 
    class_name as CLASS,
    PERSON_NAME as PERSON,
    total_amt as HOUSEHOLDS
 from base where rank = 1
order by CLASS asc
-- limit 10
;