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
;