INSERT INTO CONVENI_SALE_2018
SELECT 
     SURVEY_YEAR
    ,PF_CODE
    ,SUM(TOTAL_VALUE)
FROM CONVENIENCE
WHERE SURVEY_YEAR = '2018'
AND   KIND_CODE = '100'
GROUP BY
 SURVEY_YEAR
,PF_CODE
HAVING SUM(TOTAL_VALUE) IS NOT NULL