What will be the result of the following MySQL command?

SELECT emp_id,‘ACTIVE’ STATUS,emp_id * 3.14 emp_pi,UPPER (lname) last_nameFROM employee;

SELECT emp_id,‘ACTIVE’ AS STATUS,emp_id * 3.14 AS emp_pi,UPPER (lname) AS last_nameFROM employee;

SELECT emp_id, ‘ACTIVE’, emp_id * 3.145, UPPER (lname) FROM Employee;

SELECT emp_id, fname, lnameFROM personORDER BY emp_id DESC;

SELECT emp_id, fname, lnameFROM personORDER BY emp_id ASC;

SELECT d.name, COUNT (emp_id) emp_noFROM department d INNER JOIN Employee eON d.dept_id=e.emp_idGROUP BY d.nameHAVING COUNT (emp_id)>2

SELECT fname, lname, person_idFROM personWHERE lname=’s’;/* after Execution*/ Mysql tool RETURN EMPTY SET 0:00sec

SELECT e.emp_id, e.fname,e.lname,d.nameFROM employee e INNER JOIN department dON e.dept_id=e.dept_id;

SELECT e.emp_id, e.fname,e.lname,d.nameFROM employee AS e INNER JOIN department AS dON e.dept_id=e.dept_id;

SELECT emp_id, fname, lnameFROM personORDER BY emp_id;

SELECT emp_id, emp_nameFROM personORDER BY emp_id, emp_name;