INSERT INTO CONVENI_SALE_2018 (SURVEY_YEAR, PF_CODE, TOTAL_VALUE)

SELECT SURVEY_YEAR, PF_CODE, TOTAL_VALUE
FROM CONVENIENCE
WHERE SURVEY_YEAR = 2018
AND KIND_CODE = '100'
AND TOTAL_VALUE <>NULL;