Consider the following relations: Student Table Roll_No Student_Name 1 Raj 2…
GATE · 2015 · CS · Set 1 · Computer Science & IT
Consider the following relations:
Student Table
Roll_No | Student_Name |
1 | Raj |
2 | Rohit |
3 | Raj |
Performance Table
Roll_No | Course | Marks |
1 | Math | 80 |
1 | English | 70 |
2 | Math | 75 |
3 | English | 80 |
2 | Physics | 65 |
3 | Math | 80 |
Consider the following SQL query.
SELECT S.Student_Name, sum(P.Marks)
FROM Student S, Performance P
WHERE S.Roll_No = P.Roll_No
GROUP BY S.Student_NameThe number of rows that will be returned by the SQL query is _____________.
Attempted by 269 students.
Sign up free to check your answer
Sign up freeLoading lesson…