with t1 as(
select max(AMT) as max from HOUSEHOLD where PERSON_CODE != '1' and CLASS_CODE != '01' group by CLASS_CODE
)
select CLASS_NAME as CLASS, PERSON_NAME as PERSON, AMT as HOUSEHOLDS from HOUSEHOLD 
inner join t1
on HOUSEHOLD.AMT = t1.max
order by CLASS_CODE;