Q1 retrieve the name and address of all the female managers

Question

Q1: Retrieve the name and address of all the female managers

Q2: Retrieve the name and address of all employees who work in the 'Research' department.

Q3: Retrieve the name and address and his/her department name of the highest ranked employee who does not report to anybody in the company.

For each Employee, retrieve the employee's first and last name and first and last name of his or her immediate supervisor Make a list of all project numbers for projects that involve an employee whose last name is ‘Smith', either as a worker or as a manager of the department that controls the project.

Answer 1

The question below is designed to allow individual students to illustrate their theoretical understanding and practical application of computer programming. For each and every Employee, retrieve the employee's first and last name and first and last name of his/her direct supervisor. Prepare a list of all project numbers for projects which comprise an employee whose last name is ‘Smith', either as a worker or as manager of the department which handles the project.