How to find an average grade for each student with SQL

Question

Hi,

I have a list of grades that students received. Each student appears multiple times in the table. How do I produce a list of all the students with their average grade?

P.s. I've tried looking at previously asked questions to see if I can find something relevant, but with no luck.

Answer 1

Look up the AVG function and the GROUP BY clause.

Answer 2

Since it's homework . . .

You are basically trying to aggregate data in SQL. Try googling along those lines.