SELECT a.AGE_CODE           AS [年齢コード]
      ,MAX(b.AGE_NAME)      AS [年齢階層名]
      ,SUM(a.SP_TIME_5)     AS [5時間未満]
      ,SUM(a.SP_TIME_6)     AS [5時間以上6時間未満]
      ,SUM(a.SP_TIME_7)     AS [6時間以上7時間未満]
      ,SUM(a.SP_TIME_8)     AS [7時間以上8時間未満]
      ,SUM(a.SP_TIME_9)     AS [8時間以上9時間未満]
      ,SUM(a.SP_TIME_9OVER) AS [9時間以上]
FROM SLEEP_TIME_DTL a
INNER JOIN AGE_GRP b
ON a.AGE_CODE = b.AGE_CODE
WHERE a.PF_CODE IN ('01000','02000','03000','04000','07000')
GROUP BY a.AGE_CODE
ORDER BY a.AGE_CODE