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