with mx as (
select class_name, 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 and household.class_name = mx.class_name where person_code != 1 and class_code != '01'
order by household.CLASS_CODE asc