/
studentapp.sql
69 lines (66 loc) · 6.02 KB
/
studentapp.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
USE `studentsdb`;
insert into `studentapp_student`(`id`,`firstname`,`lastname`) values (1,'Nigel','Captain');
insert into `studentapp_student`(`id`,`firstname`,`lastname`) values (2,'Bruce','Camel');
insert into `studentapp_student`(`id`,`firstname`,`lastname`) values (3,'Fred','Camel');
insert into `studentapp_student`(`id`,`firstname`,`lastname`) values (4,'Cinderfred','Vee');
insert into `studentapp_student`(`id`,`firstname`,`lastname`) values (5,'Wazumi','Archer');
insert into `studentapp_student`(`id`,`firstname`,`lastname`) values (6,'Bite','Apple');
insert into `studentapp_student`(`id`,`firstname`,`lastname`) values (7,'Bee','Goog');
insert into `studentapp_student`(`id`,`firstname`,`lastname`) values (8,'Nite','Captain');
insert into `studentapp_student`(`id`,`firstname`,`lastname`) values (9,'Pilip','Ubuntu');
insert into `studentapp_student`(`id`,`firstname`,`lastname`) values (10,'Tee','Smith');
insert into `studentapp_subject`(`id`,`name`) values (3,'english');
insert into `studentapp_subject`(`id`,`name`) values (4,'maths');
insert into `studentapp_subject`(`id`,`name`) values (5,'physics');
insert into `studentapp_subject`(`id`,`name`) values (6,'chemistry');
insert into `studentapp_subject`(`id`,`name`) values (7,'social');
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (1,1,3,75);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (2,1,4,65);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (3,1,5,90);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (4,1,6,47);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (5,8,7,80);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (6,2,3,75);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (7,2,4,35);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (8,2,5,56);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (9,2,6,89);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (10,2,7,86);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (11,7,3,43);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (12,7,4,76);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (13,7,5,90);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (14,7,6,98);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (15,7,7,66);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (16,6,3,88);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (18,6,4,100);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (19,6,5,67);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (20,6,6,39);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (21,6,7,84);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (22,4,3,33);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (23,4,4,78);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (24,4,5,66);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (25,4,6,37);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (26,4,7,44);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (28,3,3,56);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (29,3,4,73);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (30,3,5,42);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (31,3,6,81);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (32,3,7,20);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (33,8,3,10);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (34,8,4,20);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (35,8,5,17);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (36,8,6,99);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (37,9,3,19);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (38,9,4,100);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (39,9,5,100);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (40,9,6,99);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (41,9,7,12);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (42,10,3,44);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (43,10,4,99);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (44,10,5,33);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (45,10,6,75);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (46,10,7,50);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (47,5,3,25);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (48,5,4,50);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (49,5,5,75);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (50,5,6,100);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (51,5,7,45);
insert into `studentapp_studentmarks`(`id`,`student_id`,`subject_id`,`marks`) values (52,1,7,68);