with TEMP as (
select
	CLASS_CODE,
	max(CLASS_NAME) as CLASS_NAME,
	PERSON_CODE,
	max(PERSON_NAME) as PERSON_NAME,
	sum(AMT) as AMT
from
	HOUSEHOLD
where
	CLASS_CODE <> '01' and
	PERSON_CODE <> 1
group by 
	CLASS_CODE, PERSON_CODE
)

select
    A.CLASS_NAME as CLASS,
    A.PERSON_NAME as PERSON,
    A.AMT as HOUSEHOLDS
from
    TEMP A
inner join
(
select
    CLASS_CODE,
    MAX(AMT) as AMT
from
    TEMP
group by
    CLASS_CODE
) B
on A.CLASS_CODE = B.CLASS_CODE and 
A.AMT = B.AMT
order by A.CLASS_CODE asc