with mx as (
select max(amt) ma from household 
where person_code != 1 and class_code != '01'
group by class_name
)
select household.CLASS_NAME as CLASS, household.PERSON_NAME as PERSON, household.AMT as HOUSEHOLDS from household join mx on household.amt = mx.ma where person_code != 1 and class_code != '01'
order by household.CLASS_CODE asc