Employee Names With Department Names

Kestrel Labs is publishing an internal staff directory: every employee on one line, next to the team they belong to. The intranet template that renders it takes exactly two columns and insists on the headings employee_name and department_name.

That heading requirement is the catch, and it is not cosmetic. Both tables call their label column name, so pulling both straight through hands the template two columns with the same heading — and the template will render one of them twice without complaining about it.

The link between the two tables is a bare number: an employee row records the id of its team, never the team's name.

departments — one row per team. budget is the annual budget in dollars.

employees — one row per employee. department_id records which team they belong to. manager_id points at another employee, or is NULL.

Both tables already exist in the database — there is nothing to create or load.

Task: Write a query returning two columns, employee_name and department_name, with one row per employee. Rows come back in alphabetical order of employee_name.

Example output — shape only. These are the opening rows of an invented company, not this one's answer.