-- SELECT
--     PREFECTURE.PF_NAME,
--     SLEEP_TIME_DTL.*,
--     AGE_GRP.AGE_NAME
-- FROM
--     SLEEP_TIME_DTL
-- JOIN
--     PREFECTURE
-- ON
--     SLEEP_TIME_DTL.PF_CODE = PREFECTURE.PF_CODE
-- JOIN 
--     AGE_GRP
-- ON
--     SLEEP_TIME_DTL.AGE_CODE = AGE_GRP.AGE_CODE
-- WHERE
--     PREFECTURE.PF_CODE IN ('01000', '02000', '03000', '04000', '07000');


SELECT
    PREFECTURE.PF_NAME,
    AGE_GRP.AGE_CODE,
    SUM(SLEEP_TIME_DTL.SP_TIME_5) AS SP_TIME_5,
    SUM(SLEEP_TIME_DTL.SP_TIME_6) AS SP_TIME_6,
    SUM(SLEEP_TIME_DTL.SP_TIME_7) AS SP_TIME_7,
    SUM(SLEEP_TIME_DTL.SP_TIME_8) AS SP_TIME_8,
    SUM(SLEEP_TIME_DTL.SP_TIME_9) AS SP_TIME_9,
    SUM(SLEEP_TIME_DTL.SP_TIME_9OVER) AS SP_TIME_9OVER
FROM
    SLEEP_TIME_DTL
JOIN
    PREFECTURE
ON
    SLEEP_TIME_DTL.PF_CODE = PREFECTURE.PF_CODE
JOIN 
    AGE_GRP
ON
    SLEEP_TIME_DTL.AGE_CODE = AGE_GRP.AGE_CODE
WHERE
    PREFECTURE.PF_CODE IN ('01000', '02000', '03000', '04000', '07000')
GROUP BY
    PREFECTURE.PF_NAME, AGE_GRP.AGE_NAME;