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