GATE CS 2019 (Forenoon) — Question 61

Database Management Systems (DBMS)SQL Queries (DDL/DML, Joins, Aggregations)NAT2 marksMedium

A relational database contains two tables Student and Performance as shown below:
Question image
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:
sql
1SELECT S.Student_name, sum(P.Marks)
2FROM Student S, Performance P
3WHERE P.Marks > 84
4GROUP BY S.Student_name;
5
The number of rows returned by the above SQL query is ________.
Practise the full 2019-FN paper
Challenge a friend: WhatsApp Telegram
Recommended book · affiliate linkDatabase System Concepts (Korth)Normalisation, SQL, transactions and indexing — the DBMS syllabus in one book.
Practise more on SQL Queries (DDL/DML, Joins, Aggregations)Timed, in the real exam interface · free to start

A GATE question every morning

One real past-paper question every morning for your branch, answer hidden until you tap. Free on Telegram.

Join
Stuck? Ask in the student group