Drop table employee;
CREATE TABLE employee (
id int unsigned not null auto_increment primary key,
firstname varchar(20),
lastname varchar(20),
title varchar(30),
age int,
yearofservice int,
salary int,
perks int,
email varchar(60)
);
INSERT INTO employee (firstname,lastName,title,age,yearofservice,salary,perks,email) values ("John","Chen","Senior Programmer",31,3,120000,25000,"j@jbxue.com");
INSERT INTO employee (firstname,email) values ("Jan","Pillai",32,4,110000,20000,"g@yahoo.com");
INSERT INTO employee (firstname,email) values ("Ane","Pandit","Web Designer",24,90000,15000,"a@jbxue.com");
INSERT INTO employee (firstname,email) values ("Mary","Anchor",27,2,85000,"m@mail.com");
INSERT INTO employee (firstname,email) values ("Fred","King","Programmer",75000,"f@net.com");
INSERT INTO employee (firstname,"Mac",80000,16000,"j@jbxue.com");
INSERT INTO employee (firstname,email) values ("Arthur","Sam",28,14000,"e@yahoo.com");
INSERT INTO employee (firstname,email) values ("Alok","Nanda",70000,10000,"a@yahoo.com");
INSERT INTO employee (firstname,email) values ("Susan","Ra","Multimedia Programmer","h@jbxue.com");
INSERT INTO employee (firstname,email) values ("Paul","Simon",23,1,12000,"ps@jbxue.com");
INSERT INTO employee (firstname,email) values ("Edward","Parhar",30,"a@jbxue.com");
INSERT INTO employee (firstname,email) values ("Kim","Hunter","Senior Web Designer","kim@coolmail.com");
INSERT INTO employee (firstname,email) values ("Roger","Lewis","System Administrator",100000,13000,"roger@mail.com");
INSERT INTO employee (firstname,email) values ("Danny","Gibson","danny@jbxue.com");
INSERT INTO employee (firstname,email) values ("Mike","Harper","Senior Marketing Executive",36,28000,"m@jbxue.com");
INSERT INTO employee (firstname,"Sunday","Marketing Executive",5,"monica@bijbxue.com");
INSERT INTO employee (firstname,email) values ("Jack","Sim",18000,"hal@jbxue.com");
INSERT INTO employee (firstname,email) values ("Joe","Irvine",72000,"joseph@jbxue.com");
INSERT INTO employee (firstname,email) values ("Henry","Ali","Customer Service Manager",9000,"shahida@jbxue.com");
INSERT INTO employee (firstname,email) values ("Peter","Champion","Finance Manager","peter@yahoo.com");