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