with p as (
    select
        class_code
        ,class_name as CLASS
        ,person_name as PERSON
        ,amt as HOUSEHOLDS
        ,max(amt) over (partition by class_name) as MAX
    from
        household
    where
        person_code != '1'
        and class_code != '01'
)

select
    p.CLASS
    ,p.PERSON
    ,p.HOUSEHOLDS
from
    p
where
    p.HOUSEHOLDS = p.MAX
order by
    p.class_code asc