On a relation named Loan of a bank: Loan loan_number | branch_name | amount L11 | Banjara Hills | 50000 L14 | Kondapur | 50000 L15 | SR Nagar | 40000 L22 | SR Nagar | 25000 L23 | Balanagar | 80000 L26 | Kondapur | 25000 L19 | SR Nagar | 65000 The following SQL query is executed: SELECT COUNT(*) FROM Loan L1 WHERE L1.amount > (SELECT MAX(L2.amount) FROM Loan L2 WHERE L2.branch_name = 'SR Nagar') The number of rows returned by the query is ________. (Answer in integer)

GATE 2025 · Databases · SQL · medium

Answer: The query returns 1 row (COUNT(*) always returns a single aggregate row; the value in that row is also 1, as only loan L23 with amount 80000 exceeds the SR Nagar maximum of 65000). Answer: 1.

1. Compute MAX amount for SR Nagar branch: SR Nagar loans: L15 (40000), L22 (25000), L19 (65000). MAX = 65000.
2. Count loans with amount > 65000: Check each loan: - L11: 50000 > 65000? No - L14: 50000 > 65000? No - L15: 40000 > 65000? No - L22: 25000 > 65000? No - L23: 80000 > 65000? YES - L26: 25000 > 65000? No - L19: 65000 > 65000? No (not strictly greater) Only L23 qualifies. COUNT(*) = 1.
3. Determine the number of rows returned: The query uses COUNT(*) with no GROUP BY, so it returns exactly 1 row. That single row contains the value 1 (the count of loans with amount > 65000). The question asks for the number of rows returned by the query — the answer is 1.