I am fairly new to MySQL and having some problems figuring out how to format a couple queries using the following database:
branch (branch_name, branch_city, assets)
customer (customer_name, customer_street, customer_city)
account (account_number, branch_name, balance)
loan (loan_number, branch_name, account)
depositor (customer_name, account_number)
borrower (customer_name, loan_number)
I need to find all customers with accounts at a branch where a depositor names "Hayes" has an account (that would be in the depositor table, not borrower)
and the name and average balance of all customers who live in Harrison and have at least 2 accounts.
I don't know if you can help given the information I have posted here but if more is needed please let me know.
Hopefully this will be a big help in my understanding of MySQL