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;