insert into CONVENI_SALE_2018
select con.survey_year, con.PF_CODE, con.total_value
from convenience con
where con.survey_year = 2018 and con.kind_code = 100 and con.total_value is not null;