select
 max(CLASS_NAME) as CLASS
 , PERSON_NAME as PERSON
 , max(DISTINCT(AMT)) as HOUSEHOLDS
from HOUSEHOLD
where PERSON_CODE != 1 and CLASS_CODE != '01'
group by CLASS_NAME, CLASS_CODE
order by CLASS_CODE asc;