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