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