INSERT INTO CONVENI_SALE_2018
(
  SURVEY_YEAR,
  PF_CODE,
  TOTAL_VALUE
)
select
  SURVEY_YEAR,
  PF_CODE,
  TOTAL_VALUE
from CONVENIENCE AS CON  where CON.SURVEY_YEAR = '2018' and CON.KIND_CODE = 100 and CON.TOTAL_VALUE is not NULL;