SELECT 
    A.AGE_NAME AS 年齢階層,
    SUM (CASE WHEN S.TIME_CODE = 120 THEN S.TARGET_POP ELSE 0 END) AS ５時間未満,
    SUM (CASE WHEN S.TIME_CODE = 130 THEN S.TARGET_POP ELSE 0 END) AS ５時間以上６時間未満,
    SUM (CASE WHEN S.TIME_CODE = 140 THEN S.TARGET_POP ELSE 0 END) AS ６時間以上７時間未満,
    SUM (CASE WHEN S.TIME_CODE = 150 THEN S.TARGET_POP ELSE 0 END) AS ７時間以上８時間未満,
    SUM (CASE WHEN S.TIME_CODE = 160 THEN S.TARGET_POP ELSE 0 END) AS ８時間以上９時間未満,
    SUM (CASE WHEN S.TIME_CODE = 170 THEN S.TARGET_POP ELSE 0 END) AS ９時間以上,
    SUM (CASE WHEN S.TIME_CODE = 180 THEN S.TARGET_POP ELSE 0 END) AS 不詳
FROM SLEEP_TIME_DTL AS S
LEFT JOIN SLEEP_TIME AS T
    ON S.TIME_CODE = T.TIME_CODE
    LEFT JOIN AGE_GRP AS A
        ON S.AGE_CODE = A.AGE_CODE
        WHERE S.TARGET_POP != 0 
GROUP BY 年齢階層 
ORDER BY S.AGE_CODE ASC;