INSERT 
INTO CONVENI_SALE_2018(SURVEY_YEAR, PF_CODE, TOTAL_VALUE) 
SELECT
      2018
    , a.PF_CODE
    , a.TOTAL_VALUE 
FROM
    CONVENIENCE a 
WHERE
    a.SURVEY_YEAR = 2018 
    AND a.KIND_CODE = '100' 
    AND a.TOTAL_VALUE IS NOT NULL;