Question: Write the SQL statement to: - Retrieve the name of employee whose salary is greater than the average salary of all the employees in department

Write the SQL statement to:

- Retrieve the name of employee whose salary is greater than the average salary of all the employees in department 5.

- Retrieve the name of employee whose salary is greater than the average salary of his or her corresponding department.

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:

Using the tables below: Provide the SQL statements to: 12) For each employee, show how many employee(s) each supervises. 14) Retrieve the name of employee whose salary is greater than the average...

Q:

[/ : ] Taye3 Albeek: 1. Produce a list of employees for jobs IT_PROG, SA_REP and ST_CLERK, in that order. Display last_name and job_id using set operators. 2pt [/ : ] Taye3 Albeek: 2. Display the...

Q:

Based on company database (a) Explain what would be retrieved by the following query SELECT DISTINCT PNUMBER FROM PROJECT WHERE PNUMBER IN (SELECT PNUMBER FROM PROJECT, DEPARTMENT, EMPLOYEE WHERE...

Q:

please write SQL statement? (a) Retrieve the names of employee in department 5 who work more than 10 hours per week on the ProductX project. (b) List the names of employees who have a dependent with...

Q:

Consider the following relational schema. An employee can work in more than one department; also, the percentTime field of the Works relations shows the percentage of time that a given employee works...

Q:

Consider the following relations. An employee can work in more than one department; the \ ( p c t \ ) time field of the Works relation shows the percentage of time that a given employee works in a...

Q:

HR DEPARTMENTS department_id department name manager_id location_id LOCATIONS location_id street address postal_code city state province country_id JOB_HISTORY employee id start date end date job_id...

Q:

Please quickly Write SQL commands to solve the following depending on the HR schema given below: 1. Produce a list of employees for jobs IT_PROG, SA_REP and ST_CLERK, in that order. Display last name...

Q:

Database Mgmt sytms Use the Scott database to write the following query List the project_no for projects that started in 2006 and has more than two employees. Hint: Use the PROJECT and WORKS_ON...

Q:

Consider the following relations. An employee can work in more than one department; the pct time field of the Works relation shows the percentage of time that a given employee works in a given...

Q:

Determine the domain of the following functions and represent in an (x, y)-plane. (a) f(x,y) = ln ((16-x - y)(x + y 4)) (b) f(x,y)=6-2x-3y

Q:

After the accounts are adjusted and closed at the end of the fiscal year, Accounts Receivable has a balance of $883,150 and Allowance for Doubtful Accounts has a balance of $123,250. Describe how the...

Q:

6 Arrange these parts of a body in order of size starting with the largest: cell organ tissue organ system.

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:

Recognize the power of service guarantees.

Q:

Explain the common objectives of effective customer feedback systems.

Q:

Demonstrate how to use the Gaps Model for diagnosing and