select
    class_name as CLASS,
    person_name as PERSON,
    HOUSEHOLDS
from (
    select
        class_name,
        class_code,
        person_name,
        amt as HOUSEHOLDS,
        row_number() 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_code,
        class_name,
        person_name,
        rank
)
where
    rank = 1
order by
    class_code asc