GATE 2025 DA – Question 33
On a relation named Loan of a bank:
| loan number | branch name | amount |
|---|---|---|
| L11 | Banjara Hills | 90000 |
| L14 | Kondapur | 50000 |
| L15 | SR Nagar | 40000 |
| L22 | SR Nagar | 25000 |
| L23 | Balanagar | 80000 |
| L25 | Kondapur | 70000 |
| L19 | SR Nagar | 65000 |
the following SQL query is executed.
SELECT L1.loan_number
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*)
Practise this question in The GATE Grind →
Show answer and explanation
Correct answer: 3
Explanation
The subquery finds the largest loan amount at SR Nagar, which is $\max(40000, 25000, 65000) = 65000$. The query returns the loans with an amount larger than that: L11 (90000), L23 (80000) and L25 (70000). So 3 rows are returned.