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 not null
;