This week's book giveaways are in the iOS and Features new in Java 8 forums. We're giving away four copies each of Barcodes with iOS: Bringing together the digital and physical worlds and Core Java for the Impatient and have the authors on-line! See this thread and this one 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