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