Advertisement
Guest User

Untitled

a guest
Nov 21st, 2019
131
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. SELECT course_name, student_name, grade_sem
  2. FROM Students INNER JOIN(Grades INNER JOIN Courses ON Courses.course_id = Grades.course_id) ON Students.student_id = Grades.student_id
  3. WHERE grade_sem>
  4. (SELECT max(grade) as Max_Grade
  5. FROM Grades);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement