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;


SELECT * FROM CONVENI_SALE_2018