INSERT INTO CONVENI_SALE_2018
SELECT
    C.SURVEY_YEAR
    ,C.PF_CODE
    ,C.TOTAL_VALUE
FROM
    CONVENIENCE AS C
WHERE
    C.SURVEY_YEAR = 2018
    AND C.KIND_CODE = 100
    AND C.TOTAL_VALUE IS NOT NULL
;