SALARIES — Professors per department

Write a query that returns every department and the number of professors in each one (in this column order).

Table schema

CREATE TABLE SALARIES (Professor_Name TEXT, Department TEXT, Salary INT);

Hint (click to show)

GROUP BY Department with COUNT.

Your SQL query