Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started