select
CLASS_NAME as  CLASS,
MAX(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