SELECT 
    AG.AGE_NAME AS 年齢階層,
    SUM(CASE WHEN ST.TIME_NAME = '5時間未満' THEN STD.TARGET_POP ELSE NULL END) AS '5時間未満',
    SUM(CASE WHEN ST.TIME_NAME = '5時間以上6時間未満' THEN STD.TARGET_POP ELSE NULL END) AS '5時間以上6時間未満',
    SUM(CASE WHEN ST.TIME_NAME = '6時間以上7時間未満' THEN STD.TARGET_POP ELSE NULL END) AS '6時間以上7時間未満',
    SUM(CASE WHEN ST.TIME_NAME = '7時間以上8時間未満' THEN STD.TARGET_POP ELSE NULL END) AS '7時間以上8時間未満',
    SUM(CASE WHEN ST.TIME_NAME = '8時間以上9時間未満' THEN STD.TARGET_POP ELSE NULL END) AS '8時間以上9時間未満',
    SUM(CASE WHEN ST.TIME_NAME = '9時間以上' THEN STD.TARGET_POP ELSE NULL END) AS '9時間以上',
    SUM(CASE WHEN ST.TIME_NAME = '不詳' THEN STD.TARGET_POP ELSE NULL END) AS '不詳'
FROM 
    SLEEP_TIME_DTL AS STD
    LEFT OUTER JOIN AGE_GRP AS AG ON STD.AGE_CODE = AG.AGE_CODE
    LEFT OUTER JOIN SLEEP_TIME AS ST ON STD.TIME_CODE = ST.TIME_CODE
GROUP BY 年齢階層
ORDER BY 年齢階層 ASC;