select 
 MAX(CLASS_NAME) as CLASS
,PERSON_NAME as PERSON
,AMT as HOUSEHOLDS
from HOUSEHOLD
where 1=1
and PERSON_CODE <> '1'
and CLASS_CODE <> '01'
group by PERSON_NAME,AMT
order by CLASS_CODE asc