Write a SQL query

SQL query :



Data model

Departments (idD,Name,City)
Employees (idE,#idEBoss,Name,Function,HireDate,Salary,#idD)