-- 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;