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