急!!请sql2000数据库的高手给帮忙做几道题

来源:百度知道 编辑:UC知道 时间:2024/06/18 01:58:02
请留下QQ ,在QQ上说吧!
不难!考试的题

什么题?加:345926149
注明,数据库。

select * from student where 年龄 between 20 and 25 and 性别='女'
select * from student where 班级编号 not in (select 班级编号 from student where 姓名='赵云')
update a. set a.成绩=a.成绩-10 from Grade a inner join Course b on a.课程号=b.课程号 inner join
(select 学号 from student where 年龄 in (select max(年龄) from student group by 班级编号)) c on a.学号=c.学号
where b.课程名='计算机原理'
delete from student where 年龄 in (select min(年龄) from student group by 班级编号)