SQL Challenges

SALARIES — Department with the most professors

Write a query that returns the department with the most professors and that number (in this column order).

Table schema
CREATE TABLE SALARIES (Professor_Name TEXT, Department TEXT, Salary INT);
Hint (click to show)
GROUP BY then ORDER BY COUNT DESC LIMIT 1.