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
;