insert into conveni_sale_2018 (
   survey_year
  ,pf_code
  ,total_value
)
select  c.survey_year
       ,c.pf_code
       ,c.total_value
  from convenience as c
 where c.survey_year = 2018
   and c.kind_code   = '100'
   and c.total_value is not null