select CLASS_NAME as CLASS, PERSON_NAME as PERSON, AMT as HOUSEHOLDS
from HOUSEHOLD
where not PERSON_CODE = 1
and not CLASS_CODE = 01
and not CLASS = '総数'
and not PERSON_NAME = '１人'
order by CLASS_CODE asc;