Longest Name per Department

Return the longest employee name in each department. There is a single longest name in every department. Order by department_id.

Table schema

Employees(id INT PRIMARY KEY, name VARCHAR(50), department_id INT)

Sample data

id | name | department_id
1 | Amy | 1
2 | Zachary | 1
3 | Bo | 2