SELECT
            T1.AGE_CODE as '年齢コード',
            T1.AGE_NAME as '年齢階層名',
            SUM(T2.SP_TIME_5) as '5時間未満',
            SUM(T2.SP_TIME_6) as '5時間以上6時間未満',
            SUM(T2.SP_TIME_7) as '6時間以上7時間未満',
            SUM(T2.SP_TIME_8) as '7時間以上8時間未満',
            SUM(T2.SP_TIME_9) as '8時間以上9時間未満',
            SUM(T2.SP_TIME_9OVER) as '9時間以上'
FROM
            AGE_GRP as T1
            INNER JOIN SLEEP_TIME_DTL as T2
            ON T1.AGE_CODE = T2.AGE_CODE
            INNER JOIN PREFECTURE as T3
            ON T2.PF_CODE = T3.PF_CODE
WHERE
            T3.PF_CODE = '01000' OR
            T3.PF_CODE = '02000' OR
            T3.PF_CODE = '03000' OR
            T3.PF_CODE = '04000' OR
            T3.PF_CODE = '07000'
GROUP BY
            T1.AGE_CODE
ORDER BY
            T1.AGE_CODE ASC;