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 is not NULL;