A relational database contains two tables Student and Performance as shown…
GATE · 2019 · CS · Computer Science & IT
A relational database contains two tables Student and Performance as shown below:

The primary key of the Student table is Roll_no. For the Performance table, the columns Roll_no. and Subject_code together form the primary key. Consider the SQL query given below:
SELECT S.Student_name, sum(P.Marks)
FROM Student S, Performance P
WHERE P.Marks > 84
GROUP BY S.Student_name;
The number of rows returned by the above SQL query is ________.
Attempted by 250 students.
Sign up free to check your answer
Sign up freeLoading lesson…