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_Name

The 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 free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…