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