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;