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;