Question 50

Consider the set of relations given below and the SQL query that follows:
Students : ( Roll_number, Name, Date_of_birth )
Courses: (Course_number, Course_name,Instructor)
Grades: (Roll_number, Course_number, Grade)
SELECT DISTINCT Name
FROM Students, Courses, Grades
WHERE Students.Roll_number = Grades.Roll_number
AND Courses.Instructor = Sriram
AND Courses.Course_number = Grades.Course_mummiber
AND Grades.Grade = A
Which ofthe following sets is computed by the above query?


Create a FREE account and get:

  • Download Maths Shortcuts PDF
  • Get 300+ previous papers with solutions PDF
  • 500+ Online Tests for Free

cracku

Boost your Prep!

Download App