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