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