SELECT
    A.AGE_NAME AS 年齢階層
,   SUM(CASE T.TIME_CODE WHEN 120 THEN T.TARGET_POP ELSE 0 END) AS '5時間未満'
,   SUM(CASE T.TIME_CODE WHEN 130 THEN T.TARGET_POP ELSE 0 END) AS '5時間以上6時間未満'
,   SUM(CASE T.TIME_CODE WHEN 140 THEN T.TARGET_POP ELSE 0 END) AS '6時間以上7時間未満'
,   SUM(CASE T.TIME_CODE WHEN 150 THEN T.TARGET_POP ELSE 0 END) AS '7時間以上8時間未満'
,   SUM(CASE T.TIME_CODE WHEN 160 THEN T.TARGET_POP ELSE 0 END) AS '8時間以上9時間未満'
,   SUM(CASE T.TIME_CODE WHEN 170 THEN T.TARGET_POP ELSE 0 END) AS '9時間以上'
,   SUM(CASE T.TIME_CODE WHEN 180 THEN T.TARGET_POP ELSE 0 END) AS 不詳
FROM
    SLEEP_TIME_DTL AS T
LEFT JOIN
    AGE_GRP AS A
ON
    T.AGE_CODE = A.AGE_CODE
GROUP BY
    T.AGE_CODE
ORDER BY
    T.AGE_CODE ASC