--select MM.AGE_NAME as 年齢階層,
--CASE TIME_NAME 
--WHEN MM.TIME_NAME = '5時間未満'
--THEN '5'
--as 5時間未満
--MM.TARGET_POP
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
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