SELECT MAX(SUB.AGE_NAME) AS 年齢階層
      ,SUM(CASE WHEN STD.TIME_CODE = 120 THEN STD.TARGET_POP ELSE NULL END) AS ５時間未満
      ,SUM(CASE WHEN STD.TIME_CODE = 130 THEN STD.TARGET_POP ELSE NULL END) AS ５時間以上６時間未満     
      ,SUM(CASE WHEN STD.TIME_CODE = 140 THEN STD.TARGET_POP ELSE NULL END) AS ６時間以上７時間未満     
      ,SUM(CASE WHEN STD.TIME_CODE = 150 THEN STD.TARGET_POP ELSE NULL END) AS ７時間以上８時間未満     
      ,SUM(CASE WHEN STD.TIME_CODE = 160 THEN STD.TARGET_POP ELSE NULL END) AS ８時間以上９時間未満     
      ,SUM(CASE WHEN STD.TIME_CODE = 170 THEN STD.TARGET_POP ELSE NULL END) AS ９時間以上    
      ,SUM(CASE WHEN STD.TIME_CODE = 180 THEN STD.TARGET_POP ELSE NULL END) AS 不詳     
FROM SLEEP_TIME_DTL STD
INNER JOIN AGE_GRP SUB
ON  STD.AGE_CODE = SUB.AGE_CODE
GROUP BY SUB.AGE_CODE
ORDER BY SUB.AGE_CODE