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