WITH SP_TIME_BYAGE AS(
    SELECT
        AGE_CODE,
        SUM(SP_TIME_5) AS SUM5,
        SUM(SP_TIME_6) AS SUM6,
        SUM(SP_TIME_7) AS SUM7,
        SUM(SP_TIME_8) AS SUM8,
        SUM(SP_TIME_9) AS SUM9,
        SUM(SP_TIME_9OVER) AS SUM10
    FROM `SLEEP_TIME_DTL`
    WHERE PF_CODE IN('01000', '02000', '03000', '04000', '07000')
    GROUP BY AGE_CODE
    )
    

SELECT
    a.AGE_CODE AS '年齢コード',
    AGE_NAME AS '年齢階層名',
    SUM5 AS '5時間未満',
    SUM6 AS '5時間以上6時間未満',
    SUM7 AS '6時間以上7時間未満',
    SUM8 AS '7時間以上8時間未満',
    SUM9 AS '8時間以上9時間未満',
    SUM10 AS '9時間以上'
FROM
    `SP_TIME_BYAGE` AS s
    INNER JOIN `AGE_GRP` AS a ON s.AGE_CODE = a.AGE_CODE
ORDER BY
    a.AGE_CODE
;