Try Another
The budget director has given you another request. She needs to see which jobs have an average salary greater than $25,000. Use the POSITION table to write the appropriate SELECT statement using HAVING and display the job ID and the average salary amount.
The result looks like this:
JOB_ID (EXPR) ------ ------ 4012 37546.80 4023 74776.00 4025 43888.00 4123 49921.76 4130 45241.94 4666 85280.00 4700 53477.38 4734 55744.75 5110 56977.80 5555 54738.99 5890 53893.16 6004 110448.00 6011 94953.52 6021 111593.00 8001 117832.68 9001 146432.00 16 rows processed
If your results do not match what you see above, check Review Answers for Chapter 5 for the correct SQL syntax. Remember that result tables may be shortened in this guide.
|
Copyright © 2014 CA.
All rights reserved.
|
|