select
a.CLASS_NAME as  CLASS
,a.PERSON_NAME as  PERSON
,a.AMT as HOUSEHOLDS
from HOUSEHOLD a
join 
(
select
CLASS_CODE
,max(AMT) as HOUSEHOLDS
from HOUSEHOLD where PERSON_CODE  <> '1' and CLASS_CODE <> '01'
group by CLASS_CODE 
) b on a.CLASS_CODE=b.CLASS_CODE and a.AMT =b.HOUSEHOLDS
 where a.PERSON_CODE  <> '1' and a.CLASS_CODE <> '01'
 order by a.CLASS_CODE