with tmp as(
select CLASS_CODE as CODE, CLASS_NAME as CLASS, PERSON_NAME as PERSON, AMT as HOUSEHOLDS 
from HOUSEHOLD
where PERSON_CODE != '1' and CLASS_CODE != '01'
)
select CLASS, PERSON, HOUSEHOLDS
from tmp h1
where HOUSEHOLDS = (SELECT max(h2.HOUSEHOLDS) FROM tmp h2 WHERE h1.CLASS = h2.CLASS)
order by CODE;