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