insert into CONVENI_SALE_2018(SURVEY_YEAR,PF_CODE,TOTAL_VALUE)
select
    c.SURVEY_YEAR,c.PF_CODE,c.TOTAL_VALUE
from
    CONVENIENCE as c
where
    c.SURVEY_YEAR = 2018
and
    c.KIND_CODE = 100
and
    c.TOTAL_VALUE is not null