text: USE [SoftUni]
  GO
  
  SELECT TOP 50
  e.[EmployeeID],
  CONCAT(e.[FirstName],' ', e.[LastName]) AS [EmployeeName],
  CONCAT(m.[FirstName],' ', m.[LastName]) AS [ManagerName],
  d.[Name] AS [DepartmentName]
  FROM
  [Employees] AS e
  LEFT JOIN [Employees] AS m ON m.[EmployeeID] = e.[ManagerID]
  LEFT JOIN [Departments] AS d ON e.[DepartmentID] = d.[DepartmentID]
  ORDER BY e.[EmployeeID]
  