Skip to content

Instantly share code, notes, and snippets.

@levelboy

levelboy/Showing Courses with all graded students

Created November 5, 2015 01:20
Show Gist options
  • Save levelboy/1afd89a04710c3d6c554 to your computer and use it in GitHub Desktop.
Save levelboy/1afd89a04710c3d6c554 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Showing Courses with all graded students
SELECT c.Name, s.FirstName, s.LastName, g.Grade
FROM Grade g, StudentData s, Course c
WHERE g.IdStudent = s.Id and g.IdCourse = c.Id
order by g.IdCourse Asc, s.FirstName Asc, s.LastName Asc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment