insert into CONVENI_SALE_2018(SURVEY_YEAR,PF_CODE,TOTAL_VALUE )
select SURVEY_YEAR,PF_CODE,TOTAL_VALUE
from CONVENIENCE
where CONVENIENCE.SURVEY_YEAR = 2018
AND
KIND_CODE = 100 
AND
TOTAL_VALUE IS NOT NULL;