with tmp as(
select CLASS_NAME as CL,  max(AMT) as HO
from HOUSEHOLD
where PERSON_CODE<>'1' 
    and CLASS_CODE<>'01'
group by CLASS_NAME
) 

select h.CLASS_NAME as CLASS, h.PERSON_NAME as PERSON, h.AMT as HOUSEHOLDS
from HOUSEHOLD h
left join tmp t
on h.CLASS_NAME = t.CL and h.AMT = t.HO
where 
t.HO is not null
order by h.CLASS_CODE