BIS 155
TTT12
chapter_7.xlsxLogic-Lookup-Student
| Employee ID | Criteria: | Title | Quick Search Results: | Bonus Amount | Date | Percent | ||||
| Last Day of Year | 12/31/18 | Hired before | 1/1/05 | 9% | ||||||
| Supervisor Salary Threshold | $ 70,000.00 | Hired on or before | 1/1/10 | 5% | ||||||
| Hired after | 1/1/10 | 3% | ||||||||
| Transpayne Sales Rep Salary Information | ||||||||||
| Employee ID | Name | Location | Title | Hire Date | Years Employed | Salary | Bonus Amount | Raise Status | ||
| 3824 | Rush | Austin | Supervisor | 10/14/07 | $ 68,750 | |||||
| 4955 | Miller | Chicago | Admin | 11/3/13 | $ 49,575 | |||||
| 2521 | Zellon | Nashville | Admin | 6/14/09 | $ 46,000 | |||||
| 4453 | Fuka | Nashville | Supervisor | 3/9/04 | $ 75,800 | |||||
| 2967 | Hein | Chicago | Admin | 12/4/09 | $ 46,795 | |||||
| 2645 | Folkerts | Austin | Admin | 6/5/09 | $ 43,750 | |||||
| 1268 | Woods | Austin | Admin | 9/3/10 | $ 45,250 | |||||
| 4458 | Linkemann | Austin | Admin | 7/19/09 | $ 47,240 | |||||
| 1370 | Fox | Austin | Admin | 9/18/09 | $ 47,835 | |||||
| 2848 | Flint | Nashville | Admin | 10/15/11 | $ 46,725 | |||||
| 3996 | Kleine | Nashville | Admin | 2/18/10 | $ 45,000 | |||||
| 4070 | Wilson | Chicago | Admin | 4/3/10 | $ 45,125 | |||||
| 3099 | Divis | Chicago | Supervisor | 1/17/06 | $ 65,500 | |||||
| 2698 | Crum | Austin | Admin | 4/15/07 | $ 49,750 | |||||
| 2611 | Wiley | Chicago | Admin | 8/15/12 | $ 41,000 | |||||
| 1256 | Jenkins | Austin | Admin | 11/4/10 | $ 45,100 | |||||
| 2009 | Borys | Austin | Admin | 7/14/11 | $ 39,750 | |||||
| 4428 | Ramirez | Nashville | Admin | 11/8/11 | $ 41,525 | |||||
| 4545 | Webb | Chicago | Admin | 4/15/07 | $ 49,750 | |||||
| 1281 | Noel | Chicago | Admin | 1/31/09 | $ 43,750 | |||||
Database-Student
| Transpayne Sales Rep Salary Information | |||||||
| Employee ID | Name | Location | Title | Hire Date | Salary | ||
| 3824 | Rush | Austin | Supervisor | 10/14/07 | $ 68,750 | ||
| 4955 | Miller | Chicago | Admin | 11/3/13 | $ 49,575 | ||
| 2521 | Zellon | Nashville | Admin | 6/14/09 | $ 46,000 | ||
| 4453 | Fuka | Nashville | Supervisor | 3/9/04 | $ 75,800 | ||
| 2967 | Hein | Chicago | Admin | 12/4/09 | $ 46,795 | ||
| 2645 | Folkerts | Austin | Admin | 6/5/09 | $ 43,750 | ||
| 1268 | Woods | Austin | Admin | 9/3/10 | $ 45,250 | ||
| 4458 | Linkemann | Austin | Admin | 7/19/09 | $ 47,240 | ||
| 1370 | Fox | Austin | Admin | 9/18/09 | $ 47,835 | ||
| 2848 | Flint | Nashville | Admin | 10/15/11 | $ 46,725 | ||
| 3996 | Kleine | Nashville | Admin | 2/18/10 | $ 45,000 | ||
| 4070 | Wilson | Chicago | Admin | 4/3/10 | $ 45,125 | ||
| 3099 | Divis | Chicago | Supervisor | 1/17/06 | $ 65,500 | ||
| 2698 | Crum | Austin | Admin | 4/15/07 | $ 49,750 | ||
| 2611 | Wiley | Chicago | Admin | 8/15/12 | $ 41,000 | ||
| 1256 | Jenkins | Austin | Admin | 11/4/10 | $ 45,100 | ||
| 2009 | Borys | Austin | Admin | 7/14/11 | $ 39,750 | ||
| 4428 | Ramirez | Nashville | Admin | 11/8/11 | $ 41,525 | ||
| 4545 | Webb | Chicago | Admin | 4/15/07 | $ 49,750 | ||
| 1281 | Noel | Chicago | Admin | 1/31/09 | $ 43,750 | ||
| Criteria Range: | Summary Statistics: | ||||||
| Employee ID | Name | Location | Title | Hire Date | Salary | Average | |
| Low | |||||||
| High | |||||||
| # of Employees | |||||||
| Output Range: | |||||||
| Employee ID | Name | Location | Title | Hire Date | Salary | ||
| $ 46,000 | |||||||
| $ 46,725 | |||||||
| $ 45,000 | |||||||
| $ 41,525 |
