select
  age_name as 年齢階層,
  sum(case sleep_time.time_code when 120 then target_pop else 0 end) as [5時間未満],
  sum(case sleep_time.time_code when 130 then target_pop else 0 end) as [5時間以上6時間未満],
  sum(case sleep_time.time_code when 140 then target_pop else 0 end) as [6時間以上7時間未満],
  sum(case sleep_time.time_code when 150 then target_pop else 0 end) as [7時間以上8時間未満],
  sum(case sleep_time.time_code when 160 then target_pop else 0 end) as [8時間以上9時間未満],
  sum(case sleep_time.time_code when 170 then target_pop else 0 end) as [9時間以上],
  sum(case sleep_time.time_code when 180 then target_pop else 0 end) as [不詳]
from sleep_time
join (
  select
    age_grp.age_code as age_code,
    age_name,
    time_code,
    target_pop
  from sleep_time_dtl
  join age_grp
  on sleep_time_dtl.age_code = age_grp.age_code
) as temp
on temp.time_code = sleep_time.time_code
group by
age_code, age_name
order by
age_code asc