with tbl as (
select
    b.AGE_NAME as "年齢階層"
    , c.TIME_NAME as TN
    , CASE WHEN c.TIME_NAME = '5時間未満' THEN TARGET_POP ELSE 0 END AS "5時間未満"
    , CASE WHEN c.TIME_NAME = '5時間以上6時間未満' THEN TARGET_POP ELSE 0 END AS "5時間以上6時間未満"
    , CASE WHEN c.TIME_NAME = '6時間以上7時間未満' THEN TARGET_POP ELSE 0 END AS "6時間以上7時間未満"
    , CASE WHEN c.TIME_NAME = '7時間以上8時間未満' THEN TARGET_POP ELSE 0 END AS "7時間以上8時間未満"
    , CASE WHEN c.TIME_NAME = '8時間以上9時間未満' THEN TARGET_POP ELSE 0 END AS "8時間以上9時間未満"
    , CASE WHEN c.TIME_NAME = '9時間以上' THEN TARGET_POP ELSE 0 END AS "9時間以上"
    , CASE WHEN c.TIME_NAME = '不詳' THEN TARGET_POP ELSE 0 END AS "不詳"
from
    SLEEP_TIME_DTL as a
left join
    AGE_GRP as b
on
    a.AGE_CODE = b.AGE_CODE
left join
    SLEEP_TIME as c
on
    a.TIME_CODE = c.TIME_CODE
)
select
    "年齢階層"
    ,sum("5時間未満") as "5時間未満"
    ,sum("5時間以上6時間未満") as "5時間以上6時間未満"
    ,sum("6時間以上7時間未満") as "6時間以上7時間未満"
    ,sum("7時間以上8時間未満") as "7時間以上8時間未満"
    ,sum("8時間以上9時間未満") as "8時間以上9時間未満"
    ,sum("9時間以上") as "9時間以上"
    ,sum("不詳") as "不詳"
from
    tbl
group by
    "年齢階層"
order by
    "年齢階層";