Question:medium
On a relation named Loan of a bank:
On a relation named Loan of a bank:
Show Hint
When working with SQL queries that involve subqueries, make sure to carefully analyze the subquery to understand what data it is filtering before considering the main query. In this case, the subquery is used to get the maximum loan amount from a specific branch, and the main query filters based on that maximum value.
Updated On: Feb 3, 2026
Show Solution
Solution and Explanation
The subquery retrieves the maximum loan amount from the "SR Nagar" branch. The amounts for "SR Nagar" are 40000, 25000, and 65000, so the maximum amount is 65000.
The main query selects the loan numbers where the loan amount is greater than 65000. From the given data, the loans with amounts greater than 65000 are:
L11: 90000 (Banjara Hills)
L23: 80000 (Balanagar)
L25: 70000 (Kondapur)
Thus, the number of rows returned by the query is 3.
Correct Answer: 3
The main query selects the loan numbers where the loan amount is greater than 65000. From the given data, the loans with amounts greater than 65000 are:
L11: 90000 (Banjara Hills)
L23: 80000 (Balanagar)
L25: 70000 (Kondapur)
Thus, the number of rows returned by the query is 3.
Correct Answer: 3
Was this answer helpful?
0
Top Questions on SQL
- Solve the following query:
- What is the output of the SQL statement?
SELECT MID('CUET2024',2,5)? - SQL applies conditions on the groups through ________ clause after groups have been formed?
- Consider the following two tables emp1 and emp2:
emp1 Id Name 1 Amit 2 Punita What is the output of the following query?emp2 Id Name 1 Punita 2 Anand
SELECT name from emp1 minus SELECT name from emp2; - Want to practice more? Try solving extra ecology questions todayView All Questions