北大“数据库原理”上机实践题目总结(15)
INSERT INTO W193_ATHLETE VALUES('1001','李明','男','计算机系')
INSERT INTO W193_ATHLETE VALUES('1002','张三','男','数学系')
INSERT INTO W193_ATHLETE VALUES('1003','李四','男','计算机系')
INSERT INTO W193_ATHLETE VALUES('1004','王二','男','物理系')
INSERT INTO W193_ATHLETE VALUES('1005','李娜','女','心理系')
INSERT INTO W193_ATHLETE VALUES('1006','孙丽','女','数学系')
INSERT INTO W193_PROJECT VALUES('x001','男子五千米','一操场')
INSERT INTO W193_PROJECT VALUES('x002','男子标枪','一操场')
INSERT INTO W193_PROJECT VALUES('x003','男子跳远','二操场')
INSERT INTO W193_PROJECT VALUES('x004','女子跳高','二操场')
INSERT INTO W193_PROJECT VALUES('x005','女子三千米','三操场')
INSERT INTO W193_GRADE VALUES('1001','x001','6')
INSERT INTO W193_GRADE VALUES('1001','x003','4')
INSERT INTO W193_GRADE VALUES('1002','x001','4')
INSERT INTO W193_GRADE VALUES('1002','x003','6')
INSERT INTO W193_GRADE VALUES('1003','x001','2')
INSERT INTO W193_GRADE VALUES('1004','x001','0')
INSERT INTO W193_GRADE VALUES('1004','x003','2')
INSERT INTO W193_GRADE VALUES('1005','x004','6')
INSERT INTO W193_GRADE VALUES('1006','x004','4')
athlete(a#,aname,sex,dno)
project(p#,pname,address)
grade(a#,p#,jf)
delete from w193_grade
where p#='x002'
select * from w193_grade