GATE | GATE-CS-2015 (Set 1) | Question 65
Consider the following relations:
Attention reader! Don’t stop learning now. Practice GATE exam well before the actual exam with the subject-wise and overall quizzes available in GATE Test Series Course.
Learn all GATE CS concepts with Free Live Classes on our youtube channel.
SELECT S. Student_Name, sum(P.Marks) FROM Student S, Performance P WHERE S.Roll_No = P.Roll_No GROUP BY S.Student_Name
The number of rows that will be returned by the SQL query is _________
Explanation: Below is result of given query. Note that there are only two student names and query prints sum(P.Marks) for every student.
Student_Name Marks Raj 310 Rohit 140