Having trouble with a query. DBMS Assignment Working on an assignment for school, was able to figure out all but this one.

I need to display the employee name and employee identification number along with their HOD's name and identification number.
The table is structured like this:

(TABLE NAME): EMPLOYEES

EMPLOYEE_ID  
EMPLOYEE_NAME  
HOD (which is an EMPLOYEE_ID)
In SQL, you can join a table to itself.
Treat the two sides of the join as two separate tables and you're on your way to solving it.