insert into CONVENI_SALE_2018 (SURVEY_YEAR, PF_CODE, TOTAL_VALUE)

select
  SURVEY_YEAR,
  PF_CODE,
  TOTAL_VALUE
from CONVENIENCE
where
  SURVEY_YEAR = 2018 and
  KIND_CODE = '100' and
  TOTAL_VALUE IS NOT NULL
;