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 > 0
 
 
 
 ;