*** I WILL PROVIDE YOU ALL DOCUMENTS AND POWER POINTS FOR THIS ASSIGNMENT*** **

*** I WILL PROVIDE YOU ALL DOCUMENTS AND POWER POINTS FOR THIS ASSIGNMENT***
** SQL KNOWLEDGE IS REQUIRED**
For this assignment you need to create a self-join query. This is how you handle queries for U-Nary Relationships if you remember back to week 2 and ERDs.
You must perform this exercise twice:
1. Referee/Mentor (you will need to enter at least 10 rows of refs and mentors to run the query)
2. Nurse/supervisor self-join.
Here is an example to get you started that I went over in class:
What you need to submit:
1. Screen capture of both of your self-join queries showing the name of the nurse/ref and the name of the supervisor/mentor, with a second window logic check so that the reviewer can see that the ID numbers for each column matches correctly to the names.