/* Giving a column a new new (i.e. alias)  */

SELECT  fname, lname AS "Last Name", (student_id + 1000) AS New_id
FROM student;

SELECT  student_id,  concat(fname, ' ', lname) AS Fullname,  sex
FROM student;	

SELECT  student_id,  concat(fname, ' ', lname) Fullname,  sex	   /* the AS is */
FROM student;							   /* optional  */