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_CODE asc;