SELECT
    AGE_NAME
    ,SUM(CASE WHEN TIME_CODE = 120 THEN 1 ELSE 0 END) as '5時間未満'
    ,SUM(CASE WHEN TIME_CODE = 130 THEN cnt ELSE 0 END) as '5時間以上6時間未満'
    ,SUM(CASE WHEN TIME_CODE = 140 THEN cnt ELSE 0 END) as '6時間以上7時間未満'
    ,SUM(CASE WHEN TIME_CODE = 150 THEN cnt ELSE 0 END) as '7時間以上8時間未満'
    ,SUM(CASE WHEN TIME_CODE = 160 THEN cnt ELSE 0 END) as '8時間以上9時間未満'
    ,SUM(CASE WHEN TIME_CODE = 170 THEN cnt ELSE 0 END) as '9時間以上'
    ,SUM(CASE WHEN TIME_CODE = 180 THEN cnt ELSE 0 END) as '不詳'
FROM (
    SELECT
        t1.TIME_CODE
        ,t1.AGE_CODE
        ,t2.AGE_NAME    
        ,COUNT(*) as cnt
    FROM
        SLEEP_TIME_DTL as t1
    INNER JOIN AGE_GRP as t2 ON t1.AGE_CODE = t2.AGE_CODE
    GROUP BY
        t1.TIME_CODE
        ,t1.AGE_CODE
        ,t2.AGE_NAME    
) as t3
GROUP BY AGE_CODE
ORDER BY AGE_CODE
;