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 SURVEY_YEAR = 2018
AND C.KIND_CODE = '100'
AND C.TOTAL_VALUE <> NULL;