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