select AGE_NAME as 年齢階層,

SUM(CASE TIME_CODE WHEN 120 then TARGET_POP else 0 end) as '5時間未満',
SUM(CASE TIME_CODE WHEN 130 then TARGET_POP else 0 end) as '5時間以上6時間未満',
SUM(CASE TIME_CODE WHEN 140 then TARGET_POP else 0 end) as '6時間以上7時間未満',
SUM(CASE TIME_CODE WHEN 150 then TARGET_POP else 0 end) as '7時間以上8時間未満',
SUM(CASE TIME_CODE WHEN 160 then TARGET_POP else 0 end) as '8時間以上9時間未満',
SUM(CASE TIME_CODE WHEN 170 then TARGET_POP else 0 end) as '9時間以上',
SUM(CASE TIME_CODE WHEN 180 then TARGET_POP else 0 end) as '不詳'


FROM SLEEP_TIME_DTL
INNER JOIN AGE_GRP ON AGE_GRP.AGE_CODE = SLEEP_TIME_DTL.AGE_CODE
GROUP BY AGE_GRP.AGE_CODE
ORDER BY AGE_GRP.AGE_CODE;

--from
--(select AG.AGE_NAME, ST.TIME_NAME, ST.TIME_CODE, STD.TARGET_POP
--from SLEEP_TIME as ST JOIN SLEEP_TIME_DTL as STD
--ON ST.TIME_CODE = STD.TIME_CODE
--JOIN AGE_GRP as AG
--ON STD.AGE_CODE = AG.AGE_CODE) as MM