select 
 ag.AGE_NAME as "年齢階層"
,sum(case when sd.TIME_CODE = 120 then 1 else 0 end) as "5時間未満"
,sum(case when sd.TIME_CODE = 130 then 1 else 0 end) as "5時間以上6時間未満"
,sum(case when sd.TIME_CODE = 140 then 1 else 0 end) as "6時間以上7時間未満"
,sum(case when sd.TIME_CODE = 150 then 1 else 0 end) as "7時間以上8時間未満"
,sum(case when sd.TIME_CODE = 160 then 1 else 0 end) as "8時間以上9時間未満"
,sum(case when sd.TIME_CODE = 170 then 1 else 0 end) as "9時間以上"
,sum(case when sd.TIME_CODE = 180 then 1 else 0 end) as "不詳"
from SLEEP_TIME_DTL sd
inner join AGE_GRP ag
	on sd.AGE_CODE = ag.AGE_CODE
inner join SLEEP_TIME st
	on sd.TIME_CODE = st.TIME_CODE
group by 
 ag.AGE_CODE
,ag.AGE_NAME
order by 
 ag.AGE_CODE