with TMP as (
    select CLASS_CODE, MAX(AMT) as maxamt from HOUSEHOLD
    where PERSON_CODE <> '1'
    group by CLASS_CODE
)

select CLASS_NAME as CLASS, PERSON_NAME as PERSON, amt as HOUSEHOLDS
from HOUSEHOLD
inner join TMP on HOUSEHOLD.CLASS_CODE = TMP.CLASS_CODE AND HOUSEHOLD.amt = TMP.maxamt
where HOUSEHOLD.CLASS_CODE <> '01' AND HOUSEHOLD.PERSON_CODE <> '1'
order by HOUSEHOLD.CLASS_CODE