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