Which of the following is the valid syntax for creating a VIEW to view a subset of a table?

a$.)$

CREATE VIEW mississippi$\_$customers

SELECT $*$

FROM customer

WHERE state $=\text{'}$MS$\text{'}$;

b$.)$

CREATE VIEW mississippi$\_$customers

AS

SELECT $*$

FROM customer

WHERE state $=\text{'}$MS$\text{'}$;

c$.)$

CREATE VIEW mississippi$\_$customers

AS customer

SELECT $*$

WHERE state $=\text{'}$MS$\text{'}$;

d$.)$

CREATE VIEW mississippi$\_$customers

AS customer

WHERE state $=\text{'}$MS$\text{'}$;