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;