select 
    age_name as "年齢階層",
    (select sum(target_pop) from sleep_time_dtl where age_code = a.age_code and time_code = 120) as "5時間未満",
    (select sum(target_pop) from sleep_time_dtl where age_code = a.age_code and time_code = 130) as "5時間以上6時間未満",
    (select sum(target_pop) from sleep_time_dtl where age_code = a.age_code and time_code = 140) as "6時間以上7時間未満",
    (select sum(target_pop) from sleep_time_dtl where age_code = a.age_code and time_code = 150) as "7時間以上8時間未満",
    (select sum(target_pop) from sleep_time_dtl where age_code = a.age_code and time_code = 160) as "8時間以上9時間未満",
    (select sum(target_pop) from sleep_time_dtl where age_code = a.age_code and time_code = 170) as "9時間以上",
    (select sum(target_pop) from sleep_time_dtl where age_code = a.age_code and time_code = 180) as "不詳"
from age_grp as a
order by age_code asc;