select
age_name 年齢階層
,sum(iif(time_code=120,target_pop,0)) '5時間未満'
,sum(iif(time_code=130,target_pop,0)) '5時間以上6時間未満'
,sum(iif(time_code=140,target_pop,0)) '6時間以上7時間未満'
,sum(iif(time_code=150,target_pop,0)) '7時間以上8時間未満'
,sum(iif(time_code=160,target_pop,0)) '8時間以上9時間未満'
,sum(iif(time_code=170,target_pop,0)) '9時間以上'
,sum(iif(time_code=180,target_pop,0)) 不詳
from
sleep_time_dtl natural join age_grp natural join sleep_time
group by age_name order by age_code;