INSERT INTO CONVENI_SALE_2018 (
    SURVEY_YEAR,
    PF_CODE,
    TOTAL_VALUE
    )
SELECT  
    SURVEY_YEAR,
    PF_CODE,
    TOTAL_VALUE
FROM CONVENIENCE
WHERE CONVENIENCE.KIND_CODE = '100' AND CONVENIENCE.TOTAL_VALUE IS NOT NULL