-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathStudents_Table.sql
60 lines (60 loc) · 9.61 KB
/
Students_Table.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
create table Students_Table (
id INT,
first_name VARCHAR(50),
last_name VARCHAR(50),
dob DATE,
gender VARCHAR(50),
CGPA DECIMAL(4,2),
address VARCHAR(50),
email VARCHAR(50)
);
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (1, 'Burt', 'Adshed', '09-Sep-2000', 'Male', 4.79, 'Lubomierz', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (2, 'Raymund', 'Hatherleigh', '15-Jul-1999', 'Male', 5.76, 'Longbei', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (3, 'Cindelyn', 'McGurn', '12-Feb-2000', 'Female', 5.71, 'Shu', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (4, 'Freddy', 'Dyche', '19-Sep-1999', 'Male', 2.37, 'Beringinjaya', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (5, 'Lon', 'Guilloud', '27-Dec-1999', 'Male', 2.24, 'Guilmaro', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (6, 'Veronica', 'Dawdary', '05-Apr-1999', 'Female', 8.9, 'Foz Giraldo', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (7, 'Patrizius', 'Farmloe', '14-Jun-1997', 'Male', 3.25, 'Villefranche-sur-Mer', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (8, 'Ambrosio', 'Shayler', '04-Sep-2000', 'Male', 5.03, 'Węgierska Górka', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (9, 'Myca', 'Daugherty', '14-Jun-1998', 'Male', 2.78, 'Kuršumlija', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (10, 'Rebe', 'Aldus', '25-Oct-1996', 'Female', 9.77, 'Pacaembu', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (11, 'Joela', 'Broz', '25-Jan-1997', 'Female', 5.35, 'Debark’', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (12, 'Dana', 'McCluney', '03-Apr-2000', 'Male', 1.17, 'Tianya', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (13, 'Alejandrina', 'Paver', '29-Oct-1997', 'Female', 8.85, 'Santai', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (14, 'Agnella', 'Halford', '15-Jan-1997', 'Female', 3.94, 'Ouésso', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (15, 'Clerissa', 'Simak', '22-Jan-1997', 'Female', 7.32, 'Det Udom', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (16, 'Ermengarde', 'Wixon', '09-Nov-1999', 'Female', 2.74, 'Tečovice', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (17, 'Moore', 'Basnett', '03-Mar-1997', 'Male', 2.42, 'Orosh', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (18, 'Rabbi', 'Pickervance', '22-Jul-1999', 'Male', 9.25, 'Aubagne', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (19, 'Tisha', 'Chesshire', '05-Nov-1997', 'Female', 5.65, 'San Cristóbal Totonicapán', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (20, 'Samson', 'Dumbleton', '30-Dec-1996', 'Male', 4.04, 'Villa Hayes', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (21, 'Giordano', 'Barnewall', '26-May-2000', 'Male', 1.52, 'Limit', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (22, 'Liane', 'Mulgrew', '24-Dec-1999', 'Female', 3.5, 'Bailianhe', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (23, 'Bryanty', 'Jenney', '01-Dec-1999', 'Male', 9.35, 'Sąspów', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (24, 'Allison', 'Newbigging', '12-Jan-1997', 'Female', 1.19, 'A Yun Pa', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (25, 'Iago', 'Summerill', '07-Mar-1998', 'Male', 3.21, 'Liopétri', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (26, 'Michal', 'Cherm', '10-Feb-2000', 'Male', 5.83, 'Kamimaruko', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (27, 'Cristiano', 'Gartell', '08-Nov-1997', 'Male', 9.35, 'Polo', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (28, 'Constance', 'Holleran', '12-Nov-1998', 'Female', 6.01, 'Gif-sur-Yvette', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (29, 'Stoddard', 'Webburn', '10-Sep-2000', 'Female', 7.36, 'Sadek', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (30, 'Merci', 'Savidge', '19-Aug-1997', 'Female', 6.11, 'Tanggung', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (31, 'Lauraine', 'Sangster', '15-Feb-1998', 'Female', 3.18, 'Esmeraldas', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (32, 'Elnar', 'Piercey', '20-Nov-1999', 'Male', 1.55, 'Pensacola', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (33, 'Orson', 'Orwell', '30-Mar-1997', 'Male', 4.29, 'Wangyi Zhendian', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (34, 'Adelle', 'Busswell', '16-Jul-2000', 'Female', 6.22, 'Tsibulev', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (35, 'Joseito', 'Dacey', '24-Feb-1997', 'Male', 2.9, 'Yirga ‘Alem', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (36, 'Sabina', 'McCallister', '03-Jun-1998', 'Female', 4.18, 'Ilovka', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (37, 'Idelle', 'Lapworth', '10-Aug-2000', 'Female', 9.32, 'Buenos Aires', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (38, 'Gustave', 'Fouracres', '26-Feb-1997', 'Male', 5.92, 'Shawnee Mission', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (39, 'Celine', 'O''Fihily', '03-Sep-1999', 'Female', 5.52, 'Turija', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (40, 'Tammi', 'Goldes', '16-May-2000', 'Female', 2.26, 'Yezhi', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (41, 'Rudolf', 'Ward', '29-Apr-1997', 'Male', 6.69, 'Shatian', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (42, 'Base', 'Dangerfield', '20-Feb-2000', 'Male', 1.3, 'Penza', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (43, 'Olga', 'Simeoni', '04-Sep-2000', 'Female', 3.27, 'Kiihtelysvaara', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (44, 'Pepe', 'Throssell', '13-May-1998', 'Male', 6.11, 'Kosti', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (45, 'Barnie', 'Hallibone', '08-Apr-1998', 'Male', 6.65, 'Mölndal', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (46, 'Sterne', 'Boldra', '09-Feb-1999', 'Male', 8.26, 'Shuigou’ao', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (47, 'Ephrayim', 'Reedshaw', '28-Apr-2000', 'Male', 6.39, 'Ágios Efstrátios', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (48, 'Aleta', 'Horrod', '08-Dec-1999', 'Female', 1.19, 'Kuching', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (49, 'Leon', 'Dolohunty', '13-Aug-2000', 'Male', 8.88, 'Issad', '[email protected]');
insert into Students_Table (id, first_name, last_name, dob, gender, CGPA, address, email) values (50, 'Bertrando', 'Kitchenside', '28-Oct-1998', 'Male', 5.5, 'Jingdezhen', '[email protected]');