UPDATE CANDIDACY SET NUMBER = STUDENT_NUMBER;
ALTER TABLE CANDIDACY DROP COLUMN STUDENT_NUMBER;