SELECT
    AGE_NAME AS "年齢階層",
    SUM(TARGET_POP) AS "5時間未満",
    (
        SELECT 
            SUM(TARGET_POP) 
        FROM
            SLEEP_TIME_DTL
        WHERE 
            TIME_CODE = 130
        GROUP BY 
            AGE_CODE,TIME_CODE
    )AS "5時間以上6時間未満"
FROM
    AGE_GRP
INNER JOIN 
    SLEEP_TIME_DTL
ON 
    SLEEP_TIME_DTL.AGE_CODE = AGE_GRP.AGE_CODE
WHERE 
    TIME_CODE = 120
GROUP BY 
    AGE_NAME,TIME_CODE