select 
 AGE_NAME as 年齢階層
 ,SUM(CASE WHEN time.TIME_CODE = 120 THEN TARGET_POP ELSE 0 END) as "5時間未満"
 ,SUM(CASE WHEN time.TIME_CODE = 130 THEN TARGET_POP ELSE 0 END) as "5時間以上6時間未満"
 ,SUM(CASE WHEN time.TIME_CODE = 140 THEN TARGET_POP ELSE 0 END) as "6時間以上7時間未満"
 ,SUM(CASE WHEN time.TIME_CODE = 150 THEN TARGET_POP ELSE 0 END) as "7時間以上8時間未満"
 ,SUM(CASE WHEN time.TIME_CODE = 160 THEN TARGET_POP ELSE 0 END) as "8時間以上9時間未満"
 ,SUM(CASE WHEN time.TIME_CODE = 170 THEN TARGET_POP ELSE 0 END) as "9時間以上"
 ,SUM(CASE WHEN time.TIME_CODE = 180 THEN TARGET_POP ELSE 0 END) as 不詳
from SLEEP_TIME_DTL time
 inner join AGE_GRP age
  on time.AGE_CODE = age.AGE_CODE
 inner join SLEEP_TIME sleep
  on time.TIME_CODE = sleep.TIME_CODE
group by
 年齢階層;