select
b.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 in('北海道','青森県','岩手県','宮城県','福島県')
group by
b.age_code
,b.AGE_NAME
order by
"年齢コード" asc
;