INSERT INTO CONVENI_SALE_2018(SURVEY_YEAR,PF_CODE,TOTAL_VALUE)
VALUES(

SELECT
 SURVEY_YEAR,
 PF_CODE,
 TOTAL_VALUE

FROM
CONVENIENCE

WHERE
 SURVEY_YEAR = 2018
 AND KIND_CODE = '100'
 AND TOTAL_VALUE > 0
 
 )
 
 ;