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