Question 22

Table Name: College

Relevant Table: College(Professor (Text), Department (text), Salary (INT))

Professor Department  Salary
John Computer Science 60,000
Van der Mechanical Engineering 55,000
Ackerman Physics 45,000
Suyash Mathematics 52,000
Simrit Computer Science 56,500
Jessica Computer Science 57,000
Jenny Personality Development 50,000

QUERY: Write a query that returns the department that makes the most along with that department's total aggregate salary.

Execute:      SELECT Department, SUM(Salary) AS TotalAggregateSalary
                     FROM College
                     GROUP BY Department
                     ORDER BY TotalAggregateSalary DESC
                     LIMIT 1;

Answer:

Department  TotalAggregateSalary
Computer Science 173,500