Now You Try One
Use the statement above, and rename the column with the aggregate function. Use the AS keyword, and make the heading "Average Salary".
The result looks like this:
JOB_ID AVERAGE SALARY ------ -------------- 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.
|
|