Question
List (1) employee id, (2) last name (3) job id and (4) the modified or not modified salary for all employees. Show only employees --
List (1) employee id, (2) last name (3) job id and (4) the modified or not modified salary for all employees.
Show only employees -- If the salary without the increase is outside the range $6,000 $11,000 - and who are employed as a Vice Presidents or Managers (President is not counted here). - You should use Wild Card characters for this.
- the modified salary for a VP will be 30% higher - and managers a 20% salary increase. - Sort the output by the top salaries (before this increase).
The output lines should look "like" this sample line: 205 Higgins 15400
D EMPLOYEES * EMPLOYEE_ID I FIRST_NAME I LAST_NAME H EMAIL * PHONE_NUMBER I HIRE_DATE I JOB.ID H SALARY * COMMISSION_PCT I MANAGER_ID I DEPARTMENT_ID 1 2 3 4 5 6 7 8 9 10 11 12 13 EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL 24 Matt Mot MMOT 100 Steven King SKING 101 Neena Kochhar NKOCHHAR 102 Lex De Haan LDEHAAN 18 Lyn Jacobs LJACOBS 201 Michael Hartstein MHARTSTE 15 Chris Cornel CCORNEL 205 Shelley Higgins SHIGGINS 12 Dan Chancevente DCHANCE 1 Bjorn Flerjan BFLERJAN 16 Bil Gibbons BGIBBONS 3 Gus Grolin GGROLIN 174 Ellen Abel EABEL 27 Carlos Rodriguez CRODRIGUEZ 36 Ingrid Termede ITERMEDE 39 Lisa Testorok LTESTOROK 11 Miguel Sanchez MSANCHEZ 149 Eleni zlotkey EZLOTKEY 25 Gilles Turcotte GTURCOTTE 22 Jane Litrand JLITRAND 5 Dave Mustaine DMUSTAINE 4 Bill Smertal BSMERTAL 103 Alexander Hunold AHUNOLD 40 Marthe Whiteduck MWHITE DUCK 28 Malcom Young MYOUNG 9 Kurt Gruber KGRUBER PHONE_NUMBER HIRE_DATE JOB.ID 429.317.4567 18/12/24 SA REP 515.123.4567 87/06/17 AD PRES 515.123.4568 89/09/21 AD VP 515.123.4569 93/01/13 AD VP 429.317.4567 19/04/18 SA REP 515.123.5555 96/02/17 MK MAN 415.315.4567 15/03/15 SA REP 515.123.8080 94/06/07 AC MGR 429.312.4567 07/03/12 SA REP 414.111.4567 11/01/11 AC REP 429.311.4567 13/03/23 SA REP 429.311.4567 13/03/23 SA REP 011.44.1644.429267 96/05/11 SA REP 429.317.4567 15/04/27 SA REP 429.336.4536 14/12/01 SA REP 429.317.4567 13/03/03 SA REP 429.311.4511 17/10/11 SA REP 011.44.1344.429018 00/01/29 SA MAN 429.317.4567 11/01/25 SA REP 429.317.4567 15/10/22 SA REP 405.511.4567 15/05/25 SA REP 404.311.4567 14/03/24 SA REP 590.423.4567 90/01/03 IT PROG 429.317.4540 14/04/10 SA REP 429.317.4567 01/04/28 SA REP 429. 309.9032 13/09/29 SA REP 0 SALARY COMMISSION_PCT MANAGER_ID 60000 0.2 149 24000 (null) (null) 17000 (null) 100 17000 (null) 100 13000 0.2 149 13000 (null) 100 12500 0.15 149 12000 (null) 101 12000 0.15 149 12000 (null) 149 11500 0.2 149 11500 0.2 149 11000 0.3 149 11000 0.2 149 11000 0.15 149 11000 0.15 149 10500 0.2 149 10500 0.2 100 10000 0.2 149 10000 0.2 149 9600 0.2 149 9300 0.2 149 9000 (null) 102 9000 0.2 149 9000 0.2 149 9000 0.2 149 DEPARTMENT_ID 80 90 90 90 80 20 80 110 80 10 80 80 80 80 80 80 80 80 80 80 80 80 60 80 80 80 14 15 16 17 18 19 20 21 22 23 24 25 26
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