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
 ;