I'm a complete newbie at salesforce and have spent hours trying to figure this out with no luck (so far)!
The schema is fairly simple: (Objects are bold)
There are Teachers (contact record types) that teach Courses which Students (contact record types) can enroll (Enrollment) on.
I need to display the following:
A list of all Courses | The teachers (Courses can only have 1 teacher) | The number of Students enrolled on that course.
ANY help with the query and/or displaying the aggregated result on a visualforce page will be highly appreciated, Thank you.