Maintenance script: Table transclusion repair v1

2026-03-27T12:46:22Z

Table transclusion repair v1

← Older revision		Revision as of 12:46, 27 March 2026
Line 1:		Line 1:
	~~{{\|~~
	# Find the names of all branches in the loan relation. (4.2.1 The select Clause)		# Find the names of all branches in the loan relation. (4.2.1 The select Clause)

Line 37:		Line 36:

	# Find all customers who have at least two accounts at the Perryridge branch. (4.6.4 Test for the Absence of Duplicate Tuples)		# Find all customers who have at least two accounts at the Perryridge branch. (4.6.4 Test for the Absence of Duplicate Tuples)

	~~\|}}~~
	----		----
	[radiohead4us]		[radiohead4us]

imported>Unknown at 05:31, 7 February 2021

2021-02-07T05:31:45Z

New page

{{|
# Find the names of all branches in the loan relation. (4.2.1 The select Clause)

# Find all loan numbers for loans made at the Perryridge branch with loan amounts greater that $1200. (4.2.2 The where Clause)

# For all customers who have a loan from the bank, find their names, loan numbers and loan amount. (4.2.3 The from Clause)

# Find the customer names, loan numbers, and loan amounts for all loans at the Perryridge branch. (4.2.3 The from Clause)

# For all customers who have a loan from the bank, find their names, loan numbers, and loan amount. (4.2.5 Tuple Variables)

# Find the names of all branches that have assets greater than at least one branch located in Brooklyn. (4.2.5 Tuple Variables)

# Find the names of all customers whose street address includes the substring 'Main'. (4.2.6 String Operations)

# Find the average account balance at each branch. (4.4 Aggregate Functions)

# Find the number of depositors for each branch. (4.4 Aggregate Functions)

# Find the average balance for all accounts. (4.4 Aggregate Functions)

# Find the average balance for each customer who lives in Harrison and has at least three accounts. (4.4 Aggregate Functions)

# Find all customers who have both a loan and an account at the bank. (4.6.1 Set Membership)

# Find all customers who have both an account and a loan at the Perryridge branch. (4.6.1 Set Membership)

# Find the names of all branches that have assets greater than those of at least one branch located in Brooklyn. (4.6.2 Set Comparison)

# Find the branch that has the highest average balance. (4.6.2 Set Comparison)

# Find all customers who have both an account and a loan at the bank. (4.6.3 Test for Empty Relations)

# Find all customers who have an account at all the branches located in Brooklyn. (4.6.3 Test for Empty Relations)

# Find all customers who have at most one account at the Perryridge branch. (4.6.4 Test for the Absence of Duplicate Tuples)

# Find all customers who have at least two accounts at the Perryridge branch. (4.6.4 Test for the Absence of Duplicate Tuples)

|}}
----
[radiohead4us]

Radiohead4us/SQLPractice - Revision history

Maintenance script: Table transclusion repair v1

imported>Unknown at 05:31, 7 February 2021