Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT course_name, student_name, grade_sem
- FROM Students INNER JOIN(Grades INNER JOIN Courses ON Courses.course_id = Grades.course_id) ON Students.student_id = Grades.student_id
- WHERE grade_sem>
- (SELECT max(grade) as Max_Grade
- FROM Grades);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement