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;