select
a.AGE_CODE as '年齢コード',
b.AGE_NAME as '年齢階層名',
sum(a.SP_TIME_5)  as '5時間未満',
sum(a.SP_TIME_6)  as '5時間以上6時間未満',
sum(a.SP_TIME_7) as '6時間以上7時間未満',
sum(a.SP_TIME_8) as '7時間以上8時間未満',
sum(a.SP_TIME_9) as '8時間以上9時間未満',
sum(a.SP_TIME_9OVER) as  '9時間以上'
from SLEEP_TIME_DTL a
inner join AGE_GRP b on a.AGE_CODE = b.AGE_CODE
inner join PREFECTURE c on a.PF_CODE = c.PF_CODE
where c.PF_NAME='北海道'or c.PF_NAME='青森県' or c.PF_NAME= '岩手県'
or c.PF_NAME= '宮城県' or c.PF_NAME= '福島県'
group by a.AGE_CODE
order by a.AGE_CODE ASC