with temp1 as(
    select
        PERSON_CODE
        , CLASS_CODE
        , AMT
    from
        HOUSEHOLD
    where
        PERSON_CODE != '1'
        and CLASS_CODE != '01'
        and AMT is not null
) , temp2 as (
    select
        PERSON_CODE
        , CLASS_CODE
        , max(AMT)
    from
        temp1
    group by
        CLASS_CODE
)
select
    CLASS_NAME as CLASS
    , PERSON_NAME as PERSON
    , AMT as HOUSEHOLDS
from
    temp2 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
;