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

Step 1: Separate records by gender

From the table, list only the rows where gender = F:

• Aliya — 70
• Aliya — 80
• Swati — 65

---

Step 2: Apply marks constraint

Now check which of the above records have marks strictly greater than 65:

• Aliya — 70 ✔
• Aliya — 80 ✔
• Swati — 65 ✘ (not greater than 65)

---

Step 3: Count qualifying entries

Number of students satisfying both conditions = 2

---

Final Answer:

2