Highest-paid employees in each department

Tables:

department

employee

Write a query that returns the highest-paid employee(s) of each department. If several employees tie for the top salary in a department, return all of them. Return the columns department (the department name), employee and salary.

Departments without employees are not in the result.

CREATE TABLE department (
  id int PRIMARY KEY,
  name text NOT NULL
);
CREATE TABLE employee (
  id int PRIMARY KEY,
  name text NOT NULL,
  salary int NOT NULL,
  department_id int NOT NULL REFERENCES department(id)
);