INSERT INTO CONVENI_SALE_2018(SURVEY_YEAR,PF_CODE,TOTAL_VALUE)
SELECT CV.SURVEY_YEAR
       ,CV.PF_CODE
       ,CV.TOTAL_VALUE
FROM CONVENIENCE AS CV
WHERE 1=1 
  AND CV.SURVEY_YEAR =2018
  AND CV.KIND_CODE ='100'
  AND CV.TOTAL_VALUE <> NULL