INSERT INTO CONVENI_SALE_2018
(
   SURVEY_YEAR
  ,PF_CODE
  ,TOTAL_VALUE
)
SELECT
   T1.SURVEY_YEAR
  ,T1.PF_CODE
  ,SUM(T1.TOTAL_VALUE)
FROM
  CONVENIENCE AS T1
WHERE
  T1.SURVEY_YEAR = 2018
  AND
  T1.KIND_CODE = 100
  AND
  T1.TOTAL_VALUE IS NOT NULL
GROUP BY
   T1.SURVEY_YEAR
  ,T1.PF_CODE;