Q. Given the following database table: First Name Last Name Department Name Salary Janet. Marshall. IT. 35000 Adam. Marks. Sales. 27500 Alice. Matters. IT. 32500 George. Flinders. HR. 27000 Thomas. Born. Sales. 42500 Marcus. Channing. IT. 37500 Write a SQL query that will list each department name along with the total salary for that department and the number of employees in that department. Can you suggest any way(s) to improve this table structure by normalising the data? Re-write the same SQL query to work against your improved table structure. Give 2 advantages of your improved table structure over the original.
For the query I would say SELECT DEPARTMENT but I don't know how to total the salary and the number of employees.,I would say for the query SELECT DEPARTMENT but I don't know how to add the salary amounts up and to count the number of employees.