This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I have an instructor table where each instructor has a unique ins_id, there is also a mentor_id column which allows instructors to mentor other instructors. This is show by having the ins_id of the mentoring instructor in the mentor_id column sort of like: ins_ID Mentor_ID 1 - 2 - 3 2 4 2 5 3 The problem is I need to show the average number of instructors per mentor but am a bit lost on how to do this. I am guessing something like counting the number of occurences each instructor has in the mentor field and dividing it? If anyone has any ideas I would be very grateful Thanks