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