select AG.AGE_NAME AS 年齢階層
    , sum(case when STD.TIME_CODE = 120 then STD.TARGET_POP else 0 end) AS '5時間未満'
    , sum(case when STD.TIME_CODE = 130 then STD.TARGET_POP else 0 end) AS '5時間以上6時間未満'
    , sum(case when STD.TIME_CODE = 140 then STD.TARGET_POP else 0 end) AS '6時間以上7時間未満'
    , sum(case when STD.TIME_CODE = 150 then STD.TARGET_POP else 0 end) AS '7時間以上8時間未満'
    , sum(case when STD.TIME_CODE = 160 then STD.TARGET_POP else 0 end) AS '8時間以上9時間未満'
    , sum(case when STD.TIME_CODE = 170 then STD.TARGET_POP else 0 end) AS '9時間以上'
    , sum(case when STD.TIME_CODE = 180 then STD.TARGET_POP else 0 end) AS '不詳'
from SLEEP_TIME_DTL AS STD
    inner join AGE_GRP AS AG
    on STD.AGE_CODE = AG.AGE_CODE
    inner join SLEEP_TIME AS ST
    on STD.TIME_CODE = ST.TIME_CODE
GROUP BY STD.AGE_CODE
ORDER BY STD.AGE_CODE ASC;