How to find average and use group by at same time in mysql?

Question

So I have these tables:

Student(Rollno,name,address)
Subject(sub_code,sub_name)
Marks(Rollno,sub_code, marks)

I want to display average of marks roll no wise with name too. I used this query to find average of marks:

SELECT Rollno,avg(marks) FROM MARKS GROUP BY Rollno;

How do I get name of respective roll numbers ?

DHLopez · Accepted Answer · 2017-10-26 18:21:58Z

2

Try using a join:

SELECT M.Rollno, S.NAME, avg(M.marks) 
FROM Marks AS M  
JOIN Students AS S ON M.rollno = S.rollno 
GROUP BY M.Rollno, S.NAME,;

answered Oct 26, 2017 at 18:14

DHLopez

3955 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1