select
    TBL1.CLASS_NAME as CLASS,
    max(TBL1.PERSON_NAME) as PERSON,
    COL1 as HOUSEHOLDS
from
    HOUSEHOLD as TBL1
left outer join
    (SELECT PERSON_NAME,MAX(AMT) as COL1 FROM HOUSEHOLD where PERSON_CODE<>'1' and CLASS_CODE<>'01' group by PERSON_NAME) as TBL2
    on TBL1.PERSON_NAME=TBL2.PERSON_NAME
where
    TBL1.PERSON_CODE<>'1' and TBL1.CLASS_CODE<>'01' and TBL1.AMT=TBL2.COL1
group by
    TBL1.CLASS_NAME,COL1
order by
    TBL1.CLASS_CODE