Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

plz answer this Based On Appendix A For all the employees, write a Select statement that return the difference between employee salary and the average

image text in transcribed

plz answer this

Based On Appendix A For all the employees, write a Select statement that return the difference between employee salary and the average salary of the employees who have the same manager as the employee Appendix A - HR Tables 1 dbo. Departments Columns + DEPARTMENT_ID PK bigint not nun) DEPARTMENT_NAME (varchar(250). null) D MANAGER ID (bigint null) D LOCATION ID (bgint null) 2 dbo.Countries @ Columns Country JD (PK varchar(50), not num) Country Name (varchar(2501 null) I Region JD (bigint muld de Employees Columns 7 VELOYEE JD PK bigint, not mut) 1 FRST NAME (varchar(50), null) LAST NAVE (varchar(50), FH ENAL (varchar(50. m) PHONE NUMBER (varehur (90) mu I HORE DATE (date, nato) Os JD varguar(50l, null) SALARY Ont, mult) COMMISSION PCT (Most null) MANAGER JD (bigint, null) DEPARTMENT ID (bigint, mualo) Odbolocations Columns * Location_jid K bigint not nut) Street Address (varchuar (50), nun) Postal Code (varchar(501. run City tvarchards. UT) Suate Province Marchar(50), ) Country D (varcha 501 ) obo Regions Columns Region ID IPK bigint, notruft) D Region Name (varchar(501. num) lob JD PK varcharisol not our My Salmy it hull' Mar Salary(int.)

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

Next Generation Databases NoSQLand Big Data

Authors: Guy Harrison

1st Edition

1484213300, 978-1484213308

More Books

Students also viewed these Databases questions

Question

In an Excel Pivot Table, how is a Fact/Measure Column repeated?

Answered: 1 week ago