with house_list as (
    select
        PERSON_CODE,
        CLASS_CODE,
        PERSON_NAME,
        CLASS_NAME,
        AMT
    from 
        HOUSEHOLD
    where
        PERSON_CODE <> '1' and
        CLASS_CODE <> '01'
)

select
    CLASS_NAME as CLASS,
    PERSON_NAME as PERSON,
    max(AMT) as HOUSEHOLDS
from 
    house_list
group by 
    CLASS_CODE