SELECT
     SELEP.AGE_CODE       AS 年齢コード
    ,AGE.AGE_NAME         AS 年齢階層名
    ,SUM(SELEP.SP_TIME_5) AS ５時間未満
    ,SUM(SELEP.SP_TIME_6) AS ５時間以上６時間未満
    ,SUM(SELEP.SP_TIME_7) AS ６時間以上７時間未満
    ,SUM(SELEP.SP_TIME_8) AS ７時間以上８時間未満
    ,SUM(SELEP.SP_TIME_9) AS ８時間以上９時間未満
    ,SUM(SELEP.SP_TIME_9OVER) AS ９時間以上
FROM SLEEP_TIME_DTL  SELEP
LEFT OUTER JOIN AGE_GRP AGE
ON SELEP.AGE_CODE = AGE.AGE_CODE
WHERE SELEP.PF_CODE IN('01000','02000','03000','04000','05000')
GROUP BY SELEP.AGE_CODE,AGE.AGE_NAME
ORDER BY SELEP.AGE_CODE