select
    mst.age_name 年齢階層,
    time120.cnt "5時間未満",
    time130.cnt "5時間以上6時間未満",
    time140.cnt "6時間以上7時間未満",
    time150.cnt "7時間以上8時間未満",
    time160.cnt "8時間以上9時間未満",
    time170.cnt "9時間以上",
    time180.cnt 不詳
from
    (select age_code, age_name from age_grp) mst
inner join
    (select age_code, count(*) cnt from sleep_time_dtl where time_code = 120 group by age_code) time120
on mst.age_code = time120.age_code
inner join
    (select age_code, count(*) cnt from sleep_time_dtl where time_code = 130 group by age_code) time130
on mst.age_code = time130.age_code
inner join
    (select age_code, count(*) cnt from sleep_time_dtl where time_code = 140 group by age_code) time140
on mst.age_code = time140.age_code
inner join
    (select age_code, count(*) cnt from sleep_time_dtl where time_code = 150 group by age_code) time150
on mst.age_code = time150.age_code
inner join
    (select age_code, count(*) cnt from sleep_time_dtl where time_code = 160 group by age_code) time160
on mst.age_code = time160.age_code
inner join
    (select age_code, count(*) cnt from sleep_time_dtl where time_code = 170 group by age_code) time170
on mst.age_code = time170.age_code
inner join
    (select age_code, count(*) cnt from sleep_time_dtl where time_code = 180 group by age_code) time180
on mst.age_code = time180.age_code 
group by 年齢階層
order by 年齢階層 asc;