select
    class_name as CLASS,
    person_name as PERSON,
    households as 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"
)
where
    rank = 1
order by
    class_code asc