SELECT
    T.AGE_CODE AS '年齢コード',
    T.AGE_NAME AS '年齢階層名',
    SUM(CASE WHEN T.AGE_CODE THEN T.SP_TIME_5 ELSE 0 END) AS '5時間未満',
    SUM(CASE WHEN T.AGE_CODE THEN T.SP_TIME_6 ELSE 0 END) AS '5時間以上6時間未満',
    SUM(CASE WHEN T.AGE_CODE THEN T.SP_TIME_7 ELSE 0 END) AS '6時間以上7時間未満',
    SUM(CASE WHEN T.AGE_CODE THEN T.SP_TIME_8 ELSE 0 END) AS '7時間以上8時間未満',
    SUM(CASE WHEN T.AGE_CODE THEN T.SP_TIME_9 ELSE 0 END) AS '8時間以上9時間未満',
    SUM(CASE WHEN T.AGE_CODE THEN T.SP_TIME_9OVER ELSE 0 END) AS '9時間以上'
FROM(
    SELECT *
    FROM AGE_GRP AG
    INNER JOIN
        (SELECT
            AGE_CODE,
            SP_TIME_5,
            SP_TIME_6,
            SP_TIME_7,
            SP_TIME_8,
            SP_TIME_9,
            SP_TIME_9OVER
        FROM SLEEP_TIME_DTL
        WHERE
            PF_CODE = '01000' OR
            PF_CODE = '02000' OR
            PF_CODE = '03000' OR
            PF_CODE = '04000' OR
            PF_CODE = '07000'
        ) STD
    ON AG.AGE_CODE = STD.AGE_CODE) T
GROUP BY T.AGE_CODE
ORDER BY T.AGE_CODE ASC;