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