SELECT
    DTL.AGE_CODE	        AS "年齢コード"
,   AGE.AGE_NAME	        AS "年齢階層名"
,   SUM(DTL.SP_TIME_5)	    AS "5時間未満"
,   SUM(DTL.SP_TIME_6)	    AS "5時間以上6時間未満"
,   SUM(DTL.SP_TIME_7)	    AS "6時間以上7時間未満"
,   SUM(DTL.SP_TIME_8)	    AS "7時間以上8時間未満"
,   SUM(DTL.SP_TIME_9)	    AS "8時間以上9時間未満"
,   SUM(DTL.SP_TIME_9OVER)	AS "9時間以上"
FROM
    SLEEP_TIME_DTL DTL
INNER JOIN AGE_GRP AGE
    ON DTL.AGE_CODE = AGE.AGE_CODE
INNER JOIN PREFECTURE PRE
    ON DTL.PF_CODE = PRE.PF_CODE
WHERE
    --集計する都道府県は、北海道、青森県、岩手県、宮城県、福島県とする
    DTL.PF_CODE IN ('01000', '02000', '03000', '04000', '07000')
GROUP BY
    DTL.AGE_CODE
,   AGE.AGE_NAME
ORDER BY
    DTL.AGE_CODE ASC