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 IS NOT NULL;


SELECT *
FROM CONVENI_SALE_2018;