Write the SQL code for the following queries (you do not have to give the results of the query)
1. List the employee id and sum of days duration for employees that have spent over total 100 days working on projects (use a having command and not a nested query).
select emp_id, sum(days_duration) AS totaldays
…> from project
…> group by emp_id
…> having sum(days_duration)>100;
2. Display the count of employees whose department is located in a flying air ship.
3. Display the title and birth date of the employees whose manager is Director Fury who have worked on a project with Loki as the villain (use INTERSECT).
4. Display the manager of the employee with the oldest project start date.
5. List the average cost of projects for employees who weakness is “no super power” and the average cost of projects for all other employees, create a new column that labels each total (use UNION ALL).
create table DEPARTMENT
(
department char(24) NOT NULL,
manager char(24) NOT NULL,
Location char(32) NOT NULL,
dno Integer NOT NULL,
PRIMARY KEY (dno)
);
create table EMPLOYEE
(emp_id Integer NOT NULL,
title char(18) NOT NULL,
bdate char(24) NOT NULL,
gender char(8) NOT NULL,
fname char(12) NOT NULL,
lname char(18) NOT NULL,
dno Integer NOT NULL,
address char(32) NOT NULL,
PRIMARY KEY (emp_id)
);
create table POWERS
(
emp_id Integer NOT NULL,
power char(32) NOT NULL,
PRIMARY KEY (emp_id,power)
);
create table WEAKNESS
(
emp_id Integer NOT NULL,
weakness char(32) NOT NULL,
PRIMARY KEY (emp_id,weakness)
);
create table PROJECT
(
prj_id Integer NOT NULL,
emp_id Integer NOT NULL,
start_date date NOT NULL,
days_duration Integer NOT NULL,
villain char(28) NOT NULL,
project_cost Numeric(18,2) NOT NULL,
PRIMARY KEY (prj_id)
);
INSERT INTO EMPLOYEE VALUES (10001,’superman’,’12/13/1973′,’M’,’Clark’,’Kent’,1,’Metropolis’);
INSERT INTO EMPLOYEE VALUES (10002,’aquaman’,’7/12/1976′,’M’,’Arthur’,’Curry’,1,’Atlantean_Royal_Palace,Atlantis’);
INSERT INTO EMPLOYEE VALUES (10003,’batman’,’5/28/1979′,’M’,’Bruce’,’Wyane’,1,’Gotham_City’);
INSERT INTO EMPLOYEE VALUES (10004,’flash’,’10/27/1976′,’M’,’Wally’,’West’,1,’Central_City’);
INSERT INTO EMPLOYEE VALUES (10005,’wonderwoman’,’6/17/1976′,’F’,’Diana’,’Prince’,1,’Themyscira,Greece’);
INSERT INTO EMPLOYEE VALUES (10006,’thor’,’3/21/321′,’M’,’Thor’,’Odinson’,2,’Asgardian_Royal_Palace,Asgard’);
INSERT INTO EMPLOYEE VALUES (10007,’ironman’,’2/11/1981′,’M’,’Tony’,’Stark’,2,’Los_Angelos,California’);
INSERT INTO EMPLOYEE VALUES (10008,’hulk’,’2/22/1984′,’M’,’Bruce’,’Banner’,2,’Unknown’);
INSERT INTO EMPLOYEE VALUES (10009,’captainamerica’,’9/30/1907′,’M’,’Steven’,’Rogers’,2,’Unknown’);
INSERT INTO EMPLOYEE VALUES (10010,’blackwidow’,’6/23/1977′,’F’,’Natasha’,’Romanova’,2,’Unknown’);
INSERT INTO EMPLOYEE VALUES (10011,’thetick’,’8/2/1969′,’M’,’The’,’Tick’,3,’Arthurs_apartment’);
INSERT INTO EMPLOYEE VALUES (10012,’arthurmoth’,’1/17/1973′,’M’,’Arthur’,’TheAccountant’,3,’Arthurs_apartment’);
INSERT INTO EMPLOYEE VALUES (10013,’antman’,’3/17/1985′,’M’,’Hank’,’Pym’,2,’New_York’);
INSERT INTO POWERS VALUES (10001,’strength’);
INSERT INTO POWERS VALUES (10001,’speed’);
INSERT INTO POWERS VALUES (10001,’lazer-eyes’);
INSERT INTO POWERS VALUES (10001,’flight’);
INSERT INTO POWERS VALUES (10001,’durablity’);
INSERT INTO POWERS VALUES (10002,’water_animal_control’);
INSERT INTO POWERS VALUES (10002,’strength’);
INSERT INTO POWERS VALUES (10002,’fast_swimming’);
INSERT INTO POWERS VALUES (10002,’trident’);
INSERT INTO POWERS VALUES (10003,’ninja_skills’);
INSERT INTO POWERS VALUES (10003,’wealth’);
INSERT INTO POWERS VALUES (10004,’really_fast’);
INSERT INTO POWERS VALUES (10005,’invisible_plane’);
INSERT INTO POWERS VALUES (10005,’laso_of_truth’);
INSERT INTO POWERS VALUES (10005,’indestructible_bracelets’);
INSERT INTO POWERS VALUES (10005,’projectile_tiara’);
INSERT INTO POWERS VALUES (10006,’strength’);
INSERT INTO POWERS VALUES (10006,’durablity’);
INSERT INTO POWERS VALUES (10006,’hammer’);
INSERT INTO POWERS VALUES (10008,’strength’);
INSERT INTO POWERS VALUES (10008,’durablity’);
INSERT INTO POWERS VALUES (10007,’strength’);
INSERT INTO POWERS VALUES (10007,’durablity’);
INSERT INTO POWERS VALUES (10007,’intelligence’);
INSERT INTO POWERS VALUES (10009,’strength’);
INSERT INTO POWERS VALUES (10009,’durablity’);
INSERT INTO POWERS VALUES (10010,’ninja_skills’);
INSERT INTO POWERS VALUES (10011,’strength’);
INSERT INTO POWERS VALUES (10011,’durablity’);
INSERT INTO POWERS VALUES (10012,’intelligence’);
INSERT INTO WEAKNESS VALUES (10001,’kryptonite’);
INSERT INTO WEAKNESS VALUES (10002,’lack_of_water’);
INSERT INTO WEAKNESS VALUES (10003,’no_super_powers’);
INSERT INTO WEAKNESS VALUES (10004,’accelerated_metabolism’);
INSERT INTO WEAKNESS VALUES (10005,’compassion’);
INSERT INTO WEAKNESS VALUES (10006,’Asgardian_magic’);
INSERT INTO WEAKNESS VALUES (10007,’no_super_powers’);
INSERT INTO WEAKNESS VALUES (10008,’lack_of_control’);
INSERT INTO WEAKNESS VALUES (10009,’no_super_powers’);
INSERT INTO WEAKNESS VALUES (10010,’no_super_powers’);
INSERT INTO WEAKNESS VALUES (10011,’not_smart’);
INSERT INTO WEAKNESS VALUES (10012,’no_super_powers’);
INSERT INTO WEAKNESS VALUES (10014, ‘sugary_snacks’);
INSERT INTO PROJECT VALUES (713,10008,’04-Mar-00′,13,’Despero’,189311);
INSERT INTO PROJECT VALUES (714,10007,’04-Sep-00′,11,’Doomsday’,287022);
INSERT INTO PROJECT VALUES (715,10009,’05-Nov-04′,6,’The_Adversary’,14428);
INSERT INTO PROJECT VALUES (716,10003,’24-Jun-05′,41,’Two-Face’,122507);
INSERT INTO PROJECT VALUES (717,10005,’24-Aug-05′,15,’Cassandra_Nova’,29172);
INSERT INTO PROJECT VALUES (718,10004,’31-Dec-05′,63,’Mysterio’,45874);
INSERT INTO PROJECT VALUES (719,10012,’27-Jan-06′,5,’Mongul’,2826);
INSERT INTO PROJECT VALUES (720,10005,’29-Apr-06′,48,’Mystique’,0);
INSERT INTO PROJECT VALUES (721,10005,’18-Jun-06′,15,’Herr_Starr’,20545);
INSERT INTO PROJECT VALUES (722,10009,’19-Nov-06′,14,’Kraven’,76415);
INSERT INTO PROJECT VALUES (723,10002,’03-Jan-07′,22,’Despero’,22081);
INSERT INTO PROJECT VALUES (724,10010,’12-Jan-07′,73,’Bane’,67723);
INSERT INTO PROJECT VALUES (725,10007,’10-Mar-07′,5,’Apocalypse’,21249);
INSERT INTO PROJECT VALUES (726,10012,’03-Jun-07′,21,’The_Shade’,23886);
INSERT INTO PROJECT VALUES (727,10006,’18-Jun-07′,13,’Cyborg_Superman’,213075);
INSERT INTO PROJECT VALUES (728,10008,’20-Sep-07′,5,’The_Penguin’,71139);
INSERT INTO PROJECT VALUES (729,10006,’04-Oct-07′,22,’Loki’,278241);
INSERT INTO PROJECT VALUES (730,10011,’30-Oct-07′,5,’Cassandra_Nova’,15071);
INSERT INTO PROJECT VALUES (731,10008,’13-Dec-07′,13,’Carnage’,4417);
INSERT INTO PROJECT VALUES (732,10007,’06-Feb-08′,5,’Bullseye’,64358);
INSERT INTO PROJECT VALUES (733,10006,’29-Apr-08′,4,’Bullseye’,101383);
INSERT INTO PROJECT VALUES (734,10007,’29-May-08′,4,’Mysterio’,113266);
INSERT INTO PROJECT VALUES (735,10005,’13-Jul-08′,8,’Sebastian_Shaw’,16402);
INSERT INTO PROJECT VALUES (736,10008,’18-Aug-08′,4,’Sinister’,148273);
INSERT INTO PROJECT VALUES (737,10011,’01-Nov-08′,1,’Vandal_Savage’,255399);
INSERT INTO PROJECT VALUES (738,10010,’01-Nov-08′,18,’Brainiac’,9121);
INSERT INTO PROJECT VALUES (739,10004,’06-Jan-09′,3,’Rasputin’,72504);
INSERT INTO PROJECT VALUES (740,10002,’03-Feb-09′,18,’Thanos’,94892);
INSERT INTO PROJECT VALUES (741,10007,’14-Feb-09′,4,’Mongul’,56588);
INSERT INTO PROJECT VALUES (742,10001,’02-Mar-09′,12,’Mephisto’,100046);
INSERT INTO PROJECT VALUES (743,10009,’10-Mar-09′,4,’Shredder’,65412);
INSERT INTO PROJECT VALUES (744,10009,’15-Apr-09′,41,’Despero’,124567);
INSERT INTO PROJECT VALUES (745,10005,’21-May-09′,26,’Doctor_Light’,398208);
INSERT INTO PROJECT VALUES (746,10002,’27-Jun-09′,9,’Kang_The_Conqueror’,42815);
INSERT INTO PROJECT VALUES (747,10002,’08-Jul-09′,4,’Annihilus’,25280);
INSERT INTO PROJECT VALUES (748,10004,’16-Jul-09′,36,’Kingpin’,175394);
INSERT INTO PROJECT VALUES (749,10001,’28-Jul-09′,9,’The_Saint_of_Killers’,69996);
INSERT INTO PROJECT VALUES (750,10011,’06-Aug-09′,3,’Bizzaro’,62179);
INSERT INTO PROJECT VALUES (751,10010,’20-Sep-09′,36,’Galactus’,25498);
INSERT INTO PROJECT VALUES (752,10003,’12-Oct-09′,21,’Poison_Ivy’,256481);
INSERT INTO PROJECT VALUES (753,10002,’15-Nov-09′,27,’Lucifer_Morningstar’,116930);
INSERT INTO PROJECT VALUES (754,10008,’26-Nov-09′,17,’Kid_Miracleman’,105692);
INSERT INTO PROJECT VALUES (755,10005,’07-Dec-09′,54,’Abomination’,3842);
INSERT INTO PROJECT VALUES (756,10001,’08-Dec-09′,7,’Sandman’,54127);
INSERT INTO PROJECT VALUES (757,10007,’04-Mar-10′,36,’Cheetah’,21027);
INSERT INTO PROJECT VALUES (758,10001,’27-Apr-10′,31,’Lex_Luthor’,46724);
INSERT INTO PROJECT VALUES (759,10007,’22-May-10′,1,’Darkseid’,83445);
INSERT INTO PROJECT VALUES (760,10003,’27-Jul-10′,10,’Mr._Freeze’,98896);
INSERT INTO PROJECT VALUES (761,10002,’10-Aug-10′,27,’Parasite’,150419);
INSERT INTO PROJECT VALUES (762,10008,’13-Aug-10′,37,’Kingpin’,69163);
INSERT INTO PROJECT VALUES (763,10004,’11-Sep-10′,31,’Annihilus’,56431);
INSERT INTO PROJECT VALUES (764,10008,’22-Sep-10′,44,’Lady_Deathstrike’,14014);
INSERT INTO PROJECT VALUES (765,10006,’20-Oct-10′,23,’The_Governor’,15880);
INSERT INTO PROJECT VALUES (766,10008,’12-Nov-10′,1,’Red_Skull’,4154);
INSERT INTO PROJECT VALUES (767,10011,’26-Nov-10′,9,’Clayface’,22093);
INSERT INTO PROJECT VALUES (768,10006,’25-Dec-10′,15,’The_Shade’,186116);
INSERT INTO PROJECT VALUES (769,10005,’02-Jan-11′,29,’Mandarin’,79824);
INSERT INTO PROJECT VALUES (770,10007,’18-Jan-11′,44,’Dormammu’,56035);
INSERT INTO PROJECT VALUES (771,10010,’28-Jan-11′,78,’Fin_Fang_Foom’,1020);
INSERT INTO PROJECT VALUES (772,10003,’31-Jan-11′,5,’Ras_Al_Ghul’,25856);
INSERT INTO PROJECT VALUES (773,10001,’10-Feb-11′,51,’Annihilus’,23704);
INSERT INTO PROJECT VALUES (774,10006,’17-Feb-11′,13,’Loki’,121862);
INSERT INTO PROJECT VALUES (775,10012,’19-Feb-11′,16,’Bane’,78132);
INSERT INTO PROJECT VALUES (776,10001,’20-Feb-11′,7,’General_Zod’,42699);
INSERT INTO PROJECT VALUES (777,10007,’21-Feb-11′,81,’Carnage’,1067);
INSERT INTO PROJECT VALUES (778,10006,’08-Mar-11′,47,’Norman_Osborn’,73800);
INSERT INTO PROJECT VALUES (779,10011,’11-Mar-11′,46,’Doctor_Light’,137130);
INSERT INTO PROJECT VALUES (780,10006,’02-Apr-11′,3,’Loki’,140317);
INSERT INTO PROJECT VALUES (781,10010,’27-Apr-11′,3,’Clayface’,139443);
INSERT INTO PROJECT VALUES (782,10003,’08-May-11′,25,’The_Penguin’,982);
INSERT INTO PROJECT VALUES (783,10002,’16-Jun-11′,13,’Baron_Zemo_II’,80767);
INSERT INTO PROJECT VALUES (784,10001,’15-Jul-11′,38,’Professor_Zoom’,38031);
INSERT INTO PROJECT VALUES (785,10009,’26-Aug-11′,17,’Sentinels’,9300);
INSERT INTO PROJECT VALUES (786,10003,’12-Sep-11′,21,’The_Joker’,105979);
INSERT INTO PROJECT VALUES (787,10002,’17-Sep-11′,25,’Dark_Phoenix’,33800);
INSERT INTO PROJECT VALUES (788,10004,’04-Oct-11′,32,’The_Lizard’,3775);
INSERT INTO PROJECT VALUES (789,10012,’13-Oct-11′,7,’Doomsday’,44711);
INSERT INTO PROJECT VALUES (790,10004,’18-Oct-11′,3,’Ultron’,1192);
INSERT INTO PROJECT VALUES (791,10008,’02-Nov-11′,37,’Omni-Man’,389683);
INSERT INTO PROJECT VALUES (792,10001,’19-Nov-11′,15,’Doctor_Octopus’,247501);
INSERT INTO PROJECT VALUES (793,10012,’26-Nov-11′,102,’Grendel’,2585);
INSERT INTO PROJECT VALUES (794,10005,’27-Nov-11′,6,’Kid_Miracleman’,9417);
INSERT INTO PROJECT VALUES (795,10003,’09-Dec-11′,19,’Talia_Al_Ghul’,15923);
INSERT INTO PROJECT VALUES (796,10008,’13-Dec-11′,31,’Lucifer_Morningstar’,115598);
INSERT INTO PROJECT VALUES (797,10009,’01-Jan-12′,40,’Sinister’,70963);
INSERT INTO PROJECT VALUES (798,10012,’25-Jan-12′,4,’Cheetah’,2055);
INSERT INTO PROJECT VALUES (799,10006,’27-Feb-12′,14,’Baron_Zemo_II’,112714);
INSERT INTO PROJECT VALUES (800,10007,’23-Mar-12′,46,’Magog’,182062);
INSERT INTO PROJECT VALUES (801,10007,’25-Mar-12′,1,’Proteus’,117369);
INSERT INTO PROJECT VALUES (802,10003,’27-Mar-12′,7,’The_Joker’,45262);
INSERT INTO PROJECT VALUES (803,10011,’27-Mar-12′,12,’Zoom’,38783);
INSERT INTO PROJECT VALUES (804,10003,’29-Mar-12′,70,’The_Joker’,52713);
INSERT INTO PROJECT VALUES (805,10005,’04-Apr-12′,10,’Mandarin’,381947);
INSERT INTO PROJECT VALUES (806,10004,’07-Apr-12′,31,’The_Riddler’,102151);
INSERT INTO PROJECT VALUES (807,10002,’08-Apr-12′,39,’Kid_Miracleman’,86634);
INSERT INTO PROJECT VALUES (808,10011,’11-Apr-12′,4,’Cheetah’,455);
INSERT INTO PROJECT VALUES (809,10007,’21-Apr-12′,31,’Cassandra_Nova’,73601);
INSERT INTO PROJECT VALUES (810,10002,’27-Apr-12′,18,’Harley_Quinn’,78827);
INSERT INTO PROJECT VALUES (811,10011,’11-May-12′,27,’Lady_Deathstrike’,222071);
INSERT INTO PROJECT VALUES (812,10008,’12-May-12′,21,’Juggernaut’,175095);
INSERT INTO PROJECT VALUES (813,10004,’13-May-12′,1,’Gorilla_Grodd’,47849);
INSERT INTO PROJECT VALUES (814,10010,’14-May-12′,46,’Parallax’,108591);
INSERT INTO PROJECT VALUES (815,10001,’22-May-12′,4,’Bullseye’,27259);
INSERT INTO PROJECT VALUES (816,10011,’02-Jun-12′,3,’Doomsday’,28894);
INSERT INTO PROJECT VALUES (817,10003,’09-Jun-12′,7,’Doctor_Octopus’,208022);
INSERT INTO PROJECT VALUES (818,10012,’16-Jun-12′,17,’Sabretooth’,177613);
INSERT INTO PROJECT VALUES (819,10006,’27-Jun-12′,30,’Scarecrow’,101779);
INSERT INTO PROJECT VALUES (820,10010,’02-Jul-12′,10,’Venom’,26100);
INSERT INTO PROJECT VALUES (821,10003,’23-Jul-12′,2,’Talia_Al_Ghul’,297933);
INSERT INTO PROJECT VALUES (822,10002,’27-Jul-12′,20,’Omega_Red’,81038);
INSERT INTO PROJECT VALUES (823,10001,’04-Aug-12′,0,’Venom’,241063);
INSERT INTO PROJECT VALUES (824,10009,’19-Aug-12′,59,’Hobgoblin’,43425);
INSERT INTO PROJECT VALUES (825,10001,’25-Aug-12′,8,’The_Lizard’,38725);
INSERT INTO PROJECT VALUES (826,10010,’08-Oct-12′,17,’Doctor_Octopus’,29424);
INSERT INTO PROJECT VALUES (827,10002,’05-Nov-12′,10,’Apocalypse’,93004);
INSERT INTO PROJECT VALUES (828,10012,’20-Nov-12′,15,’Prometheus’,7287);
INSERT INTO PROJECT VALUES (829,10006,’23-Nov-12′,6,’Kingpin’,27277);
INSERT INTO PROJECT VALUES (830,10005,’05-Dec-12′,18,’The_Adversary’,14728);
INSERT INTO PROJECT VALUES (831,10001,’08-Dec-12′,13,’Thanos’,42);
INSERT INTO PROJECT VALUES (832,10003,’10-Dec-12′,8,’Ras_Al_Ghul’,37156);
INSERT INTO PROJECT VALUES (833,10007,’15-Dec-12′,20,’Sentinels’,0);
INSERT INTO PROJECT VALUES (834,10005,’19-Dec-12′,10,’Sandman’,157447);
INSERT INTO PROJECT VALUES (835,10008,’23-Dec-12′,36,’The_Shade’,86221);
INSERT INTO PROJECT VALUES (836,10001,’27-Dec-12′,23,’The_Governor’,17219);
INSERT INTO PROJECT VALUES (837,10011,’02-Jan-13′,33,’Black_Adam’,102067);
INSERT INTO PROJECT VALUES (838,10011,’17-Jan-13′,19,’Mongul’,84130);
INSERT INTO PROJECT VALUES (839,10010,’26-Jan-13′,0,’Magneto’,216862);
INSERT INTO PROJECT VALUES (840,10011,’06-Feb-13′,27,’Mephisto’,29319);
INSERT INTO PROJECT VALUES (841,10003,’07-Feb-13′,12,’Two-Face’,0);
INSERT INTO PROJECT VALUES (842,10012,’08-Feb-13′,60,’Clayface’,39409);
INSERT INTO PROJECT VALUES (843,10006,’14-Feb-13′,98,’Violator’,68785);
INSERT INTO PROJECT VALUES (844,10008,’15-Feb-13′,85,’Ozymandias’,93185);
INSERT INTO PROJECT VALUES (845,10003,’20-Feb-13′,22,’The_Joker’,0);
INSERT INTO PROJECT VALUES (846,10003,’22-Feb-13′,3,’The_Riddler’,60207);
INSERT INTO PROJECT VALUES (847,10008,’24-Feb-13′,3,’Dormammu’,351177);
INSERT INTO PROJECT VALUES (848,10001,’27-Feb-13′,12,’Electro’,10668);
INSERT INTO PROJECT VALUES (849,10009,’01-Mar-13′,59,’Mephisto’,8237);
INSERT INTO PROJECT VALUES (850,10004,’06-Mar-13′,2,’M.O.D.O.K.’,28832);
INSERT INTO PROJECT VALUES (851,10010,’12-Mar-13′,31,’The_Anti-Monitor’,82826);
INSERT INTO PROJECT VALUES (852,10008,’21-Mar-13′,20,’Lucifer_Morningstar’,102896);
INSERT INTO PROJECT VALUES (853,10006,’02-Apr-13′,3,’The_Leader’,771);
INSERT INTO PROJECT VALUES (854,10006,’04-Apr-13′,21,’The_Governor’,10281);
INSERT INTO PROJECT VALUES (855,10003,’07-Apr-13′,20,’Mr._Freeze’,172722);
INSERT INTO PROJECT VALUES (856,10012,’09-Apr-13′,27,’Captain_Cold’,102795);
INSERT INTO PROJECT VALUES (857,10001,’13-Apr-13′,17,’Captain_Cold’,410519);
INSERT INTO PROJECT VALUES (858,10004,’22-Apr-13′,50,’The_Penguin’,107496);
INSERT INTO PROJECT VALUES (859,10004,’03-May-13′,18,’Amanda_Waller’,40253);
INSERT INTO PROJECT VALUES (860,10003,’08-May-13′,2,’Catwoman’,3751);
INSERT INTO PROJECT VALUES (861,10009,’08-May-13′,43,’Electro’,185078);
INSERT INTO PROJECT VALUES (862,10009,’09-May-13′,62,’Galactus’,251362);
INSERT INTO PROJECT VALUES (863,10007,’13-May-13′,65,’Mister_Mxyzptlk’,241779);
INSERT INTO PROJECT VALUES (864,10002,’14-May-13′,25,’Mastermind’,139810);
INSERT INTO PROJECT VALUES (865,10002,’27-May-13′,17,’Sabretooth’,31162);
INSERT INTO PROJECT VALUES (866,10010,’11-Jun-13′,8,’Captain_Cold’,233402);
INSERT INTO PROJECT VALUES (867,10010,’15-Jun-13′,40,’Harley_Quinn’,214938);
INSERT INTO PROJECT VALUES (868,10004,’20-Jun-13′,10,’The_Riddler’,19649);
INSERT INTO PROJECT VALUES (869,10007,’23-Jun-13′,12,’Mandarin’,17452);
INSERT INTO PROJECT VALUES (870,10001,’23-Jun-13′,21,’Darkseid’,260797);
INSERT INTO PROJECT VALUES (871,10012,’24-Jun-13′,18,’Sinetsro’,191363);
INSERT INTO PROJECT VALUES (872,10005,’07-Jul-13′,4,’Metallo’,166662);
INSERT INTO PROJECT VALUES (873,10012,’10-Jul-13′,52,’Dark_Phoenix’,17178);
INSERT INTO PROJECT VALUES (874,10011,’12-Jul-13′,23,’Mirror_Master’,418181);
INSERT INTO PROJECT VALUES (875,10003,’19-Jul-13′,34,’Catwoman’,0);
INSERT INTO PROJECT VALUES (876,10004,’25-Jul-13′,2,’Venom’,102657);
INSERT INTO PROJECT VALUES (877,10010,’27-Jul-13′,7,’Kang_The_Conqueror’,23169);
INSERT INTO PROJECT VALUES (878,10006,’29-Jul-13′,2,’Doctor_Sivana’,40038);
INSERT INTO PROJECT VALUES (879,10011,’30-Jul-13′,101,’Apocalypse’,15927);
INSERT INTO PROJECT VALUES (880,10009,’04-Aug-13′,19,’Norman_Osborn’,209251);
INSERT INTO PROJECT VALUES (881,10003,’06-Aug-13′,1,’Poison_Ivy’,151472);
INSERT INTO PROJECT VALUES (882,10005,’06-Aug-13′,33,’The_Leader’,72448);
INSERT INTO PROJECT VALUES (883,10004,’06-Aug-13′,8,’Catwoman’,159156);
INSERT INTO PROJECT VALUES (884,10011,’14-Aug-13′,8,’Magneto’,117787);
INSERT INTO PROJECT VALUES (885,10005,’15-Aug-13′,15,’Omega_Red’,90941);
INSERT INTO PROJECT VALUES (886,10006,’16-Aug-13′,36,’Harley_Quinn’,68566);
INSERT INTO PROJECT VALUES (887,10003,’27-Aug-13′,11,’Ras_Al_Ghul’,129768);
INSERT INTO PROJECT VALUES (888,10001,’29-Aug-13′,17,’Lex_Luthor’,11060);
INSERT INTO PROJECT VALUES (889,10003,’03-Sep-13′,4,’Poison_Ivy’,236819);
INSERT INTO PROJECT VALUES (890,10005,’06-Sep-13′,0,’Mirror_Master’,131471);
INSERT INTO PROJECT VALUES (891,10009,’16-Sep-13′,22,’Magneto’,170123);
INSERT INTO PROJECT VALUES (892,10009,’29-Sep-13′,70,’The_Lizard’,449043);
INSERT INTO PROJECT VALUES (893,10004,’07-Oct-13′,8,’Proteus’,37011);
INSERT INTO PROJECT VALUES (894,10002,’11-Oct-13′,7,’Galactus’,21536);
INSERT INTO PROJECT VALUES (895,10008,’16-Oct-13′,22,’Deadshot’,53715);
INSERT INTO PROJECT VALUES (896,10009,’18-Oct-13′,11,’Shredder’,91238);
INSERT INTO PROJECT VALUES (897,10012,’20-Oct-13′,31,’Fin_Fang_Foom’,5898);
INSERT INTO PROJECT VALUES (898,10006,’25-Oct-13′,61,’Baron_Zemo_II’,310613);
INSERT INTO PROJECT VALUES (899,10003,’25-Oct-13′,115,’Talia_Al_Ghul’,27658);
INSERT INTO PROJECT VALUES (900,10001,’25-Oct-13′,23,’Omni-Man’,17611);
INSERT INTO PROJECT VALUES (901,10010,’01-Nov-13′,24,’Sabretooth’,36128);
INSERT INTO PROJECT VALUES (902,10004,’11-Nov-13′,58,’Lady_Deathstrike’,105390);
INSERT INTO PROJECT VALUES (903,10010,’14-Nov-13′,67,’Mysterio’,92422);
INSERT INTO PROJECT VALUES (904,10001,’18-Nov-13′,41,’Deathstroke’,18732);
INSERT INTO PROJECT VALUES (905,10006,’24-Nov-13′,60,’Shredder’,84808);
INSERT INTO PROJECT VALUES (906,10006,’25-Nov-13′,16,’William_Stryker’,0);
INSERT INTO PROJECT VALUES (907,10012,’06-Dec-13′,0,’Thanos’,87707);
INSERT INTO PROJECT VALUES (908,10012,’10-Dec-13′,22,’General_Ross’,12033);
INSERT INTO PROJECT VALUES (909,10005,’15-Dec-13′,4,’Kraven’,267951);
INSERT INTO PROJECT VALUES (910,10007,’15-Dec-13′,7,’Gorilla_Grodd’,14378);
INSERT INTO PROJECT VALUES (911,10009,’22-Dec-13′,33,’Sandman’,56481);
INSERT INTO PROJECT VALUES (912,10002,’06-Jan-14′,4,’Doctor_Doom’,404527);
INSERT INTO DEPARTMENT VALUES (‘Justic_League’,’Aquaman’,’Secret_cave’,1);
INSERT INTO DEPARTMENT VALUES (‘Advengers’,’Director_Fury’,’Flying_air_ship’,2);
INSERT INTO DEPARTMENT VALUES (‘Independent’,’none’,’Arthurs_apartment’,3);
