SELECT 
    b.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 SLEEP_TIME_DTL as a
INNER JOIN AGE_GRP as b
ON a.AGE_CODE=b.AGE_CODE
GROUP BY a.AGE_CODE,b.AGE_CODE
ORDER BY a.AGE_CODE;