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 and gives the highest earning person per department. Respond with more than 3 words be in all capital letters.
user