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