sql数据库设计题

1.select 学号,姓名 from 学生 where 班级='软件041'

2.select * from 课程 where 课程名称 like '%语言%'

3.select 学生.学号,姓名,班级 from 学生 where 学号 in(

select top 5 学号 from 选课 where 课程号 in(

select 课蚂厅喊程号 from 课程 where 课程名称='C语言'

) order by 成绩 desc

)

4.select 班级,count(1) 学生人数 from 学生 group by 班级

5.select 学号 from 选课 where 课程号=(

select 课程号 from 课程 where 课闷野程名称='计算机应用基础'

) 成绩>(select 成绩 from 选课 where 学号=(select 学号伏亏 from 学生 where 姓名='张三') and 课程号=(

select 课程号 from 课程 where 课程名称='计算机应用基础'

)

)

1.

CREATE TABLE `student` (

`Sno` int(5) NOT NULL,

`Sname` varchar(6) NOT NULL,

`Ssex` varchar(2) NOT NULL,

`Sdept` char(255),

`Sage` int(2) CHECK (value BETWEEN 15 AND 25),

PRIMARY KEY (`Sno`)

)

2.select * from student where Sname like '张%'

3.没有滚贺SC表结构

4.insert into student values(95020,"陈冬","男"饥链,"CS",18)

5.猜大肢派的表结构,update set 学分=3 where cno='3'

1.select s.sname from s,p,sp where s.sno = sp.sno and sp.pno = p.pno and p.pname like '%红和凳岁色零件粗启%'2.select sno, sname, status from s where city='唤睁北京'3.select sum(sp.qty) from sp, p where sp.pno = p.pno and p.pname like '%P2%'4.select sum(p.VEIGHT) from sp, p where sp.pno = p.pno and p.pname like '%P2%'5.update p set color = '黄色'

---