with TBL_MAX as (
select
    CLASS_NAME
    ,PERSON_NAME
    ,AMT
    ,CLASS_CODE
    ,row_number() over (partition by CLASS_NAME order by AMT desc) as RN
from
    HOUSEHOLD
where
    PERSON_NAME <> '総数'
    and CLASS_CODE <> '01'
group by 1,2
)

select
    CLASS_NAME as CLASS
    ,PERSON_NAME as PERSON
    ,AMT as HOUSEHOLDS
from TBL_MAX
where
    RN=1
order by CLASS_CODE