Question 23

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 with the most professors and that amount.

Execute:      SELECT Department, COUNT(*) AS ProfessorCount
                     FROM College
                     GROUP BY Department
                     ORDER BY ProfessorCount DESC
                      LIMIT 1;

Answer:

Department  ProfessorCount
Computer Science 3