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