with popu_2015 as (
    select

    from
        prefecture as p
    inner join
        popu_transition as pt
    on
        p.pf_code = pf_code
    where
        pt.survey_year
),
select *
from
    popu_2015