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