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