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;