SQL

Now use the following tables : (xx is your login number)

staffxx (staffNo, lname, fname, dept, desig, joiningDate, salary, rating, branchCode)

also DOB, commission and GossSalary

branchxx (branchCode, address, city, phone, yearOfOpening)

Please note the code for rating as

1 = Full time employee

2 = Contract employee

3 = Visiting employee

1.Add two columns Manager (same as staffID) and managerSince (date) in branch table

2.Modify three tuples of the branch table to add manager code and managerSince date in branch table

3. Now run the queries:
   1. List the details of all the managers who are listed in branch table
   2. List all the managers who are working as manager for more than 2 years
   3. List a manager who is working as a manager at the same branch ever since he has joined

SQL