The following MySQL statement belongs to which "Condition Types"?

SELECT emp_id, fname, lnameFROM accountWHERE start_date

SELECT emp_id, fname, lnameFROM personORDER BY emp_id DESC;

SELECT emp_id, fname, lnameFROM personORDER BY emp_id ASC;

SELECT emp_id, fname, lnameFROM personORDER BY emp_id;

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 emp_id, emp_nameFROM personORDER BY emp_id, emp_name;

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, ‘ACTIVE’, emp_id * 3.145, UPPER (lname) FROM Employee;

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

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