SELECT
    ag.AGE_NAME as '年齢階層'
    ,sum(CASE 
        WHEN tg.TIME_NAME = '5時間未満' THEN TARGET_POP ELSE 0 
    END) as '5時間未満'
    , sum(CASE 
        WHEN tg.TIME_NAME = '5時間以上6時間未満' THEN TARGET_POP ELSE 0 
    END) as '5時間以上6時間未満'
    , sum(CASE 
        WHEN tg.TIME_NAME = '6時間以上7時間未満' THEN TARGET_POP ELSE 0 
    END) as '6時間以上7時間未満'
    , sum(CASE 
        WHEN tg.TIME_NAME = '7時間以上8時間未満' THEN TARGET_POP ELSE 0 
    END) as '7時間以上8時間未満'
    , sum(CASE 
        WHEN tg.TIME_NAME = '8時間以上9時間未満' THEN TARGET_POP ELSE 0 
    END) as '8時間以上9時間未満'
    , sum(CASE 
        WHEN tg.TIME_NAME = '9時間以上' THEN TARGET_POP ELSE 0 
    END) as '9時間以上'
    , sum(CASE 
        WHEN tg.TIME_NAME = '不詳' THEN TARGET_POP ELSE 0 
    END) as '不詳'
FROM
    SLEEP_TIME_DTL std
LEFT JOIN
    AGE_GRP ag
ON
    ag.AGE_CODE = std.AGE_CODE
LEFT JOIN
    SLEEP_TIME tg
ON 
    tg.TIME_CODE = std.TIME_CODE
group by
    1;