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;