with temp1 as(
    select
        PERSON_CODE
        , CLASS_CODE
        , AMT
    from
        HOUSEHOLD
    where
        PERSON_CODE != '1'
        and CLASS_CODE != '01'
) , temp2 as (
    select
        CLASS_CODE
        , max(AMT) as MAX_AMT
    from
        temp1
    group by
        CLASS_CODE
) , temp3 as(
    select
        PERSON_CODE
        , CLASS_CODE
        , AMT
    from
        temp1
    where
        CLASS_CODE || AMT in (select CLASS_CODE || MAX_AMT from temp2)
)
select
    CLASS_NAME as CLASS
    , PERSON_NAME as PERSON
    , t.AMT as HOUSEHOLDS
from
    temp3 t
    inner join HOUSEHOLD h on t.PERSON_CODE = h.PERSON_CODE and t.CLASS_CODE = h.CLASS_CODE
order by
    t.CLASS_CODE asc
;