Now You Try It
As part of the Human Resources department's research on insurance claims, they need a list of employees who have more than the average number of dependents. To get this information, you need access to the COVERAGE table. Your report should display employee ID and number of dependents.
The result looks like this:
EMP_ID NUM_DEPENDENTS ------ -------------- 3411 3 3411 3 3338 2 2246 2 2246 2 3767 2 3767 2 3199 2 3199 2 2894 3 2894 3 5090 3 1765 2 1765 2 3991 5 3991 5 3991 5 4962 4 3222 2 2437 2 2096 3 2096 3 5008 2 5008 2 2448 3 1234 5 1003 3 1003 3 2781 2 3704 3 30 rows processed
If your results do not match what you see above, check Review Answers for Chapter 7 for the correct SQL syntax. Remember that result tables may be shortened in this guide.
|
Copyright © 2014 CA.
All rights reserved.
|
|