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