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