
//Creation of table

create table Employee( id int(5), first_name varchar(15), last_name varchar(15), start_date date, end_date date, salary float(8,2), city varchar(10), Designation varchar(15) );

insert into Employee (id, first_name, last_name, start_date, end_date, salary, city, Designation) values(1,'Jason','Martin',19960725,20060725, 1234.56, 'Toronto', 'Programmer');
insert into Employee (id, first_name, last_name, start_date, end_date, salary, city, Designation) values(2,'Alison','Mathews',19760321,19860221, 6661.78, 'Vancouver', 'Tester');
insert into Employee (id, first_name, last_name, start_date, end_date, salary, city, Designation) values(3,'James','Smith',19781212,19900315, 6544.78, 'Vancouver', 'Tester');
insert into Employee (id, first_name, last_name, start_date, end_date, salary, city, Designation) values(4,'Celia','Rice',19821024,19990421, 2344.78, 'Vancouver', 'Manager');
insert into Employee (id, first_name, last_name, start_date, end_date, salary, city, Designation) values(5,'Robert','Black',19840115,19980808, 2334.78, 'Vancouver', 'Tester');
insert into Employee (id, first_name, last_name, start_date, end_date, salary, city, Designation) values(6,'Linda','Green',19870730,19960104, 4322.78, 'New York', 'Tester');
insert into Employee (id, first_name, last_name, start_date, end_date, salary, city, Designation) values(7,'David','Larry',19901231,19980212, 7897.78, 'New York', 'Manager');
insert into Employee (id, first_name, last_name, start_date, end_date, salary, city, Designation) values(8,'James','Cat',19960917,20020415, 1232.78, 'Vancouver', 'Tester');

Questions

1: select * from Employee where start_data=19960725;
2: select * from Employee where id=1 OR city='Vancouver';
3: select * from Employee where id=3 OR id=5 OR id=8;
4: 








