with s as (select 
sleep_time_dtl.age_code
, sleep_time_dtl.time_code
, sum(target_pop) as ttl
from sleep_time_dtl
group by sleep_time_dtl.age_code, time_code)
, s2 as (select 
age_grp.age_name as '年齢階層'
, max(case when time_code = 120 then ttl end) as '5時間未満'
, max(case when time_code = 130 then ttl end) as '5時間以上6時間未満'
, max(case when time_code = 140 then ttl end) as '6時間以上7時間未満'
, max(case when time_code = 150 then ttl end) as '7時間以上8時間未満'
, max(case when time_code = 160 then ttl end) as '8時間以上9時間未満'
, max(case when time_code = 170 then ttl end) as '9時間以上'
, max(case when time_code = 180 then ttl end) as '不詳'
from s join age_grp on s.age_code = age_grp.age_code
group by s.age_code
order by s.age_code
)
select * from s2