select
    class_name as class,
    person_name as person,
    households
from (
    select
        class_name,
        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