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.
The moose likes JDBC and Relational Databases and the fly likes Another SQL problem... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Another SQL problem..." Watch "Another SQL problem..." New topic

Another SQL problem...

Amy Phillips
Ranch Hand

Joined: Apr 02, 2003
Posts: 280
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
David Peterson
Ranch Hand

Joined: Oct 14, 2001
Posts: 154
Did you manage to get the previous problem sorted out?
Is this homework for a course?
Amy Phillips
Ranch Hand

Joined: Apr 02, 2003
Posts: 280
Yes the other solution worked a treat - thanks.
These are forming part of a database system so not exactly homework.
Amy Phillips
Ranch Hand

Joined: Apr 02, 2003
Posts: 280
Its ok, I have finally worked out the solution - it turned out to be much more simple than I was trying to make it
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: Another SQL problem...
It's not a secret anymore!