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