This is an advanced business management question. using SQL Server Management Studio, Write SQL queries for the following three questions using joins. You will need to execute the script provided below to answer these questions.

1) Display the ManagerID, MFName, MLName, and buildindid and the building nuumber of floors of the buildings managed, for all managers. Write SQL queries using different types of joins 1. inner join, 2.right outer join, 3.left outer join , 4.full join and 5.cross join

2) Display the MFName, MLName, MSalary, MBDate, and and buildindid that the manager manages for all managers with a salary less than $55,000. Use an appropriate join. 3) Display the buildingid, Apartment number, number of bedrooms, managerfirst name and manager last name of the buildings. Use an appropriate join.