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