select
	t2.AGE_CODE      as `年齢コード`,
	t2.AGE_NAME      as `年齢階層名`,
	sum(t1.SP_TIME_5    ) as `5時間未満`,
	sum(t1.SP_TIME_5    ) as `5時間以上6時間未満`,
	sum(t1.SP_TIME_5    ) as `6時間以上7時間未満`,
	sum(t1.SP_TIME_5    ) as `7時間以上8時間未満`,
	sum(t1.SP_TIME_5    ) 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
;