with base as (
select
AGE_CODE
,TIME_CODE
,sum(TARGET_POP) as count_user
from SLEEP_TIME_DTL
group by 1,2
)
select
AGE_GRP.AGE_NAME as '年齢階層'
,max(case when TIME_CODE = 120 then count_user end) as '5時間未満'
,max(case when TIME_CODE = 130 then count_user end) as '5時間以上6時間未満'
,max(case when TIME_CODE = 140 then count_user end) as '6時間以上7時間未満'
,max(case when TIME_CODE = 150 then count_user end) as '7時間以上8時間未満'
,max(case when TIME_CODE = 160 then count_user end) as '8時間以上9時間未満'
,max(case when TIME_CODE = 170 then count_user end) as '9時間以上'
,max(case when TIME_CODE = 180 then count_user end) as '不詳'
from base
left join AGE_GRP on base.AGE_CODE = AGE_GRP.AGE_CODE
group by 1
order by base.AGE_CODE