SELECT
	S.AGE_CODE AS 年齢コード,
	MAX(A.AGE_NAME) AS 年齢階層名,
	SUM(S.SP_TIME_5) AS '5時間未満',
	SUM(S.SP_TIME_6) AS '5時間以上6時間未満',
	SUM(S.SP_TIME_7) AS '6時間以上7時間未満',
	SUM(S.SP_TIME_8) AS '7時間以上8時間未満',
	SUM(S.SP_TIME_9) AS '8時間以上9時間未満',
	SUM(S.SP_TIME_9OVER) AS '9時間以上'
FROM
	SLEEP_TIME_DTL S
INNER JOIN
	PREFECTURE P
ON
	S.PF_CODE = P.PF_CODE AND
	P.PF_NAME IN ('北海道','青森県','岩手県','宮城県','福島県')
INNER JOIN
    AGE_GRP A
ON
    S.AGE_CODE = A.AGE_CODE
GROUP BY
	S.AGE_CODE
ORDER BY
	S.AGE_CODE ASC