The GATE Grind

GATE 2023 CS – Question 61

Databases · Relational Model: Relational Algebra, Tuple Calculus, SQL · 2 marks · Numerical answer

Consider the following table named Student in a relational database. The primary key of this table is rollNum.
Student(rollNum, name, gender, marks): (1, Naman, M, 62), (2, Aliya, F, 70), (3, Aliya, F, 80), (4, James, M, 82), (5, Swati, F, 65)
The SQL query below is executed on this database.

SELECT *
FROM Student
WHERE gender = 'F' AND
marks > 65;

The number of rows returned by the query is ______.

Practise this question in The GATE Grind →

Show answer and explanation

Correct answer: 2

Explanation

The female students are rolls 2 (70), 3 (80) and 5 (65). Only marks 70 and 80 satisfy marks > 65, so 2 rows are returned.