with subq as (

select CLASS_NAME as CLASS
	,max(AMT) as HOUSEHOLDS

from HOUSEHOLD a

where PERSON_CODE <> '1'
  and CLASS_CODE <> '01'
group by CLASS_NAME
)

select CLASS
	,PERSON_NAME as PERSON
	,HOUSEHOLDS
from subq as A

inner join  HOUSEHOLD as B
on  A.CLASS = B.CLASS_NAME
and A.HOUSEHOLDS = B.AMT
order by CLASS_CODE asc