INSERT INTO CONVENI_SALE_2018(SURVEY_YEAR, PF_CODE, TOTAL_VALUE)
SELECT
c.SURVEY_YEAR, c.PF_CODE, c.TOTAL_VALUE
FROM
CONVENIENCE c
WHERE SURVEY_YEAR = '2018' AND KIND_CODE = '100' AND TOTAL_VALUE IS NOT NULL;