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