SQL 练习题 样例

CREATE TABLE Student
(`Sno` long, `Sname` varchar(7), `Ssex` varchar(2), `Sage` int, `Sdept` varchar(4))
;

INSERT INTO Student
(`Sno`, `Sname`, `Ssex`, `Sage`, `Sdept`)
VALUES
(200215121, '令狐冲', '男', 20, 'CS'),
(200215122, '张无忌', '男', 20, 'CS'),
(200215123, '杨过', '男', 19, 'MA'),
(200215124, '韦小宝', '男', 18, 'IS'),
(200215125, '周芷若', '女', 17, 'CS'),
(200215126, '张三丰', '男', 25, 'AR'),
(200215127, '小龙女', '女', 21, 'MA')
;


CREATE TABLE Course
(`Cno` int, `Cname` varchar(10), `Cpno` int, `Ccredit` int)
;

INSERT INTO Course
(`Cno`, `Cname`, `Cpno`, `Ccredit`)
VALUES
(1, '数据库', 5, 4),
(2, '数学', 0, 2),
(3, '信息系统', 1, 4),
(4, '操作系统', 6, 3),
(5, '数据结构', 7, 4),