INSERT INTO CONVENI_SALE_2018 (SURVEY_YEAR
,PF_CODE
,TOTAL_VALUE)
SELECT SURVEY_YEAR
,PF_CODE
,TOTAL_VALUE
FROM CONVENIENCE

WHERE 1=1
AND SURVEY_YEAR=2018
AND KIND_CODE='100'
AND TOTAL_VALUE IS NOT NULL;