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