-- Activity: SQL basics
-- (no submission)

-- Import alldbs.sql into your database server.
-- Write SQL queries to solve the following problems. 
-- You will need to consider tables:  
--    loan, depositor, borrower, and account. 

-- 1. Find all loans over $1200

-- 2. Find the loan number for each loan of an amount greater than $1200

-- 3. Which branches have loan amounts greater than $1200?

-- 4. List the branches that have loan amounts greater than $1200 in alphabetical order

-- 5. I need the account numbers and balances of all our customers

-- 6. Suppose the bank is updating the customers' account balances with 2.5% interest; that is, if the customer currently has $100 in his/her account, the balance will be updated to $100 * 1.025 = $102.5. Display account numbers and the balances with 2.5% interest of all customers. Also, rename the column header for balances as "New Balance"

-- 7. Display the names of our customers, the branches they have accounts, and the amounts they have in their accounts. List them by the branches and then the amounts

-- 8. Show me a list of customer names and the amounts they borrowed

-- 9. Give me the names of all customers who have a loan at the Perryridge branch

-- 10. Find the names of all customers, their loan numbers, the branch they have their loan with, and the amount of their loan. Note: do not list the common column(s) twice

-- 11. [optional] Find the names of all customers who have a loan, an account, or both from the bank

-- 12. [optional] Find the names of all customers who have a loan and an account from the bank