Using the Human Resources database, create a query that returns the following table exactly as shown. You may use any re
Posted: Sat May 14, 2022 4:09 pm
Using the Human Resources database, create a query that returns the following table exactly as shown. You may use any resources you wish, but you must complete the work on your own. Department Number of Total Employees Compensation Sales 34 304500.00 Shipping 45 156400.00 Executive 3 58000.00 Finance 6 51600.00 IT 5 28800.00 Purchasing 6 24900.00 Accounting 2 20300.00 Marketing 2 19000.00 Public Relations 1 10000.00 Human Resources 1 6500.00 Administration 1 4400.00 For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).