Radiohead4us/SQLPractice

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

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

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

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

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

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

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

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

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

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

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

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

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

1. 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)

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

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

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

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

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

---

[radiohead4us]