I would like to know what is the best way to filter through records.
I need to perform some calculations on student records. I have a query that gets the student and also displays qualifications they have gained in the past. The query is filtered by courses. So I end up getting more than one result for each student for each qualification they have.
I need to filter by student so I just get all their qualifications, then calculate an average, and then move on to the next student.