$($Solve it with SQL Plus application, please$)$E$.$ SELECT ename,sal

FROM emp

ORDER BY sal DESC,ename ASCENDING;

Examine the table instance chart for the employee table.

You want to display employee hire date from the earliest to latest.

Which SQL

statement would you use?

A$.$ SELECT hire$\_$date. FROM employee;

B$.$ SELECT hire$\_$date. FROM employee ORDER BY hire$\_$date;

C$.$ SELECT hire$\_$date. FROM employee GROUP BY hire$\_$date;

D$.$ SELECT hire date. FROM employee ORDER BY hire$\_$date

DESC;

Which operator would be evaluated first?

A$.$ OR

B$.$ AND

C$.$ NOT

D$.$ IS NULL