select
age_name "年齢階層", 
sum(case time_code when 120 then target_pop end) as "5時間未満",
sum(case time_code when 130 then target_pop end) as "5時間以上6時間未満",
sum(case time_code when 140 then target_pop end) as "6時間以上7時間未満",
sum(case time_code when 150 then target_pop end) as "7時間以上8時間未満",
sum(case time_code when 160 then target_pop end) as "8時間以上9時間未満",
sum(case time_code when 170 then target_pop end) as "9時間以上",
sum(case time_code when 180 then target_pop end) as "不詳"

from sleep_time_dtl
join age_grp using(age_code)
group by 1 order by 1