1
GATE AI 2025
Numerical
+1
-0
$$ \text { On a relation named Loan of a bank: } $$
| Loan | ||
|---|---|---|
| Loan_number | Branch_name | Amount |
| L11 | Banjra Hills | 90000 |
| L14 | Kondapur | 50000 |
| L15 | SR Nagar | 4000 |
| 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 _________
Your input ____
GATE Data Science and Artificial Intelligence Subjects
Browse all chapters by subject
General Aptitude
Discrete Mathematics
Artificial Intelligence
Machine Learning
Database Management System and Warehousing
Python Programming
Data Structures