Write and execute XML statements for the following queries:

Q1. Find the name of an employee who lives in Lincoln and works in Omaha.

Q2. Find salaries of employees who live in the same cities as the companies for which they work.

Data to be used for this assignment

Employee

Name street city gender

--------------------------------------------------------

Anderson, Susan L 108th Omaha F

Brady, Dan L P street Lincoln M

Chen, Peter K 124^th Omaha M

Clemson, Ann M O Lincoln F

Dale, Mary K 132th Omaha F

Gill, Mary L P street Lincoln F

Harrison, Susan M Old Mill Omaha F

Jackson, Kim A 178th Omaha F

Jason, Pat M 8th C.Bluffs M

Kumar, Paul T Dodge Omaha M

Works: employee_name company_name salary

------------------------------------------------

Anderson, Susan L Mutual of Omaha 48000

Brady, Dan L FDR 42000

Chen, Peter K FDR 53000

Clemson, Ann M First Bank 39000

Dale, Mary K Mutual of Omaha 58000

Gill, Mary L Union Pacific 48700

Harrison, Susan M Union Pacific 54320

Jackson, Kim A FDR 68000

Jason, Pat M FDR 83000

Kumar, Paul T FDR 44000

Company:

company_name city

-----------------------------

First Bank Omaha

FDR Omaha

Lincoln Star Lincoln

Mutual of Omaha Omaha

Union Pacific (UP) Omaha