INSERT INTO CONVENI_SALE_2018 (
 SURVEY_YEAR
,PF_CODE
,TOTAL_VALUE
)
SELECT 
 CON.SURVEY_YEAR
,CON.PF_CODE
,CON.TOTAL_VALUE
FROM 
 CONVENIENCE CON
WHERE 
    CON.SURVEY_YEAR = '2018'
AND CON.KIND_CODE = '100'
AND CON.TOTAL_VALUE is not null
;