建表语句+题目+答案+表.zip

资源包括：19道SQL语句查询题目及答案、建表SQL语句、题目相关的表截图。答案中除了包含intersect、except关键词的答案，其余都在MySQL上跑过，确保运行无误（MySQL不支持intersect、except关键词），因为脑细胞死得有些多，资源分不少请大家见谅。 题目如下： Q:Find all customers who have both an account and a loan at the Perryridge branch.(ps:MySQL不支持intersect运算符) Q:Find the number of depositors for each branch. Q:Find the names of all branches where the average account balance is more than $1,200. Q:Find the names of all branches that have greater assets than all branches located in Brooklyn. Q:Find all accounts with the maximum balance. Q:Find all branches that have greater assets than some branch located in Brooklyn. Q:Find all customers who have both an account and a loan at the bank. Q:Find all customers who have accounts at all branches located in Brooklyn. Q:Find the average account balance at the Perryridge branch. Q:Find the number of tuples in the customer relation. Q:Find the number of depositors in the bank. Q:Find the number of depositors for each branch. Q:Find all customers who have a loan at the bank but do not have an account at the bank. Q:Find all branches where the total account deposit is greater than the average of the total account deposits at all branches. Q:Find all customers who have both an account and a loan at the bank. Q:Find all customers who have at most one account at the Perryridge branch. Q:Provide as a gift for all loan customers of the Perryridge branch, a $200 savings account. Let the loan number serve as the account number for the new savings account. Q:Increase all accounts with balances over $10,000 by 6%, all other accounts receiver 5%.