INSERT INTO CONVENI_SALE_2018
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 <> NULL;