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;