with t1 as
(
select
    *
from
    HOUSEHOLD
where
    PERSON_CODE <> '1'
    and CLASS_CODE <> '01'
),
t_max as
(
    select
        CLASS_CODE
        ,max(AMT) as AMT
    from
        t1
    group by
        CLASS_CODE
)

select
    CLASS_NAME as CLASS
    ,PERSON_NAME as PERSON
    ,AMT as HOUSEHOLDS
from
    t1
where
    1=1
    and EXISTS(
        select
            *
        from
            t_max
        where t1.CLASS_CODE = t_max.CLASS_CODE and t1.AMT = t_max.AMT
    )
order by 
    CLASS_CODE asc