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.
More Relational algebra, tuple calculus and SQL questions
GATE 2025 DA Q62– Consider the following tables, Loan and Borrower, of a bank. Loan: loan num branch name…
GATE 2024 DA Q26– Consider a database that includes the following relations: Defender(name, rating, side,…
GATE 2024 DA Q31– Consider the following two tables named Raider and Team in a relational database…
GATE 2026 DA Q42– Consider the given relations X, Y and Z. The relation X has three columns P, Q and R. The…
GATE 2026 DA Q51– Consider a table Employee(EmpID, TeamID), where the column EmpID (ID of an employee) is…
GATE 2026 DA Q59– Let there be two relations X and Y as shown. X has three columns P, Q and R. Y has two…