mysql> SELECT emp_id, -> 'ACTIVE' AS status, -> emp_id * 3.14159 AS empid_x_pi, -> UPPER(lname) AS last_name_upper -> FROM employee;