皮皮学，免费搜题
登录
搜题
【简答题】
有一个数据库student中涉及三个数据表: 存储学生信息的student表 存储课程信息的course表 用于存储学生成绩的sc表 三表结构如下: student 表: course表: sc表: 1 请写出实现下列功能的T-SQL语句: (1) 查询信女生的学号、姓名和出生日期。(2分) (2) 统计平均成绩在80分及以上的课程(含80分),并按平均成绩的升序输出课程号和平均成绩。(3分) 2 请在实现下列功能的T-SQL语句的空白处填入适当内容,使之完整:(每空1分,共10分) (1) 查询课程名称中含有’计算机’的课程号、课程名和学分。 SELECT cno,cname,ccredit from course WHERE cname __________ ________________ (2) 查询有选修课记录的学生的姓名、选修课程号和成绩,并按成绩的降降序输出。 SELECT sname,cno,grade FROM student,sc WHERE _______________________ _________________ grade ______________ (3) 查询选修了’c01’号课程且比该课程平均成绩高的学生的学号和成绩。 SELECT sno,grade FROM sc WHERE cno ='c05109' and grade > ( SELECT ____________ FROM __________ WHERE _______________ ) (4) 为sc表的grade列创建非聚集索引,索引名为IX_grade。 CREATE ________ IX_grade _______ sc(grade)
拍照语音搜题，微信中搜索"皮皮学"使用
参考答案：
参考解析：
知识点：
.
..
皮皮学刷刷变学霸
举一反三
【判断题】Not all sentences irrelevant to the topic sentence or thesis statement should be deleted.
A.
正确
B.
错误
查看完整题目与答案
【简答题】Assignment 2-Irrelevant sentences 2 Each of the following paragraphs contains sentences that are irrelevant or unnecessary to the main point of the paragraph. In the interest of paragraph unity, such ...
查看完整题目与答案
【多选题】Which sentences are irrelevant to the topic sentence? Another problem facing a number of elderly people is living on a reduced income.
A.
The amount of their monthly checks is often half the amount the checks they received when they were employed.
B.
Many find, after paying their monthly bills, that there is no money left for a movie or a dinner out.
C.
Of course, sometimes they can’t go out because of their health.
D.
Maybe they have arthritis or rheumatism, and it is painful for them to move around.
查看完整题目与答案
【简答题】The irrelevant sentences in Essay 1 are Numbers ( ), ( ), and ( ) .
查看完整题目与答案
【简答题】The irrelevant sentences in Essay 2 are Numbers ( ), ( ), ( ), and ( ) .
查看完整题目与答案
【多选题】( )are the 3 traditional trade terms frequently used by traders in China ( )
A.
CFR
B.
CIF
C.
CPT
D.
FOB
查看完整题目与答案
【简答题】Assignment 2-Irrelevant sentences 1 Each of the following paragraphs contains sentences that are irrelevant or unnecessary to the main point of the paragraph. In the interest of paragraph unity, such ...
查看完整题目与答案
【判断题】If no specific illustration is mentioned at all in the supporting sentences, such information is irrelevant.
A.
正确
B.
错误
查看完整题目与答案
【判断题】Irrelevant sentences to the main idea in the paragraph may break the rule ofcoherence.
A.
正确
B.
错误
查看完整题目与答案
【单选题】社会主义初级阶段是不可逾越的历史阶段,从根本上说是因为( )
A.
我国建设社会主义的特殊性
B.
社会主义巩固发展的共同规律
C.
由我国进入社会主义的历史条件所决定的
D.
由建成社会主义所需要的物质基础所决定的
E.
根据马克思主义经典著作的内容所决定
查看完整题目与答案
相关题目：
【判断题】Not all sentences irrelevant to the topic sentence or thesis statement should be deleted.
A.
正确
B.
错误
查看完整题目与答案
【简答题】Assignment 2-Irrelevant sentences 2 Each of the following paragraphs contains sentences that are irrelevant or unnecessary to the main point of the paragraph. In the interest of paragraph unity, such ...
查看完整题目与答案
【多选题】Which sentences are irrelevant to the topic sentence? Another problem facing a number of elderly people is living on a reduced income.
A.
The amount of their monthly checks is often half the amount the checks they received when they were employed.
B.
Many find, after paying their monthly bills, that there is no money left for a movie or a dinner out.
C.
Of course, sometimes they can’t go out because of their health.
D.
Maybe they have arthritis or rheumatism, and it is painful for them to move around.
查看完整题目与答案
【简答题】The irrelevant sentences in Essay 1 are Numbers ( ), ( ), and ( ) .
查看完整题目与答案
【简答题】The irrelevant sentences in Essay 2 are Numbers ( ), ( ), ( ), and ( ) .
查看完整题目与答案
【多选题】( )are the 3 traditional trade terms frequently used by traders in China ( )
A.
CFR
B.
CIF
C.
CPT
D.
FOB
查看完整题目与答案
【简答题】Assignment 2-Irrelevant sentences 1 Each of the following paragraphs contains sentences that are irrelevant or unnecessary to the main point of the paragraph. In the interest of paragraph unity, such ...
查看完整题目与答案
【判断题】If no specific illustration is mentioned at all in the supporting sentences, such information is irrelevant.
A.
正确
B.
错误
查看完整题目与答案
【判断题】Irrelevant sentences to the main idea in the paragraph may break the rule ofcoherence.
A.
正确
B.
错误
查看完整题目与答案
【单选题】社会主义初级阶段是不可逾越的历史阶段,从根本上说是因为( )
A.
我国建设社会主义的特殊性
B.
社会主义巩固发展的共同规律
C.
由我国进入社会主义的历史条件所决定的
D.
由建成社会主义所需要的物质基础所决定的
E.
根据马克思主义经典著作的内容所决定
查看完整题目与答案