I have two tables in a SQL database. People which has the columns (name: text, department: text, job_id: integer) and NAME_1 which has the columns (job_title: text, salary: int). Please give me an SQL query that calculates the sum of all salaries by department. Avoid using the following keywords: database, table, name_1, salary
user