WITH temp AS(
    SELECT 
        t1.TARGET_POP,
        t2.TIME_NAME,
        t3.AGE_NAME
    FROM    
        SLEEP_TIME_DTL AS t1
    
    JOIN 
        SLEEP_TIME AS t2
    ON
        t1.TIME_CODE = t2.TIME_CODE
    JOIN
        AGE_GRP AS t3
    ON
        t1.AGE_CODE = t3.AGE_CODE
),
temp2 AS 
(SELECT 
    AGE_NAME AS "年齢階層",
CASE 
WHEN
    TIME_NAME =  "5時間未満"	
THEN
    TARGET_POP
ELSE
    0
END AS "5時間未満",
CASE 
WHEN
    TIME_NAME =  "5時間以上6時間未満"	
THEN
    TARGET_POP
ELSE
    0
END AS "5時間以上6時間未満",

CASE 
WHEN
    TIME_NAME =  "6時間以上7時間未満"	
THEN
    TARGET_POP
ELSE
    0
END AS "6時間以上7時間未満",

CASE 
WHEN
    TIME_NAME =  "7時間以上8時間未満"	
THEN
    TARGET_POP
ELSE
    0
END AS "7時間以上8時間未満",

CASE 
WHEN
    TIME_NAME =  "8時間以上9時間未満"	
THEN
    TARGET_POP
ELSE
    0
END AS "8時間以上9時間未満",
CASE
WHEN
    TIME_NAME =  "9時間以上"	
THEN
    TARGET_POP
ELSE
    0
END AS "9時間以上",
CASE
WHEN
    TIME_NAME =  "不詳"	
THEN
    TARGET_POP
ELSE
    0
END AS "不詳"


FROM 
    temp
)

SELECT
    年齢階層,SUM("5時間未満") AS "5時間未満" ,SUM("5時間以上6時間未満") AS "5時間以上6時間未満",SUM("6時間以上7時間未満") AS "6時間以上7時間未満"
    ,SUM("7時間以上8時間未満") AS "7時間以上8時間未満",SUM("8時間以上9時間未満") AS "8時間以上9時間未満",SUM("9時間以上")AS "9時間以上",SUM("不詳") AS "不詳"
    
FROM
    temp2
GROUP BY 
    年齢階層
ORDER BY 
年齢階層