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