IST331 Lab Assignement 3 Scored

Question: #1385

IST331 Lab Assignement 3

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.

Solution: #1365

IST331 Lab Assignement 3 Scored

1. SELECT a.FNAME, a. ADDRESS
    FROM EMPLOYEE a
    JOINS DEPARTMENT b ON a.DNO=b.DNUMBER
    WHERE a.SEX=’F’
2. SELECT a.FNAME, a. ADDRESS
   ...