17. Create View Employees with Job Titles

CREATE VIEW V_EmployeeNameJobTitle AS
SELECT (FirstName + ' ' + MiddleName + ' ' + LastName) AS [Full Name],
       JobTitle AS [Job Title]
	   FROM Employees
Не го приема
-------------------------------------------
CREATE VIEW V_EmployeeNameJobTitle AS
SELECT CONCAT(FirstName + ' ', MiddleName, ' ' + LastName) AS [Full Name],
       JobTitle AS [Job Title]
	   FROM Employees