insert into conveni_sale_2018 


select
survey_year,
pf_code,
total_value
from
convenience
where
survey_year = 2018
and kind_code = '100'
and total_value is not null