创建并填充名为'score'的数据表

CREATE TABLE score ( id VARCHAR(2) NOT NULL, c_id VARCHAR(2) NOT NULL, s_id VARCHAR(2) NOT NULL, score INT NOT NULL, PRIMARY KEY (id, c_id, s_id) );

INSERT INTO score (id, c_id, s_id, score) VALUES ('01','01','01',80), ('02','01','02',75), ('03','02','01',90), ('04','02','02',85), ('05','03','01',95), ('06','03','02',70), ('07','04','01',60), ('08','04','02',50), ('09','05','01',100), ('10','05','02',85);

SELECT * FROM score;