2021-10-24

CREATE	TABLE StudentInfo(
SNo VARCHAR(6) NOT NULL PRIMARY KEY,
SName VARCHAR(8) NOT NULL,
SSex VARCHAR(2) NOT NULL DEFAULT '男',
SBirthday DATE NOT NULL,
Major VARCHAR(12) NULL,
Adress VARCHAR(20) NULL
);
CREATE TABLE ScoreInfo(
SNo VARCHAR(6) NOT NULL PRIMARY KEY,
CNo VARCHAR(4) NOT NULL,
Score INTEGER
);

INSERT INTO StudentInfo
	VALUES('181001','成志强','男','1998-08-17','计算机','北京市海淀区'),
	      ('181002','孙红梅','女','1997-11-23','计算机','成都市锦江区'),
	      ('181003','朱莉','女','1998-02-19','计算机','北京市海淀区'),
	      ('184001','王智勇','男','1997-12-05','电子信息工程',NULL),
	      ('184002','周璐璐','女','1998-02-24','电子信息工程','上海市浦东区');
	      ('184004','郑永波','男','1997-09-19','电子信息工程','上海市浦东区');
	      
	      
INSERT INTO ScoreInfo
	VALUES('181001','1004','95');
	('181002','1004','85');
('181003','1004','91');
('184001','4002','93');
('184002','4002','96');
('184004','4002','88');
('184001','8001','85');
('184002','8001',NULL);
('184004','8001','94');
('181001','1201','92');
('181002','1201','78');
('181003','1201','94');
('181001','8001','94');
('181002','8001','89');
('181003','8001','86');
('184001','1201','85');
('184002','1201','79');
('184004','1201','94');