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