Consider the following view that has been created:

CREATE VIEW customer$\_$support

AS

SELECT customer.first$\_$name AS cust$\_$first$\_$name, customer.last$\_$name AS cust$\_$last$\_$name,

employee.first$\_$name AS emp$\_$first$\_$name, employee.last$\_$name AS emp$\_$last$\_$name

FROM employee

INNER JOIN customer

ON employee.employee$\_$id $=$ customer.support$\_$rep$\_$id;

How would you query the view to order the names by the employee's last name followed by the customer's last name, in alphabetical order?

a$.)$

SELECT $*$ FROM customer$\_$support

ORDER BY emp$\_$last$\_$name DESC, cust$\_$last$\_$name DESC;

b$.)$

SELECT $*$ FROM customer$\_$support

ORDER BY cust$\_$last$\_$name, emp$\_$last$\_$name;

c$.)$

SELECT $*$ FROM customer$\_$support

ORDER BY cust$\_$last$\_$name ASC, emp$\_$last$\_$name ASC;

d$.)$

SELECT $*$ FROM customer$\_$support

ORDER BY emp$\_$last$\_$name, cust$\_$last$\_$name;