display student.firstName, student.surName, course.name,
result.mark, course.passMark, result.grade where
student gotResult result and result inCourse course
and result.mark < course.passMark
student.firstName
|
student.surName
|
course.name
|
result.mark
|
course.passMark
|
result.grade
|
fred |
Williams |
Physics 1 |
30 |
60 |
E |
bill |
Allen |
Physics 1 |
35 |
60 |
E |