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