Question

Consider the table Student with attributes (rollNum, name, gender, marks). The primary key is rollNum. The SQL query is:

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

The number of rows returned by this query is:

Hint:

Always check the inequality carefully: marks>65} excludes rows where marks $=65$. Equality requires >=}.

Answer 1

Correct Answer: 2