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