CREATE VIEW employee$\_$support

AS

SELECT employee.first$\_$name, employee.last$\_$name, count$(*)$ as customer$\_$count

FROM employee

INNER JOIN customer

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

GROUP BY employee.first$\_$name, employee.last$\_$name;

How would you query the view to display the results in ascending order of the customer$\_$count?

a$.)$

SELECT $*$ FROM employee$\_$support

ORDER BY customer$\_$count;

b$.)$

SELECT $*$ FROM employee$\_$support

ORDER BY customer$\_$count DESC;

c$.)$

SELECT $*$ FROM customer$\_$support

ORDER BY employee$\_$count DESC;

d$.)$

SELECT COUNT$(*)$ FROM employee$\_$support;