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