Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the XML file below write the following queries in XML Q1. Find the name of an employee who lives in Lincoln and works in

Using the XML file below write the following queries in XML

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.

Anderson, Susan L

108th

Omaha

F

Brady, Dan L

P street

Lincoln

M

Chen, Peter K

124th

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

Anderson, Susan L

Mutual of Omaha

48000

Brady, Dan L

FDR

42000

Chen, Peter K

FDR

53000

Clemson, Ann K

First Bank

39000

Dale, Mary K

Mutual of Omaha

58000

Gill, Mary L

Lincoln Star

48700

Harrison, Susan M

Union Pacific (UP)

54320

Jackson, Kim A

FDR

68000

Jason, Pat M

FDR

83000

Kumar, Paul T

FDR

44000

First Bank

Omaha

FDR

Omaha

Lincoln Star

Lincoln

Mutual of Omaha

Omaha

Union Pacific (UP)

Omaha

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

Welcome the customer back and offer your help in the future.

Answered: 1 week ago