SELECT
	std.age_code as 地区コード,
	ag.age_name as 年齢階層名,
	sum(std.sp_time_5) as "5時間未満",
	sum(std.sp_time_6) as "5時間以上6時間未満",
	sum(std.sp_time_7) as "6時間以上7時間未満",
	sum(std.sp_time_8) as "7時間以上8時間未満",
	sum(std.sp_time_9) as "8時間以上9時間未満",
	sum(std.sp_time_9over) as "9時間以上"
FROM
	SLEEP_TIME_DTL AS STD 
    INNER JOIN AGE_GRP AS AG
    ON AG.AGE_CODE = STD.AGE_CODE
    INNER JOIN PREFECTURE AS PF
    ON STD.PF_CODE = PF.PF_CODE
WHERE
	pf.pf_name IN('北海道', '青森県', '岩手県', '宮城県','福島県')
GROUP BY
	std.age_code
ORDER BY
	std.age_code asc