Hi.

I have two tables:

Students:
studentID, name

Scores:
studentID, score

I need to do a query that displays all students together with their average scores. That is:
studentID, name, averageScore

How do I build this query?

Thx.