SELECT
	 Age.age_code AS 年齢コード
	,Age.age_name AS 年齢階層名
	,SUM(Rel.sp_time_5) AS '5時間未満'
	,SUM(Rel.sp_time_6) AS '5時間以上6時間未満'
	,SUM(Rel.sp_time_7)AS '6時間以上7時間未満'
	,SUM(Rel.sp_time_8)AS '7時間以上8時間未満'
	,SUM(Rel.sp_time_9)AS '8時間以上9時間未満'
	,SUM(Rel.sp_time_9OVER) AS '9時間以上'
FROM
	SLEEP_TIME_DTL AS Rel
INNER JOIN
	AGE_GRP AS Age
ON
	Rel.age_code = Age.age_code	
INNER JOIN
	Prefecture Pre
ON
	Rel.pf_code = Pre.pf_code
WHERE
	Pre.pf_name in ('北海道', '青森県', '岩手県', '宮城県', '福島県')
GROUP BY
	Age.age_code
ORDER BY
	年齢コード