select
  ag.AGE_NAME as 年齢階層,
  sum(case when st.TIME_NAME = '5時間未満' then std.TARGET_POP else 0 end) as '5時間未満',
  sum(case when st.TIME_NAME = '5時間以上6時間未満' then std.TARGET_POP else 0 end) as '5時間以上6時間未満',
  sum(case when st.TIME_NAME = '6時間以上7時間未満' then std.TARGET_POP else 0 end) as '6時間以上7時間未満',
  sum(case when st.TIME_NAME = '7時間以上8時間未満' then std.TARGET_POP else 0 end) as '7時間以上8時間未満',
  sum(case when st.TIME_NAME = '8時間以上9時間未満' then std.TARGET_POP else 0 end) as '8時間以上9時間未満',
  sum(case when st.TIME_NAME = '9時間以上' then std.TARGET_POP else 0 end) as '9時間以上',
  sum(case when st.TIME_NAME = '不詳' then std.TARGET_POP else 0 end) as '不詳'
from
  AGE_GRP ag
join
  sleep_time_dtl std on ag.age_code = std.age_code
left outer join
  sleep_time st on std.time_code = st.time_code
group by ag.age_code
order by ag.age_code;