with table_2017 AS(
    select a.area_code
        , 
    from area a
    inner join household_servey s
        on a.area_code = s.area_code
    where s.survey_year = 2012
    group by a.area_code
)

select *
from table_2017;