在学籍管理中，设有4个表，关系模式分别为：
STUDFNT(SNO,SNAME,SEX,BIRTHDAY,CLASS)
TEACHER(TNO ,TNAME, SEX,BIRTHDAY,PROFESSION,DEPARTMENT)
COURSE(CNO,CNAME, TNO)
SCORE(SNO,CNO,DEGREE)
说明：
学生关系模式中：SNO：学号；SNAME://姓名；SEX：性别；BI]RTHDAY：出生日期；CLASS：班级；
教师关系模式中：TNO：教师号；TNAME://姓名；SEX：性别；BIRTHDAY：出生日期；PRO-FESSION:职称；DEPARTMENT:所在系；
课程关系模式中：CNO：课程号；CNAME://课程名；TNO:任课教师号；
成绩关系模式中：SNO:学号；CNO:课程号；DEGREE:分数。
请用SQL查询语句实现下列操作：
1)显示教师所有的单位，即不重复的DEPARTMENT列。
2)显示STUDENT表中“95031”班或性别为“女”的同学记录。
3)以CNO升序，DEGREE降序显示SCORE表的所有记录。
4)显示“95031”班的学生人数。
5)显示SCORE表中至少有5名学生选修的并以3开头的课程号的平均分。
6)显示最低分大于70，最高分小于90的SNO列。
7)显示选修“3 -105”课程的成绩高于“109”号同学成绩的所有同学的记录。
8)显示SCORE表中选学多门课程的同学中分数为非最高分成绩的记录。
9)列出学号为“108”的同学同年出生的所有学生的SNO、SNAME和BIRTHDAY。
10)显示“张三”教师任课的学生成绩。
| People express their personalities in
their clothes, their cars, and their homes. Because we might choose certain
foods to "tell" people{{U}} (36) {{/U}}about us, our diets can also be
an expression of our personalities. For{{U}} (37) {{/U}}, some people
eat mainly gourmet (鲜美的) food,{{U}} (38) {{/U}}as caviar (鱼子酱) and
lobster (龙虾) , and they eat only in{{U}} (39) {{/U}}restaurants( never
in cafeterias or snack bars). They might want to "tell" the world they know{{U}}
(40) {{/U}}the "better things in life." Human beings can eat many{{U}} (41) {{/U}}kinds of food, but some people choose not to eat{{U}} (42) {{/U}}. Vegetarians (素食者) often have more in{{U}} (43) {{/U}}than just the diet. Their personalities might be{{U}} (44) {{/U}}, too. For example, vegetarians in the U A. with B. as C. from D. for [单项选择]我国存在很多网络的高危漏洞，信息技术产品的（）程度非常低。
A. 进口化 B. 国产化 C. 研发 D. 销售 [单项选择]会计人员继续教育中会计职业道德教育的内容不包括（）
A. 形势教育 B. 品德教育 C. 专业教育 D. 法制教育 [单项选择]什么增压方式需要使用增压面板下面的座舱/飞行高度标牌？（）
A. 备用方式 B. 人工方式 C. 备用和人工方式 D. 所有增压方式 [单项选择]以下行为中，属于被动攻击的是（）
A. 重放攻击 B. 口令嗅探 C. 拒绝服务 D. 物理破坏 [单项选择]Morris蠕虫病毒，是利用（）。
A. 缓冲区溢出漏洞 B. 整数溢出漏洞 C. 格式化字符串漏洞 D. 指针覆盖漏洞 [单项选择]软件测试中根据测试用例设计的方法的不同可分为黑盒测试和白盒测试两种，它们( )。
A. 前者属于静态测试，后者属于动态测试 B. 前者属于动态测试，后者属于静态测试 C. 都属于静态测试 D. 都属于动态测试 [单选题] 服务营销是一种通过( ),进而提供服务,最终实现有利交换的营销手段。
A.关心顾客 B.与顾客保持良好交互 C.满足顾客 D.关注顾客 [单项选择]客船下述有关适用证书中，不属于法定证书的是（）。
A. 客船适航证书 B. 乘客定额证书 C. 临时乘客定额证书 D. 船舶吨位证书 [单选题]第一个发现TKI在亚裔人群中更为有效的研究是：
A.ISEL B.IDEAL1 C.IPASS D.INTACT [多项选择]下列选项中，属于酸枣仁汤组成的药物有
A. 川芎 B. 茯苓 C. 半夏 D. 知母 [判断题]绝缘靴工频耐压试验的试验周期为一年。
A.正确 B.错误 [单选题]已操作的操作票应注明（ ）字样。操作票至少应保存1年。
A.已操作 B.已执行 C.合格 D.已终结 [单项选择]
TEXT A Feld, the shoemaker, was annoyed that his helper, Sobel, was so insensitive to his reverie that he wouldn’t for a minute cease his fanatic pounding at the other bench. He gave him a look but Sobel’s bald head was bent over the last as he worked, and he didn’t notice. The shoemaker shrugged and continued to peer through the partly frosted window at the near-sighted haze of falling February snow. Neither the shifting white blur outside, nor the sudden deep remembrance of the snowy Polish village where he had wasted his youth could turn his thoughts from Max, the college boy (a constant visitor in the mind since early that morning when Feld saw him trudging through the snowdrifts on his way to school),whom he so much respected because of the sacrifices he had made throughout the years—in winter or direst heat—to further his education. An old wish returned to haunt the shoemaker: that he had had a son instead of a daughter, A. Feld is anxious about repairing Max’s worn shoes. B. Feld is an impossible dreamer with fanciful thoughts. C. Feld wants his daughter to improve her chances in life. D. Feld appreciates the qualities of diligence and persistence. [单选题]转向器是转向系中的减速增力传动装置，其功用是增大（ ）到
转向节的力矩。
A..齿轮轴 B.拉杆支架 C.转向盘 D.转向齿条 [单选题]先心病患儿作右心导管检查，诊断房间隔缺损的可靠依据是
A.右心室血氧含量减低 B.肺动脉压力降低 C.右心房压力增高 D.右心房血氧含量高于腔静脉血氧含量 E.导管从右心房进入左心室 [单项选择]常引起周围神经炎的抗癌药是( )。
A. 巯嘌呤 B. 长春新碱 C. 甲氨蝶呤 D. 氟尿嘧啶 E. L-门冬酰胺酶 [单选题]通过某井生产数据和地质资料，分析该井工作状况及其变化情况、原因，进行动态预测，并为改善生产情况提供新的( )依据的全部工作称为单井动态分析。
A.A、措施 B.B、潜力 C.C、监测 D.D、检查 我来回答: 提交
|
