select
 age.age_name,
 "5時間",
"5時間以上",
"6時間以上",
"7時間以上",
"8時間以上",
"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時間以上",
 sum(case time_code when 140 then target_pop else 0 end) as "6時間以上",
 sum(case time_code when 150 then target_pop else 0 end) as "7時間以上",
 sum(case time_code when 160 then target_pop else 0 end) as "8時間以上",
 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