SELECT RPAD(Name, 30) As "BranchName",
RPAD(CONCAT(FirstName, CONCAT(' ', 
CONCAT(MiddleName, CONCAT(' ', LastName)))), 30) As "ManagerName",
RPAD(SSN, 9) As "SSN"
FROM Branch, Employee
WHERE ManagerID = Employee.ID; 
