CREATE TABLE students (
sid INT,
sname STRING,
grade INT,
class INT
);
INSERT INTO TABLE students VALUES
(1, 'Nick', 5, 3),
(2, 'Eric', 5, 1),
(3, 'Joy', 5, 3),
(4, 'Jude', 3, 2),
(5, 'Lucy', 4, 2),
(6, 'Lulu', 4, 1),
(7, 'Merry', 4, 1),
(8, 'Jason', 3, 2);
CREATE TABLE courses (
cid INT,
cname STRING
);
INSERT INTO TABLE courses VALUES
(10, 'chinese'),
(20, 'math'),
(30, 'physic'),
(40, 'english'),
(50, 'chemistry'),
(60, 'biology'),
(70, 'politics');
CREATE TABLE score (
sid INT,
cid INT,
score INT
);
INSERT INTO TABLE score VALUES
(1, 10, 97),
(1, 20, 66),
(1, 30, 56),
(1, 40, 70),
(1, 50, 90),
(1, 60, 88),
(1, 70, 76),
(2, 10, 53),
(2, 20, 29),
(2, 30, 33),
(2, 40, 27),
(2, 50, 22),
(2, 60, 43),
(2, 70, 55),
(3, 10, 89),
(3, 20, 53),
(3, 30, 99),
(3, 40, 67),
(3, 50, 89),
(3, 60, 2),
(3, 70, 0),
(4, 10, 99),
(4, 20, 98),
(4, 30, 100),
(4, 40, 92),
(4, 50, 96),
(4, 60, 99),
(4, 70, 97),
(5, 10, 61),
(5, 20, 63),
(5, 30, 82),
(5, 40, 77),
(5, 50, 72),
(5, 60, 69),
(5, 70, 67),
(6, 10, 83),
(6, 20, 79),
(6, 30, 77),
(6, 40, 89),
(6, 50, 83),
(6, 60, 87),
(6, 70, 71),
(7, 10, 93),
(7, 20, 89),
(7, 30, 88),
(7, 40, 91),
(7, 50, 92),
(7, 60, 90),
(7, 70, 83),
(8, 10, 100),
(8, 20, 99),
(8, 30, 89),
(8, 40, 96),
(8, 50, 94),
(8, 60, 92),
(8, 70, 93);