select student.stuno,stuname,avg(score) from student,stucouwhere student.stuno=stucou.stuno group by student.stuno,stuname
