SQL语句的试题

来源：百度知道 编辑：UC知道 时间：2024/07/03 00:02:18
我们的补考题目,积分全给!
会SQL语句的朋友麻烦帮帮忙啊,题目有点长但是不难,每题写一个语句就可以了!

题目:
class(classno,departno,classname)

course(couno,couname,kind,credit,departno,schooltime,limitinum,willnum,choosenum)

department(departno,departname)

student(stuno,classno,stuname,pwd)

写出相应的SQL语句.
1,从student表中检索学号为00000001的同学姓名(stuname),要求显示学号和姓名.

2,检索课程表中最小报名人数,最大报名人数和平均报名人数.

3,减缩课程号不为00,007和013的课程号和课程名称.

4,检索不姓 刘 ,的学生信息.

5,按课程分类统计平均报名人数.

在线等!
我晕,需要答案很急的啊.一楼的别耍我了

1.
select stuno,stuname from student where stuno='00000001'

2.课程表的报名人数是哪个列?

3.
select couno,couname from course where couno not in('00','007','013')

4.
select * from student where stuname not like '刘%'

5.课程分类和报名人数的列分别是哪个?

1.select stuno,stuname from student where stuno=000000001

1.
select stuno,stuname from student where stuno='00000001'
2.
select min(willnum),max(willnum),avg(willnum)
from course
3.
select couno,couname from course where couno not in('00','007','013')
4.
select * from student where stuname not like '刘%'
5.
select *
from course
order by kind
comoute avg(willnum) by kind

我晕，没有中文注释怎么答啊！