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
;