GATE DA 2025 | Question: 23 On a relation named Loan of a bank:the following SQL query is executed.

GATE DA 2025 | Question: 23
On a relation named Loan of a bank:
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).

Ans : 3

⏰ Time stamp
➡️ 0:00 Question
➡️ 0:24 Solution

My Other Youtube Channel https://www.youtube.com/@monafitc https://www.youtube.com/@monalisapradhan16
Get Lecture notes at https://monalisacs.com/
---------------------------------------------------
📗👩‍🏫DBMS Lecture for GATE CS : https://www.youtube.com/playlist?list=PL767-rEuXhcPyNdorURDlzlFIU5lRrAWS
❓🙋‍♀️DBMS GATE PYQ : https://www.youtube.com/playlist?list=PL767-rEuXhcPgY-cyY8roELrZ-8fAzj8p
----------------------------------------------------
📗👩‍🏫Math Lecture for GATE CS : https://www.youtube.com/playlist?list=PL767-rEuXhcO4TP5PwNCYvxxRZUEQWNdP
❓🙋‍♀️Math GATE PYQ : https://youtube.com/playlist?list=PL767-rEuXhcNHqc2QrjTWNLpFf8mKYnSJ
----------------------------------------------
❓🙋‍♀️GATE General Aptitude (GA) solved by Monalisa https://www.youtube.com/playlist?list=PL767-rEuXhcN9fgYnXz--m4uwJiEi66td
----------------------------------------------------------------
📘👩‍🏫Algorithm Lectures :https://www.youtube.com/playlist?list=PL767-rEuXhcNz3RzupBowAjH2VIxCiY4z
❓🙋‍♀️Algorithm GATE PYQ: https://www.youtube.com/playlist?list=PL767-rEuXhcPvbsxbBWbDSlRZ4e6kAVve
----------------------------------------------------------------
📙👩‍🏫Compiler Design Lectures :https://youtube.com/playlist?list=PL767-rEuXhcOgCrFXRxyvfO_4INJET0f0
❓🙋‍♀️Compiler Design PYQ :https://youtube.com/playlist?list=PL767-rEuXhcOVm9ABkyap0uSyjFz6c5cS
----------------------------------------------------------------------
📔👩‍🏫Theory Of Computation Lectures : https://youtube.com/playlist?list=PL767-rEuXhcPQWMuHXOCZzj5PqF9YBVZt
❓🙋‍♀️TOC GATE PYQ: https://youtube.com/playlist?list=PL767-rEuXhcN7sn9TCRxhmvDpG7RLT3UK
-------------------------------------------------------------------
📒👩‍🏫Data Structure Lecture: https://youtube.com/playlist?list=PL767-rEuXhcMiMbX4IU_oqWshY6z8Rc7j
❓🙋‍♀️Data Structure PYQ: https://youtube.com/playlist?list=PL767-rEuXhcOWUPgW1RrIkUKAle1YBdh1
-----------------------------------------------------------------------
#gate #gate_cs #gateexam #gateda #gatedatascience #gatecse #gatecs #dbms #database #datascience #datawarehouse #sql @monafitc​

Видео GATE DA 2025 | Question: 23 On a relation named Loan of a bank:the following SQL query is executed. канала Monalisa CS