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: