题目内容

在学生管理数据库(SMD)中有以下关系:Student(Sno,Sname,Ssex,Sage,Clno),Course(Cno,Cname,Credit),SC(Sno,Cno,Score)。对应的中文表达:学生(学号,姓名,性别,年龄,班级号),Course(课程号,课程名,学分),选课(学号,课程号,成绩)。用SQL语句完成下列查询。(1)查询所有年龄为20岁的男生的信息。(2)查询选修00001号课程的学生的最高分。(3)查询所有名字中含有“王”字的学生的信息。(4)查询本学期正在选修00003号课程的学生的学号。(5)查询每位学生的学号和平均成绩,并按照平均成绩降序排。(6)查询每位学生的学号、课程号和成绩,同时将每个班的平均成绩汇总出来,并按照班级号升序排。

查看答案
更多问题

What does FAB stand for?

A. FAB stands for facts, advantages and behaviors.
B. FAB stands for features, advantages and behaviors.
C. FAB stands for features, advantages and benefits.

Which one of the following is describing the features of a cardigan?

A. The cardigan is made of 100% cashmere
B. The cardigan is comfortable to wear.
C. The cardigan makes you elegant and enhances your dress sense.

Which one of the following sentences describes the advantages of a product?

A. The function allows you to keep the water in the kettle at the selected temperature.
B. Compared with competing products, ours are smaller and lighter yet it is most advanced, reliable and user-friendly.
C. The mute function is accomplished by pressing the red button for 3 seconds.

Which one of the following sentences describes the benefits of a product?

A. If it’s in the warranty period, we offer free service.
B. The company was certified to ISO9001, so the quality is guaranteed.
C. If you use this machine, it will not only save time but also increase your productivity by 20 percent.

答案查题题库