CREATE TEMP TABLE
    TMP
AS
SELECT
    ST.TIME_NAME
,   AG.AGE_NAME
,   SUM(DTL.TARGET_POP) AS POP
,   DTL.TIME_CODE
,   DTL.AGE_CODE
FROM
    SLEEP_TIME_DTL AS DTL
LEFT JOIN
    AGE_GRP AS AG
ON
    DTL.AGE_CODE = AG.AGE_CODE
LEFT JOIN
    SLEEP_TIME AS ST
ON
    DTL.TIME_CODE = ST.TIME_CODE
GROUP BY
    DTL.TIME_CODE
,   DTL.AGE_CODE
;

SELECT
    T.AGE_NAME AS 年齢階層
,   MAX(CASE T.SEQ WHEN 1 THEN T.POP ELSE 0 END) AS '5時間未満'
,   MAX(CASE T.SEQ WHEN 2 THEN T.POP ELSE 0 END) AS '5時間以上6時間未満'
,   MAX(CASE T.SEQ WHEN 3 THEN T.POP ELSE 0 END) AS '6時間以上7時間未満'
,   MAX(CASE T.SEQ WHEN 4 THEN T.POP ELSE 0 END) AS '7時間以上8時間未満'
,   MAX(CASE T.SEQ WHEN 5 THEN T.POP ELSE 0 END) AS '8時間以上9時間未満'
,   MAX(CASE T.SEQ WHEN 6 THEN T.POP ELSE 0 END) AS '9時間以上'
,   MAX(CASE T.SEQ WHEN 7 THEN T.POP ELSE 0 END) AS 不詳
FROM
    (
    SELECT
        AGE_NAME
    ,   POP
    ,   ROW_NUMBER() OVER (PARTITION BY AGE_NAME) AS SEQ
    FROM
        TMP
    ) AS T
GROUP BY
    T.AGE_NAME