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;