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;
select
	*
from
	CONVENI_SALE_2018