WITH GREP as (
    SELECT
        AGE_CODE as AC,
        SUM(SP_TIME_5) as ST5,
        SUM(SP_TIME_6) as ST6,
        SUM(SP_TIME_7) as ST7,
        SUM(SP_TIME_8) as ST8,
        SUM(SP_TIME_9) as ST9,
        SUM(SP_TIME_9OVER) as ST9O
        FROM SLEEP_TIME_DTL
        WHERE PF_CODE <= '07000' and PF_CODE <> '05000' and PF_CODE <> '06000'
        GROUP BY AGE_CODE
)
SELECT
    AG.AGE_CODE as 年齢コード,
    AG.AGE_NAME as 年齢階層名,
    G.ST5 as ５時間未満,
    G.ST6 as ５時間以上６時間未満,
    G.ST7 as ６時間以上７時間未満,
    G.ST8 as ７時間以上８時間未満,
    G.ST9 as ８時間以上９時間未満,
    G.ST9O as ９時間以上
FROM AGE_GRP as AG
INNER JOIN GREP as G on AG.AGE_CODE = G.AC
ORDER BY AG.AGE_CODE ASC