drop database if exists employees_sangoyo_3csd;
create database employees_sangoyo_3csd;
use employees_sangoyo_3csd;
create table employee_data_JPS(
emp_id int unsigned not null auto_increment primary key,
f_name varchar(20),
l_name varchar(30),
title varchar(30),
age int,
yos int,
salary int,
perks int,
email varchar(60)
);
describe employee_data_jps;
INSERT INTO employee_data_jps
(f_name, l_name, title, age, yos, salary, perks, email)
values
('Manish', 'Sharma', 'CEO', 28, 4, 200000, 50000, 'manish@bignet.com');

INSERT 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");
INSERT 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");
INSERT 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");
INSERT 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");
INSERT 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");
INSERT 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");
INSERT 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");
INSERT 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");
INSERT 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");
INSERT 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");
INSERT 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");
INSERT 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");
INSERT 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");
INSERT 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");
INSERT 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");
INSERT 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");
INSERT 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");
INSERT 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");
INSERT 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");
INSERT 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");