Consider the following table named Student in a relational database. The…
GATE · 2023 · CS · Computer Science & IT
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 ______.
Attempted by 699 students.
Sign up free to check your answer
Sign up freeLoading lesson…