select CLASS_NAME as CLASS, PERSON_NAME as PERSON, AMT as HOUSEHOLDS
from HOUSEHOLD
where PERSON_CODE <> '1'
    and CLASS_CODE <> '01'
    and AMT in (select max(AMT) from HOUSEHOLD where PERSON_CODE<>'1' and CLASS_CODE<>'01' group by CLASS_CODE)
--group by CLASS_CODE
order by CLASS_CODE