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