GATE 2023 CS – Question 61
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.