hAbyw8tU

1drop database if exists employees_sangoyo_3csd;
2create database employees_sangoyo_3csd;
3use employees_sangoyo_3csd;
4create table employee_data_JPS(
5emp_id int unsigned not null auto_increment primary key,
6f_name varchar(20),
7l_name varchar(30),
8title varchar(30),
9age int,
10yos int,
11salary int,
12perks int,
13email varchar(60)
14);
15describe employee_data_jps;
16INSERT INTO employee_data_jps
17(f_name, l_name, title, age, yos, salary, perks, email)
18values
19('Manish', 'Sharma', 'CEO', 28, 4, 200000, 50000, 'manish@bignet.com');
20
21INSERT INTO employee_data_jps (f_name, l_name, title, age, yos, salary, perks, email) values ("John", "Hagan", "Senior Programmer", 32, 4, 120000, 25000, "john_hagan@bignet.com");
22INSERT INTO employee_data_jps (f_name, l_name, title, age, yos, salary, perks, email) values ("Ganesh", "Pillai", "Senior Programmer", 32, 4, 110000, 20000, "g_pillai@bignet.com");
23INSERT INTO employee_data_jps (f_name, l_name, title, age, yos, salary, perks, email) values ("Anamika", "Pandit", "Web Designer", 27, 3, 90000, 15000, "ana@bignet.com");
24INSERT INTO employee_data_jps (f_name, l_name, title, age, yos, salary, perks, email) values ("Mary", "Anchor", "Web Designer", 26, 2, 85000, 15000, "mary@bignet.com");
25INSERT INTO employee_data_jps (f_name, l_name, title, age, yos, salary, perks, email) values ("Fred", "Kruger", "Programmer", 31, 3, 75000, 15000, "fk@bignet.com");
26INSERT INTO employee_data_jps (f_name, l_name, title, age, yos, salary, perks, email) values ("John", "MacFarland", "Programmer", 34, 4, 80000, 16000, "john@bignet.com");
27INSERT INTO employee_data_jps (f_name, l_name, title, age, yos, salary, perks, email) values ("Edward", "Sakamuro", "Programmer", 25, 2, 75000, 14000, "eddie@bignet.com");
28INSERT INTO employee_data_jps (f_name, l_name, title, age, yos, salary, perks, email) values ("Alok", "Nanda", "Programmer", 32, 3, 70000, 10000, "alok@bignet.com");
29INSERT INTO employee_data_jps (f_name, l_name, title, age, yos, salary, perks, email) values ("Hassan", "Rajabi", "Multimedia Programmer", 33, 3, 90000, 15000, "hasan@bignet.com");
30INSERT INTO employee_data_jps (f_name, l_name, title, age, yos, salary, perks, email) values ("Paul", "Simon", "Multimedia Programmer", 43, 2, 85000, 12000, "ps@bignet.com");
31INSERT INTO employee_data_jps (f_name, l_name, title, age, yos, salary, perks, email) values ("Arthur", "Hoopla", "Multimedia Programmer", 32, 1, 75000, 15000, "arthur@bignet.com");
32INSERT INTO employee_data_jps (f_name, l_name, title, age, yos, salary, perks, email) values ("Kim", "Hunter", "Senior Web Designer", 32, 2, 110000, 20000, "kim@bignet.com");
33INSERT INTO employee_data_jps (f_name, l_name, title, age, yos, salary, perks, email) values ("Roger", "Lewis", "System Administrator", 35, 2, 100000, 13000, "roger@bignet.com");
34INSERT INTO employee_data_jps (f_name, l_name, title, age, yos, salary, perks, email) values ("Danny", "Gibson", "System Administrator", 34, 1, 90000, 12000, "danny@bignet.com");
35INSERT INTO employee_data_jps (f_name, l_name, title, age, yos, salary, perks, email) values ("Mike", "Harper", "Senior Marketing Executive", 36, 2, 120000, 28000, "mike@bignet.com");
36INSERT INTO employee_data_jps (f_name, l_name, title, age, yos, salary, perks, email) values ("Monica", "Sehgal", "Marketing Executive", 30, 3, 90000, 25000, "monica@bignet.com");
37INSERT INTO employee_data_jps (f_name, l_name, title, age, yos, salary, perks, email) values ("Hal", "Simlai", "Marketing Executive", 27, 2, 70000, 18000, "hal@bignet.com");
38INSERT INTO employee_data_jps (f_name, l_name, title, age, yos, salary, perks, email) values ("Joseph", "Irvine", "Marketing Executive", 27, 2, 72000, 18000, "joseph@bignet.com");
39INSERT INTO employee_data_jps (f_name, l_name, title, age, yos, salary, perks, email) values ("Shahida", "Ali", "Customer Service Manager", 32, 3, 70000, 9000, "shahida@bignet.com");
40INSERT INTO employee_data_jps (f_name, l_name, title, age, yos, salary, perks, email) values ("Peter", "Champion", "Finance Manager", 36, 4, 120000, 25000, "peter@bignet.com");