Which of the following is the valid syntax for creating a VIEW to view data from multiple tables?

a$.)$

CREATE VIEW employee$\_$support

AS

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

FROM employee

INNER JOIN customer

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

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

b$.)$

CREATE VIEW

AS

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

FROM employee

INNER JOIN customer

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

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

c$.)$

CREATE VIEW employee$\_$support

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

FROM employee

INNER JOIN customer

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

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

d$.)$

CREATE VIEW employee$\_$support

AS

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

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

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