SELECT
    集計結果.AGE_NAME AS 年齢階層,
    SUM(CASE WHEN 集計結果.TIME_CODE = 120 THEN 1 ELSE 0 END) AS '5時間未満',
    SUM(CASE WHEN 集計結果.TIME_CODE = 130 THEN 1 ELSE 0 END) AS '5時間以上6時間未満',
    SUM(CASE WHEN 集計結果.TIME_CODE = 140 THEN 1 ELSE 0 END) AS '6時間以上7時間未満',
    SUM(CASE WHEN 集計結果.TIME_CODE = 150 THEN 1 ELSE 0 END) AS '7時間以上8時間未満',
    SUM(CASE WHEN 集計結果.TIME_CODE = 160 THEN 1 ELSE 0 END) AS '8時間以上9時間未満',
    SUM(CASE WHEN 集計結果.TIME_CODE = 170 THEN 1 ELSE 0 END) AS '9時間以上',
    SUM(CASE WHEN 集計結果.TIME_CODE = 180 THEN 1 ELSE 0 END) AS '不詳'
FROM(
        (SELECT
            AG.AGE_CODE,
            AG.AGE_NAME,
            STD.TIME_CODE
        FROM AGE_GRP AG
            INNER JOIN SLEEP_TIME_DTL STD
            ON AG.AGE_CODE = STD.AGE_CODE
        ) AG_STD
        INNER JOIN SLEEP_TIME ST
        ON AG_STD.TIME_CODE = ST.TIME_CODE
) 集計結果
GROUP BY 年齢階層
ORDER BY 集計結果.AGE_CODE ASC;