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