-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathy.sql
More file actions
65 lines (64 loc) · 11.5 KB
/
y.sql
File metadata and controls
65 lines (64 loc) · 11.5 KB
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
/*
SQLyog Ultimate - MySQL GUI v8.2
MySQL - 5.5.5-10.4.32-MariaDB
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
create table `esp_5_magsaysay` (
`id` double ,
`student_name` varchar (765),
`gender` varchar (30),
`q1_grade` Decimal (7),
`q2_grade` Decimal (7),
`q3_grade` Decimal (7),
`q4_grade` Decimal (7),
`final_grade` Decimal (7),
`teacher` varchar (765)
);
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('1','Baluyot Frias Jan Xevier','Male','0.00','0.00','0.00','10.88','10.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('2','Batislaon,Aeron Carreon','Male','0.00','0.00','0.00','8.25','10.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('3','Bernardo Kurt Michael Riosa','Male','0.00','0.00','0.00','8.25','0.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('4','Buan, Cyrus Arvee Giongco','Male','0.00','0.00','0.00','6.38','8.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('5','Cunanan, Prince Carl','Male','0.00','0.00','0.00','10.13','0.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('6','Goingco, Drake Calvin Bautista','Male','0.00','0.00','0.00','12.75','6.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('7','Infante, James Mendez','Male','0.00','0.00','0.00','6.00','0.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('8','Lacson John Red Hernandez','Male','0.00','0.00','0.00','9.75','8.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('9','Limin,Jaslan Mangalindan','Male','0.00','0.00','0.00','6.38','0.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('10','Lusung, Yuan Lein Rodriguez','Male','0.00','0.00','0.00','12.75','9.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('11','Macaspac, Matteo Dho Arcilla','Male','0.00','0.00','0.00','11.63','8.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('12','Miranda, Franz','Male','0.00','0.00','0.00','9.38','8.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('13','Nayanggazohann,Cedy','Male','0.00','0.00','0.00','11.25','8.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('14','Quiambao, Harvin Miranda','Male','0.00','0.00','0.00','13.13','10.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('15','Reyes Mhon Vincent Corpuz','Male','0.00','0.00','0.00','11.63','10.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('16','Meneje, Gelo S.','Male','0.00','0.00','0.00','8.63','9.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('17','Serrano, Aaron Kiel Dabu','Male','0.00','0.00','0.00','12.75','10.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('18','Villamayon, Jasper Supang','Male','0.00','0.00','0.00','3.38','0.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('19','Vistar, C-Jay Gomaga','Male','0.00','0.00','0.00','6.38','10.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('20','Zapata, Xed Yuan Arcilla','Male','0.00','0.00','0.00','12.75','9.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('21','Cardenio, John Henry','Male','0.00','0.00','0.00','5.63','8.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('22','Azuelo,Jenn Mae Abenierra','Female','0.00','0.00','0.00','2.25','0.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('23','Buan, Maria Dyniss','Female','0.00','0.00','0.00','10.13','8.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('24','Bujala, Jaylovelyn Mabini','Female','0.00','0.00','0.00','10.13','9.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('25','Canete Nieran Alinsuas','Female','0.00','0.00','0.00','12.38','10.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('26','Canlapan Mayline','Female','0.00','0.00','0.00','6.00','0.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('27','Caoleng Simoune Gabrielle','Female','0.00','0.00','0.00','11.25','9.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('28','De Leon Jannadhine Breboneria','Female','0.00','0.00','0.00','7.50','8.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('29','Enriquez, Kyrie Haboc','Female','0.00','0.00','0.00','10.13','0.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('30','Estimada, Keiko','Female','0.00','0.00','0.00','12.75','10.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('31','Flores, Nicole Faith Icban','Female','0.00','0.00','0.00','12.38','10.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('32','Gabiano, Zyree','Female','0.00','0.00','0.00','10.88','8.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('33','Galula, Allyza Sophia','Female','0.00','0.00','0.00','6.00','9.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('34','Garcia, Quennie Malungcut','Female','0.00','0.00','0.00','10.50','9.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('35','Manalastas, Starr','Female','0.00','0.00','0.00','11.63','0.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('36','Marangit, Sanifa Camaya','Female','0.00','0.00','0.00','9.75','10.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('37','Mongcal, Mangcal Arcataka','Female','0.00','0.00','0.00','10.88','10.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('38','Panganiban, Micah Jewel','Female','0.00','0.00','0.00','13.13','10.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('39','Paras, Mician Rae Buntog','Female','0.00','0.00','0.00','11.63','10.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('40','Petell, Brielle Ashley Maglonzo','Female','0.00','0.00','0.00','13.13','10.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('41','Quito Ayesha','Female','0.00','0.00','0.00','10.88','10.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('42','Raandaan Jonabeth Alicante','Female','0.00','0.00','0.00','13.13','10.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('43','Serrano Misha Nunag','Female','0.00','0.00','0.00','13.13','8.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('44','Sunga Quiyane Binayog','Female','0.00','0.00','0.00','13.13','8.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('45','Villavicencio Francine Mac Castro','Female','0.00','0.00','0.00','0.00','0.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('46','Zamora Angel','Female','0.00','0.00','0.00','12.00','8.00','Khian Kervy Mamaril');
insert into `esp_5_magsaysay` (`id`, `student_name`, `gender`, `q1_grade`, `q2_grade`, `q3_grade`, `q4_grade`, `final_grade`, `teacher`) values('47','Lazaro Karen','Female','0.00','0.00','0.00','13.13','10.00','Khian Kervy Mamaril');