/* Creating additional derived columns */

SELECT  student_id, fname, lname, sex, (student_id * 2)		/* multiply */
FROM student;

SELECT  student_id,  fname || ' ' || lname,  sex		/* concatenate */
FROM student;							/* in Oracle   */

SELECT  student_id,  concat(fname, ' ', lname),  sex		/* concatenate */
FROM student;							/* in MySql    */