SELECT 
    age.age_name as 年齢階層,
    sum(case time.time_code when 120 then dtl.target_pop else 0 end) as "5時間未満",
    sum(case time.time_code when 130 then dtl.target_pop else 0 end) as "5時間以上6時間未満",
    sum(case time.time_code when 140 then dtl.target_pop else 0 end) as "6時間以上7時間未満",
    sum(case time.time_code when 150 then dtl.target_pop else 0 end) as "7時間以上8時間未満",
    sum(case time.time_code when 160 then dtl.target_pop else 0 end) as "8時間以上9時間未満",
    sum(case time.time_code when 170 then dtl.target_pop else 0 end) as "9時間以上",
    sum(case time.time_code when 180 then dtl.target_pop else 0 end) as "不詳"
FROM
    SLEEP_TIME_DTL AS dtl
        JOIN
    AGE_GRP AS age ON dtl.age_code = age.age_code
        JOIN
    sleep_time AS time ON dtl.time_code = time.time_code
GROUP BY dtl.age_code
order by age.age_code