rename field while copying to another table

CREATE TABLE `Teachers` AS(
    SELECT Student_ID AS Teacher_ID, Name, Address FROM `Students` );