2024-01-25 21:55:48 +01:00
|
|
|
|
--Which is the student’s grade average on the courses that he has taken?
|
|
|
|
|
|
|
2024-01-25 19:40:23 +01:00
|
|
|
|
select avg(TakenCourses.grade) as averageGrade, Students.pNbr
|
|
|
|
|
|
from TakenCourses
|
|
|
|
|
|
join Students on TakenCourses.pNbr = Students.pNbr
|
|
|
|
|
|
where TakenCourses.pNbr = '790101-1234'
|
