select
    class_name as CLASS,
    person_name as PERSON,
    households as HOUSEHOLDS
from (
    select
        class_name,
        class_code,
        person_name,
        max(amt) as households,
        row_number() over(partition by class_name order by max(amt) desc) as rank
    from
        household
    where
        person_code != "1"
        and class_code != "01"
    group by
        class_name,
        person_name
)
where
    rank = 1
order by
    class_code asc