庇护所

资源包括：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%.

此资源为北京邮电大学2017年博士研究生入学考试英语试题，无答案。欢迎感兴趣的朋友们来下载。由于当时下载消耗了不少的资源，因此积分稍贵。请大家见谅。

小组3人花两周做好的嵌入式课程设计，里面SourceCode_GUI文件夹可以直接运行，然后在超级终端就可以输入车票的一系列信息，液晶屏上就会显示出来，以及数码管上也会显示出票价。因为脑细胞死得有些多，资源分不少请大家见谅...

资源是作者本科时，使用power designer 12.5工具，在里面创建顺序图、协作图、状态图、组件图和配置图。大家感兴趣的话欢迎下载。

鄙人花了两个星期做的课程设计,尊师给了有一个A。所以分数就对不住大家了,大家互相学习! PS:内附 酒店客房管理系统课程设计报告，SQL所有的建表、功能（增、删、改、查等）语句。