SELECT  
    age_name AS "年齢階層"
    , SUM(CASE WHEN dtl.time_code = 120 THEN target_pop ELSE NULL END) AS "5時間未満"
    , SUM(CASE WHEN dtl.time_code = 130 THEN target_pop ELSE NULL END) AS "5時間以上6時間未満"
    , SUM(CASE WHEN dtl.time_code = 140 THEN target_pop ELSE NULL END) AS "6時間以上7時間未満"
    , SUM(CASE WHEN dtl.time_code = 150 THEN target_pop ELSE NULL END) AS "7時間以上8時間未満"
    , SUM(CASE WHEN dtl.time_code = 160 THEN target_pop ELSE NULL END) AS "8時間以上9時間未満"
    , SUM(CASE WHEN dtl.time_code = 170 THEN target_pop ELSE NULL END) AS "9時間以上"
    , SUM(CASE WHEN dtl.time_code = 180 THEN target_pop ELSE NULL END) AS "不詳"
FROM
    SLEEP_TIME_DTL AS dtl
    LEFT OUTER JOIN
        AGE_GRP AS age
        ON dtl.age_code = age.age_code
GROUP BY
    1
ORDER BY
    dtl.age_code