with T1 as (select CLASS_CODE,max(AMT) amt from HOUSEHOLD where PERSON_CODE <>'1' and CLASS_CODE <> '01' group by CLASS_NAME)
select
CLASS_NAME as 'CLASS',
PERSON_NAME as 'PERSON',
HOUSEHOLD.amt as 'HOUSEHOLDS'
    from
HOUSEHOLD
inner join T1 on T1.CLASS_CODE=HOUSEHOLD.CLASS_CODE and T1.amt = HOUSEHOLD.amt

where HOUSEHOLD.PERSON_CODE <>'1' and HOUSEHOLD.CLASS_CODE <> '01'
order by HOUSEHOLD.CLASS_CODE