How would you write the SELECT statement in a longer query if you wanted to concatenate the

Question:

How would you write the SELECT statement in a longer query if you wanted to concatenate the first and last name of the instructors and display that as InstructorFullName?

a. SELECT InstructorFirstName, InstructorLastName AS InstructorFullName

b. SELECT InstructorFirstName & " " & InstructorLastName AS InstructorFullName

c. SELECT InstructorFirstName AND InstructorLastName AS InstructorFullName

d. SELECT InstructorFirstName, InstructorLastName SUBSTITUTE InstructorFullName InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity InstructorState