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