SALARIES — Aggregate salary per department

Write a query that returns all departments and their aggregate salaries (in this column order).

Table schema

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

Hint (click to show)

Use SUM with GROUP BY.

Your SQL query