The database schemaEmployee (Lastname, FirstName, MidInitial, gender, street, city)Works (Lastname, FirstName, MidInitial, company-name, salary) company (company-name, city)company (company-name, city)Manages(Lastname, FirstName, MidInitial, ManagerLastname, MFirstName, MMidInitial, start-date) Manages(Lastname, FirstName, MidInitial, ManagerLastname, MFirstName, MMidInitial, start-date)employee_table (you should define three attributes for employee and manager names)Name street city gender--------------------------------------------------------Anderson, Susan L 108th Omaha FBrady, Dan L P street Lincoln MChen, Peter K 124th Omaha MClemson, Ann M O Lincoln FDale, Mary K 132th Omaha FGill, Mary L P street Lincoln FHarrison, Susan M Old Mill Omaha FJackson, Kim A 178th Omaha FJason, Pat M 8th C.Bluffs MKumar, Paul T Dodge Omaha MOrr, Susanne S Q Omaha FPeterson, Mike E Blondo Omaha MPowell, Tom E Broadway C.Bluffs MQuinn, Jacky M 168st Omaha FRand, Pam R 13st Omaha FSchreck, Ann P 214st Elkhorn FSimon, Eric K 77th Lincoln MSmith, John A 8th C.Bluffs MThomson, Ron F Farnam Omaha MYoung, Don R Dodge Omaha MWong, Carole S Broadway C.Bluffs F works_table: (Again, you should define three attributes for employee name)employee_name company_name salary------------------------------------------------Anderson, Susan L Mutual of Omaha 48000Brady, Dan L FDR 42000Chen, Peter K FDR 53000Clemson, Ann M First Bank 39000Dale, Mary K Mutual of Omaha 58000Gill, Mary L Union Pacific 48700Harrison, Susan M Union Pacific 54320 Jackson, Kim A FDR 68000Jason, Pat M FDR 83000Kumar, Paul T FDR 44000Orr, Susanne S Lincoln Star 32000Peterson, Mike E First Bank 37000Powell, Tom E First Bank 54000Quinn, Jacky M First Bank 85000Rand, Pam R FDR 37000Schreck, Ann P First Bank 36000Simon, Eric K Mutual of Omaha 45000Smith, John A FDR 55000Thomson, Ron F First Bank 39000Young, Don R Mutual of Omaha 27000Wong, Carole S First Bank 44000 company_table: company_name city-----------------------------First Bank OmahaFDR OmahaLincoln Star LincolnMutual of Omaha OmahaUnion Pacific Omaha Manages (Note: both employee and manager names should include threeattributes):employee_name manager_name start_date-----------------------------------------------------Anderson, Susan L Dale, Mary K 15-SEP-2002Brady, Dan L Jason, Pat M 05-MAR-2004Chen, Peter K Jason, Pat M 12-JUNE-2003Clemson, Ann M Powell, Tom E 30-AUG-2001Gill, Mary L Harrison, Susan M 25-JAN-2003Jackson, Kim A Jason, Pat M 09-MAY-2008Kumar, Paul T Jason, Pat M 09-MAY-2001Rand, Pam R Smith, John A 15-JAN-2004Peterson, Mike E Powell, Tom E 30-AUG-2006Schreck, Ann P Quinn, Jacky M 28-FEB-1996Simon, Eric K Anderson, Susan L 22-FEB-2004Smith, John A Jason, Pat M 05-MAR-2003Thomson, Ron F Powell, Tom E 30-AUG-1998Wong, Carole S Quinn, Jacky M 28-FEB-2001 Young, Don R Dale, Mary K 15-SEP-2007 Find all employees in the database who live in the same cities and on the same streets as do their managers.Find salaries and company names for employees who are not managers. Find the name and the company name of the employee who has the highest salary of all employees.

Question

The database schemaEmployee (Lastname, FirstName, MidInitial, gender, street, city)Works (Lastname, FirstName, MidInitial, company-name, salary) company (company-name, city)company (company-name, city)Manages(Lastname, FirstName, MidInitial, ManagerLastname, MFirstName, MMidInitial, start-date) Manages(Lastname, FirstName, MidInitial, ManagerLastname, MFirstName, MMidInitial, start-date)employee_table (you should define three attributes for employee and manager names)Name                           street          city           gender--------------------------------------------------------Anderson, Susan L     108th        Omaha       FBrady, Dan L               P street     Lincoln       MChen, Peter K             124th         Omaha       MClemson, Ann M        O              Lincoln      FDale, Mary K               132th        Omaha       FGill, Mary L                P street      Lincoln       FHarrison, Susan M      Old Mill          Omaha FJackson, Kim A           178th         Omaha     FJason, Pat M                 8th             C.Bluffs    MKumar, Paul T           Dodge           Omaha     MOrr, Susanne S          Q               Omaha   FPeterson, Mike E      Blondo          Omaha     MPowell, Tom E         Broadway        C.Bluffs  MQuinn, Jacky M        168st           Omaha     FRand, Pam R           13st            Omaha     FSchreck, Ann P        214st           Elkhorn   FSimon, Eric K         77th            Lincoln   MSmith, John A         8th             C.Bluffs  MThomson, Ron F        Farnam          Omaha     MYoung, Don R          Dodge           Omaha     MWong, Carole S        Broadway        C.Bluffs  F works_table: (Again, you should define three attributes for employee name)employee_name         company_name      salary------------------------------------------------Anderson, Susan L     Mutual of Omaha   48000Brady, Dan L          FDR               42000Chen, Peter K             FDR                 53000Clemson, Ann M        First Bank        39000Dale, Mary K          Mutual of Omaha   58000Gill, Mary L                Union Pacific  48700Harrison, Susan M      Union Pacific  54320 Jackson, Kim A        FDR               68000Jason, Pat M          FDR               83000Kumar, Paul T          FDR               44000Orr, Susanne S          Lincoln Star      32000Peterson, Mike E      First Bank        37000Powell, Tom E         First Bank        54000Quinn, Jacky M        First Bank        85000Rand, Pam R           FDR               37000Schreck, Ann P        First Bank        36000Simon, Eric K         Mutual of Omaha   45000Smith, John A         FDR               55000Thomson, Ron F        First Bank        39000Young, Don R          Mutual of Omaha   27000Wong, Carole S         First Bank        44000 company_table: company_name          city-----------------------------First Bank                   OmahaFDR                            OmahaLincoln Star                LincolnMutual of Omaha       OmahaUnion Pacific              Omaha Manages (Note: both employee and manager names should include threeattributes):employee_name         manager_name      start_date-----------------------------------------------------Anderson, Susan L     Dale, Mary K      15-SEP-2002Brady, Dan L          Jason, Pat M      05-MAR-2004Chen, Peter K            Jason, Pat M      12-JUNE-2003Clemson, Ann M        Powell, Tom E     30-AUG-2001Gill, Mary L                Harrison, Susan M      25-JAN-2003Jackson, Kim A        Jason, Pat M      09-MAY-2008Kumar, Paul T           Jason, Pat M      09-MAY-2001Rand, Pam R           Smith, John A     15-JAN-2004Peterson, Mike E      Powell, Tom E     30-AUG-2006Schreck, Ann P        Quinn, Jacky M    28-FEB-1996Simon, Eric K         Anderson, Susan L 22-FEB-2004Smith, John A         Jason, Pat M      05-MAR-2003Thomson, Ron F        Powell, Tom E     30-AUG-1998Wong, Carole S        Quinn, Jacky M    28-FEB-2001   Young, Don R          Dale, Mary K      15-SEP-2007 Find all employees in the database who live in the same cities and on the same streets as do their managers.Find salaries and company names for employees who are not managers. Find the name and the company name of the employee who has the highest salary of all employees.

Accepted Answer

SELECT E.employee_name
FROM employees E, manages M
WHERE E.employee_name = M.manager_name AND…

Find all employees in the database who live in the same cities and on the same streets as do their managers. Find salaries and company names for employees who are not managers. Find the name and the company name of the employee who has the highest salary of all employees.