INSERT INTO conveni_sale_2018
SELECT
    survey_year
    , pf_code
    , total_value
FROM
    convenience
WHERE
    kind_code = 100
    AND total_value IS NOT NULL