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;