select 
b.CLASS_NAME as CLASS
,b.PERSON_NAME as PERSON
,HOUSEHOLDS

from
(select CLASS_CODE, max(AMT) as HOUSEHOLDS
from HOUSEHOLD
where not (PERSON_CODE = '1' 
or CLASS_CODE = '01')
group by CLASS_CODE) a
inner join HOUSEHOLD b
on a.CLASS_CODE = b.CLASS_CODE
and HOUSEHOLDS = b.AMT
order by b.CLASS_CODE