select CLASS_NAME as CLASS, PERSON_NAME as PERSON,AMT as HOUSEHOLDS
from HOUSEHOLD a
where a.PERSON_CODE!='1'
and a.CLASS_CODE!='01'
and a.AMT=(select MAX(AMT)
from HOUSEHOLD b
where PERSON_CODE != '1'
and CLASS_CODE!='01'
and a.CLASS_CODE=b.CLASS_CODE
group by CLASS_CODE)
order by CLASS_CODE