select
    class_name as CLASS,
    person_name as PERSON,
    amt as HOUSEHOLDS
from (
    select
        *,
        max(amt) over (partition by class_code) as max_amt
    from
        household
    where
        person_code != '1' and class_code != '01'
)
where
    amt = max_amt
order by
    class_code
;