insert into CONVENI_SALE_2018
(
    SURVEY_YEAR
,   PF_CODE
,   TOTAL_VALUE   
)
select
    SURVEY_YEAR
,   PF_CODE
,   TOTAL_VALUE
from
    CONVENIENCE
where
    KIND_CODE = '100'
and TOTAL_VALUE is not NULL