INSERT INTO CONVENI_SALE_2018 (SURVEY_YEAR,PF_CODE,TOTAL_VALUE)

SELECT
SURVEY_YEAR,
PF_CODE,
TOTAL_VALUE

FROM CONVENIENCE

WHERE KIND_CODE = '100' AND
TOTAL_VALUE IS NOT NULL;

SELECT *
FROM CONVENI_SALE_2018;