-
Notifications
You must be signed in to change notification settings - Fork 0
/
grades.sql
255 lines (252 loc) · 9.3 KB
/
grades.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
-- addind g for course 106
INSERT INTO grades (grade_id, student_id, assignment_id, grades)
VALUES
(1, 401, 5024, 92),
(2, 402, 5024, 85),
(3, 406, 5024, 88),
(4, 408, 5024, 94),
(5, 411, 5024, 81),
(6, 412, 5024, 89),
(7, 416, 5024, 95),
(8, 418, 5024, 86),
(9, 721, 5024, 90),
(10, 722, 5024, 84),
(11, 401, 5025, 97),
(12, 402, 5025, 83),
(13, 406, 5025, 91),
(14, 408, 5025, 87),
(15, 411, 5025, 96),
(16, 412, 5025, 93),
(17, 416, 5025, 82),
(18, 418, 5025, 99),
(19, 721, 5025, 80),
(20, 722, 5025, 98),
(21, 401, 5026, 81),
(22, 402, 5026, 89),
(23, 406, 5026, 95),
(24, 408, 5026, 86),
(25, 411, 5026, 90),
(26, 412, 5026, 84),
(27, 416, 5026, 92),
(28, 418, 5026, 85),
(29, 721, 5026, 88),
(30, 722, 5026, 94),
(31, 401, 5027, 87),
(32, 402, 5027, 96),
(33, 406, 5027, 93),
(34, 408, 5027, 82),
(35, 411, 5027, 99),
(36, 412, 5027, 80),
(37, 416, 5027, 98),
(38, 418, 5027, 97),
(39, 721, 5027, 83),
(40, 722, 5027, 91),
(41, 401, 5028, 89),
(42, 402, 5028, 95),
(43, 406, 5028, 86),
(44, 408, 5028, 90),
(45, 411, 5028, 84),
(46, 412, 5028, 92),
(47, 416, 5028, 85),
(48, 418, 5028, 88),
(49, 721, 5028, 94),
(50, 722, 5028, 81),
(51, 401, 5029, 96),
(52, 402, 5029, 93),
(53, 406, 5029, 82),
(54, 408, 5029, 99),
(55, 411, 5029, 80),
(56, 412, 5029, 98),
(57, 416, 5029, 97),
(58, 418, 5029, 83),
(59, 721, 5029, 91),
(60, 722, 5029, 87);
-- for 105
INSERT INTO grades (grade_id, student_id, assignment_id, grades)
VALUES
(61, 401, 5053, FLOOR(80 + RAND() * 21)),
(62, 402, 5053, FLOOR(80 + RAND() * 21)),
(63, 406, 5053, FLOOR(80 + RAND() * 21)),
(64, 408, 5053, FLOOR(80 + RAND() * 21)),
(65, 411, 5053, FLOOR(80 + RAND() * 21)),
(66, 412, 5053, FLOOR(80 + RAND() * 21)),
(67, 416, 5053, FLOOR(80 + RAND() * 21)),
(68, 418, 5053, FLOOR(80 + RAND() * 21)),
(69, 721, 5053, FLOOR(80 + RAND() * 21)),
(70, 722, 5053, FLOOR(80 + RAND() * 21)),
(71, 401, 5054, FLOOR(80 + RAND() * 21)),
(72, 402, 5054, FLOOR(80 + RAND() * 21)),
(73, 406, 5054, FLOOR(80 + RAND() * 21)),
(74, 408, 5054, FLOOR(80 + RAND() * 21)),
(75, 411, 5054, FLOOR(80 + RAND() * 21)),
(76, 412, 5054, FLOOR(80 + RAND() * 21)),
(77, 416, 5054, FLOOR(80 + RAND() * 21)),
(78, 418, 5054, FLOOR(80 + RAND() * 21)),
(79, 721, 5054, FLOOR(80 + RAND() * 21)),
(80, 722, 5054, FLOOR(80 + RAND() * 21)),
(81, 401, 5055, FLOOR(80 + RAND() * 21)),
(82, 402, 5055, FLOOR(80 + RAND() * 21)),
(83, 406, 5055, FLOOR(80 + RAND() * 21)),
(84, 408, 5055, FLOOR(80 + RAND() * 21)),
(85, 411, 5055, FLOOR(80 + RAND() * 21)),
(86, 412, 5055, FLOOR(80 + RAND() * 21)),
(87, 416, 5055, FLOOR(80 + RAND() * 21)),
(88, 418, 5055, FLOOR(80 + RAND() * 21)),
(89, 721, 5055, FLOOR(80 + RAND() * 21)),
(90, 722, 5055, FLOOR(80 + RAND() * 21)),
(91, 401, 5056, FLOOR(80 + RAND() * 21)),
(92, 402, 5056, FLOOR(80 + RAND() * 21)),
(93, 406, 5056, FLOOR(80 + RAND() * 21)),
(94, 408, 5056, FLOOR(80 + RAND() * 21)),
(95, 411, 5056, FLOOR(80 + RAND() * 21)),
(96, 412, 5056, FLOOR(80 + RAND() * 21)),
(97, 416, 5056, FLOOR(80 + RAND() * 21)),
(98, 418, 5056, FLOOR(80 + RAND() * 21)),
(99, 721, 5056, FLOOR(80 + RAND() * 21)),
(100, 722, 5056, FLOOR(80 + RAND() * 21)),
(101, 401, 5057, FLOOR(80 + RAND() * 21)),
(102, 402, 5057, FLOOR(80 + RAND() * 21)),
(103, 406, 5057, FLOOR(80 + RAND() * 21)),
(104, 408, 5057, FLOOR(80 + RAND() * 21)),
(105, 411, 5057, FLOOR(80 + RAND() * 21)),
(106, 412, 5057, FLOOR(80 + RAND() * 21)),
(107, 416, 5057, FLOOR(80 + RAND() * 21)),
(108, 418, 5057, FLOOR(80 + RAND() * 21)),
(109, 721, 5057, FLOOR(80 + RAND() * 21)),
(110, 722, 5057, FLOOR(80 + RAND() * 21)),
(111, 401, 5058, FLOOR(40 + RAND() * 11)),
(112, 402, 5058, FLOOR(40 + RAND() * 11)),
(113, 406, 5058, FLOOR(40 + RAND() * 11)),
(114, 408, 5058, FLOOR(40 + RAND() * 11)),
(115, 411, 5058, FLOOR(40 + RAND() * 11)),
(116, 412, 5058, FLOOR(40 + RAND() * 11)),
(117, 416, 5058, FLOOR(40 + RAND() * 11)),
(118, 418, 5058, FLOOR(40 + RAND() * 11)),
(119, 721, 5058, FLOOR(40 + RAND() * 11)),
(120, 722, 5058, FLOOR(40 + RAND() * 11));
-- for 107
INSERT INTO grades (grade_id, student_id, assignment_id, grades)
VALUES
(121, 401, 5033, FLOOR(80 + RAND() * 21)),
(122, 402, 5033, FLOOR(80 + RAND() * 21)),
(123, 406, 5033, FLOOR(80 + RAND() * 21)),
(124, 408, 5033, FLOOR(80 + RAND() * 21)),
(125, 411, 5033, FLOOR(80 + RAND() * 21)),
(126, 412, 5033, FLOOR(80 + RAND() * 21)),
(127, 416, 5033, FLOOR(80 + RAND() * 21)),
(128, 418, 5033, FLOOR(80 + RAND() * 21)),
(129, 721, 5033, FLOOR(80 + RAND() * 21)),
(130, 722, 5033, FLOOR(80 + RAND() * 21)),
(131, 401, 5034, FLOOR(80 + RAND() * 21)),
(132, 402, 5034, FLOOR(80 + RAND() * 21)),
(133, 406, 5034, FLOOR(80 + RAND() * 21)),
(134, 408, 5034, FLOOR(80 + RAND() * 21)),
(135, 411, 5034, FLOOR(80 + RAND() * 21)),
(136, 412, 5034, FLOOR(80 + RAND() * 21)),
(137, 416, 5034, FLOOR(80 + RAND() * 21)),
(138, 418, 5034, FLOOR(80 + RAND() * 21)),
(139, 721, 5034, FLOOR(80 + RAND() * 21)),
(140, 722, 5034, FLOOR(80 + RAND() * 21)),
(141, 401, 5035, FLOOR(80 + RAND() * 21)),
(142, 402, 5035, FLOOR(80 + RAND() * 21)),
(143, 406, 5035, FLOOR(80 + RAND() * 21)),
(144, 408, 5035, FLOOR(80 + RAND() * 21)),
(145, 411, 5035, FLOOR(80 + RAND() * 21)),
(146, 412, 5035, FLOOR(80 + RAND() * 21)),
(147, 416, 5035, FLOOR(80 + RAND() * 21)),
(148, 418, 5035, FLOOR(80 + RAND() * 21)),
(149, 721, 5035, FLOOR(80 + RAND() * 21)),
(150, 722, 5035, FLOOR(80 + RAND() * 21)),
(151, 401, 5036, FLOOR(80 + RAND() * 21)),
(152, 402, 5036, FLOOR(80 + RAND() * 21)),
(153, 406, 5036, FLOOR(80 + RAND() * 21)),
(154, 408, 5036, FLOOR(80 + RAND() * 21)),
(155, 411, 5036, FLOOR(80 + RAND() * 21)),
(156, 412, 5036, FLOOR(80 + RAND() * 21)),
(157, 416, 5036, FLOOR(80 + RAND() * 21)),
(158, 418, 5036, FLOOR(80 + RAND() * 21)),
(159, 721, 5036, FLOOR(80 + RAND() * 21)),
(160, 722, 5036, FLOOR(80 + RAND() * 21)),
(161, 401, 5037, FLOOR(80 + RAND() * 21)),
(162, 402, 5037, FLOOR(80 + RAND() * 21)),
(163, 406, 5037, FLOOR(80 + RAND() * 21)),
(164, 408, 5037, FLOOR(80 + RAND() * 21)),
(165, 411, 5037, FLOOR(80 + RAND() * 21)),
(166, 412, 5037, FLOOR(80 + RAND() * 21)),
(167, 416, 5037, FLOOR(80 + RAND() * 21)),
(168, 418, 5037, FLOOR(80 + RAND() * 21)),
(169, 721, 5037, FLOOR(80 + RAND() * 21)),
(170, 722, 5037, FLOOR(80 + RAND() * 21)),
(171, 401, 5038, FLOOR(40 + RAND() * 11)),
(172, 402, 5038, FLOOR(40 + RAND() * 11)),
(173, 406, 5038, FLOOR(40 + RAND() * 11)),
(174, 408, 5038, FLOOR(40 + RAND() * 11)),
(175, 411, 5038, FLOOR(40 + RAND() * 11)),
(176, 412, 5038, FLOOR(40 + RAND() * 11)),
(177, 416, 5038, FLOOR(40 + RAND() * 11)),
(178, 418, 5038, FLOOR(40 + RAND() * 11)),
(179, 721, 5038, FLOOR(40 + RAND() * 11)),
(180, 722, 5038, FLOOR(40 + RAND() * 11));
-- for 108
INSERT INTO grades (grade_id, student_id, assignment_id, grades)
VALUES
(181, 401, 5043, FLOOR(80 + RAND() * 21)),
(182, 402, 5043, FLOOR(80 + RAND() * 21)),
(183, 406, 5043, FLOOR(80 + RAND() * 21)),
(184, 408, 5043, FLOOR(80 + RAND() * 21)),
(185, 411, 5043, FLOOR(80 + RAND() * 21)),
(186, 412, 5043, FLOOR(80 + RAND() * 21)),
(187, 416, 5043, FLOOR(80 + RAND() * 21)),
(188, 418, 5043, FLOOR(80 + RAND() * 21)),
(189, 721, 5043, FLOOR(80 + RAND() * 21)),
(190, 722, 5043, FLOOR(80 + RAND() * 21)),
(191, 401, 5044, FLOOR(80 + RAND() * 21)),
(192, 402, 5044, FLOOR(80 + RAND() * 21)),
(193, 406, 5044, FLOOR(80 + RAND() * 21)),
(194, 408, 5044, FLOOR(80 + RAND() * 21)),
(195, 411, 5044, FLOOR(80 + RAND() * 21)),
(196, 412, 5044, FLOOR(80 + RAND() * 21)),
(197, 416, 5044, FLOOR(80 + RAND() * 21)),
(198, 418, 5044, FLOOR(80 + RAND() * 21)),
(199, 721, 5044, FLOOR(80 + RAND() * 21)),
(200, 722, 5044, FLOOR(80 + RAND() * 21)),
(201, 401, 5045, FLOOR(80 + RAND() * 21)),
(202, 402, 5045, FLOOR(80 + RAND() * 21)),
(203, 406, 5045, FLOOR(80 + RAND() * 21)),
(204, 408, 5045, FLOOR(80 + RAND() * 21)),
(205, 411, 5045, FLOOR(80 + RAND() * 21)),
(206, 412, 5045, FLOOR(80 + RAND() * 21)),
(207, 416, 5045, FLOOR(80 + RAND() * 21)),
(208, 418, 5045, FLOOR(80 + RAND() * 21)),
(209, 721, 5045, FLOOR(80 + RAND() * 21)),
(210, 722, 5045, FLOOR(80 + RAND() * 21)),
(211, 401, 5046, FLOOR(80 + RAND() * 21)),
(212, 402, 5046, FLOOR(80 + RAND() * 21)),
(213, 406, 5046, FLOOR(80 + RAND() * 21)),
(214, 408, 5046, FLOOR(80 + RAND() * 21)),
(215, 411, 5046, FLOOR(80 + RAND() * 21)),
(216, 412, 5046, FLOOR(80 + RAND() * 21)),
(217, 416, 5046, FLOOR(80 + RAND() * 21)),
(218, 418, 5046, FLOOR(80 + RAND() * 21)),
(219, 721, 5046, FLOOR(80 + RAND() * 21)),
(220, 722, 5046, FLOOR(80 + RAND() * 21)),
(221, 401, 5047, FLOOR(80 + RAND() * 21)),
(222, 402, 5047, FLOOR(80 + RAND() * 21)),
(223, 406, 5047, FLOOR(80 + RAND() * 21)),
(224, 408, 5047, FLOOR(80 + RAND() * 21)),
(225, 411, 5047, FLOOR(80 + RAND() * 21)),
(226, 412, 5047, FLOOR(80 + RAND() * 21)),
(227, 416, 5047, FLOOR(80 + RAND() * 21)),
(228, 418, 5047, FLOOR(80 + RAND() * 21)),
(229, 721, 5047, FLOOR(80 + RAND() * 21)),
(230, 722, 5047, FLOOR(80 + RAND() * 21)),
(231, 401, 5048, FLOOR(40 + RAND() * 11)),
(232, 402, 5048, FLOOR(40 + RAND() * 11)),
(233, 406, 5048, FLOOR(40 + RAND() * 11)),
(234, 408, 5048, FLOOR(40 + RAND() * 11)),
(235, 411, 5048, FLOOR(40 + RAND() * 11)),
(236, 412, 5048, FLOOR(40 + RAND() * 11)),
(237, 416, 5048, FLOOR(40 + RAND() * 11)),
(238, 418, 5048, FLOOR(40 + RAND() * 11)),
(239, 721, 5048, FLOOR(40 + RAND() * 11)),
(240, 722, 5048, FLOOR(40 + RAND() * 11));