Question: Part B: Apply the following Query and provide appropriate answer (Total Marks=5) Use the following table to answer the query ID Name City Email Salary

Part B: Apply the following Query and provide appropriate answer (Total Marks=5)

Use the following table to answer the query

ID

Name

City

Email

Salary

1

Fatima

Sur

1@xyz.com

1000

2

Mohammed

Salalah

2@xyz.com

800

3

Khalid

Nizwa

3@xyz.com

1000

4

Ahmed

IBRA

4@xyz.com

900

5

Abdullah

Muscat

5@xyz.com

400

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Jake Chemicals Short-Term Decision Making If these new products are to be competitively priced, we have got to do something about our container costs said Mr. Walsh. Walsh is the general manager of...

Q:

use euery Part B: Apply the following Query and provide appropriate answer (Total Marks=5) Use the following table to answer the query ID Name City Email Salary 1 Fatima Sur 1@xyz.com 1000 2 Mohammed...

Q:

Part B: Apply the following Query and provide appropriate answer (Total Marks=5) Use the following table to answer the query ID Name City Email Salary 1 Fatima Sur 1@xyz.com 1000 2 Mohammed Salalah...

Q:

1)Select name, ID, Address from Customer where not city=IBRA; 2)Select * from Customer where ID Between 1 and 3; 3) Update Customer set City= Muscat where ID= 5; 4) Delete from Customer where name=...

Q:

Part B: Apply the following Query and provide appropriate answer (Total Marks=5) Use the following table to answer the query ID Name City Email Salary 1 Fatima Sur 1@xyz.com 1000 2 Mohammed Salalah...

Q:

Part B: Apply the following Query and provide appropriate answer Use the following table to answer the query ID Name City Email Salary 1 Fatima Sur 1@xyz.com 1000 2 Mohammed Salalah 2@xyz.com 800 3...

Q:

Part B: Apply the following Query and provide appropriate answer Use the following table to answer the query ID Name City Email Salary 1 Fatima Sur 1@xyz.com 1000 2 Mohammed Salalah 2@xyz.com 800 3...

Q:

Part B: Apply the following Query and provide appropriate answer Use the following table to answer the query ID Name City Email Salary 1 Fatima Sur 1@xyz.com 1000 2 Mohammed Salalah 2@xyz.com 800 3...

Q:

Use the following table to answer the query ID Name City Email Salary 1 Fatima Sur 1@xyz.com 1000 2 Mohammed Salalah 2@xyz.com 800 3 Khalid Nizwa 3@xyz.com 1000 4 Ahmed IBRA 4@xyz.com 900 5 Abdullah...

Q:

Use the following table to answer the query ID Name City Email Salary 1 Fatima Sur 1@xyz.com 1000 2 Mohammed Salalah 2@xyz.com 800 3 Khalid Nizwa 3@xyz.com 1000 4 Ahmed IBRA 4@xyz.com 900 5 Abdullah...

Q:

There is an XYZ Company, which purchases some parts from vendors to produce some products. It has several departments, marketing sites, and parts supply vendors in the company. 1) For each...

Q:

In its annual report for the year ended January 31, 2011, Virco Manufacturing Corporation , a producer of school desks and other furniture, provided the following information regarding a change in...

Q:

Find the impedance and current in each ac circuit. R = 225, L = 10.0 mH, C = 0.200 F, f = 1.00 kHz, E = 15.0 V

Q:

4 Which one of the following qualifications does a person require in order to seek the designation Registered Auditor? A A member of the Chartered Institute of Management Accountants. B A member of...

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

6. Notify employees of the change. Announce the change to an online handbook in a way that ensures all employees will know about the new format. Consider a mandatory sign-on within the transition...

Q:

3. Research the various ADR options to determine which ones are the best fit for the organization. For example, peer review is most successful when there is a high level of trust within the workforce.

Q:

7. Immediately notify employees of changes. Be sure to develop a process for maintaining the handbook and letting employees know when things change. While an online handbook can be easily updated, it...