select Sno,Sname,Sex,Age from 学生表Student where Sdept='CS' with check option
55
create view 学生表student_course_2 as
select 学生表Student.Sno,Sname,Sex,Age,Cno,Grade from 学生表Student,学生选课表SC
where 学生表Student.Sno=学生选课表SC.Sno and Grade>=80 and Cno='2'
56
create view 学生表student_birth(Sno,Sname,Sbirth) as
select Sno,Sname,2008-Age from 学生表Student
57
select Sno,Sname
from c_学生表student
where Age between 18 and 22
58
select Sno,Sname
from 学生表student_course_2 where Sex='女' and Grade>=90
59
update c_学生表student set Sname = '张良' where Sno='201010'
60 61
DELETE
FROM c_学生表student WHERE Sno= '201007';
（2）1）
CREATE VIEW Bj_orders(orderid,goodsname,quantity,customerid,cname) AS
select orderid,goodsname,quantity,orders.customerid,cname from orders,customers,goods
where customers.customerid=orders.customerid and goods.goodsid=orders.goodsid and city='beijing'
2） Select*
from Bj_orders
where Cname='张三'
试验7
1） JWGL第四章，例1，3~7
1. create procedure 学生表student_course as
select 学生表student.Sno,Sname,Cname,Grade
from 学生表student,课程表Course,学生选课表SC
where 学生表student.Sno=学生选课表SC.Sno and 课程表Course.Cno= 学生选课表SC.Cno and Sname='刘伟';
