SQL query to return average

Question

I have table grades:

id | student_id | grade
-----------------------
1  | 1          | 4
2  | 1          | 5
3  | 2          | 3

I want a query that returns student_id and average grade:

student_id | avg_grade
----------------------
1          | 4.5
2          | 3

What query would do that?

Possible duplicate of [Average of grouped rows in Sql Server](http://stackoverflow.com/questions/3100921/average-of-grouped-rows-in-sql-server) — Ivar, Jun 20 '16 at 14:14
Possible duplicate of [SQL: Finding Average Score](http://stackoverflow.com/questions/17098020/sql-finding-average-score) — mirosval, Jun 20 '16 at 14:21

score 0 · Accepted Answer · answered Jun 20 '16 at 14:12

0

SQL's AVG() function does that:

SELECT student_id, AVG(grade) as avg_grade
FROM grades
GROUP BY student_id

answered Jun 20 '16 at 14:12

TimoStaudinger

1 Answers1