select
CLASS_NAME as  CLASS,
count(PERSON_NAME) as PERSON,
AMT as HOUSEHOLDS
from
HOUSEHOLD
where
PERSON_CODE <> '1' and CLASS_CODE <> '01'
group by
CLASS_NAME,
AMT
order by
CLASS_CODE