A table named employees is given below:
Which of the following statements would return the employees names, in ascending order, based
on their last name and first name?
Each correct answer represents a complete solution. Choose all that apply.
A.
select fname, lname from employees order by lname;
B.
select fname, lname from employees order by lname desc;
C.
select fname, lname from employees group by lname;
D.
select fname, lname from employees order by lname asc;
Explanation: