GROUP BY JSJ15_S112.S# HAVING COUNT(*)>=3 )
INSERT INTO JSJ15_S112
VALUES ('11032005','向阳','男','1990-12-10','1.75','西14舍312') INSERT INTO JSJ15_C112
VALUES ('CS-03','离散数学','64','4','陈建明')
UPDATE JSJ15_C112 SET PERIOD = 56 WHERE C# = 'CS-04' UPDATE JSJ15_C112
SET CREDIT = CREDIT +1 WHERE C# = 'CS-04'
CREATE VIEW S_MALE
AS SELECT S#,SNAME,BDATE,HEIGHT FROM JSJ15_S112 WHERE SEX='男' AND DORM='东9'
CREATE VIEW TEACHER_ZHANG(C#,CNAME,AVG_G) AS SELECT JSJ15_C112.C#,CNAME,AVG(GRADE) FROM JSJ15_C112,JSJ15_SC112 WHERE TEACHER='张明'
GROUP BY JSJ15_C112.C#,JSJ15_C112.CNAME
CREATE VIEW COURSE
AS SELECT JSJ15_S112.S#,JSJ15_C112.CNAME,GRADE FROM JSJ15_S112,JSJ15_C112,JSJ15_SC112 WHERE JSJ15_S112.S#=JSJ15_SC112.S# AND JSJ15_C112.C#=JSJ15_SC112.C# AND JSJ15_C112.CNAME='数据结构'