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