select distinct
PREFECTURE.PF_CODE,
PREFECTURE.PF_NAME,
AGE_GRP.AGE_CODE,
AGE_GRP.AGE_NAME,
SLEEP_TIME_DTL.SP_TIME_5,
SLEEP_TIME_DTL.SP_TIME_6,
SLEEP_TIME_DTL.SP_TIME_7,
SLEEP_TIME_DTL.SP_TIME_8,
SLEEP_TIME_DTL.SP_TIME_9,
SLEEP_TIME_DTL.SP_TIME_9OVER
from
AGE_GRP
inner join
SLEEP_TIME_DTL
on
AGE_GRP.AGE_CODE=SLEEP_TIME_DTL.AGE_CODE
inner join
PREFECTURE
on
SLEEP_TIME_DTL.PF_CODE=PREFECTURE.PF_CODE
;