MovieInfo (mvID, title, rating, year, length, studio)
Director(directorID, firstname, lastname)
Member(username, email, password)
Actor(actorID, firstname, lastname, gender, birthplace)
Cast(mvID*, actorID*)
Direct(mvID*, directorID*)
Genre(mvID*, genre)
Ranking(username*, mvID*, score, voteDate)

1.计算PG movie的电影平均长度从studio，写出PG电影平均长度studio，in decreasing order of the average PG movie
length.

2.找出电影有同样数量的导演和演员， 写出这些mvID

3.考虑所以投票记录，12个月里哪个月得到最多的投票，写出这些月份和投票的数量
提示（Hint: the Oracle to_char() function can return the month for a given date.
For example, to_char(sysdate, 'MON') will return APR, assuming the current date is
12/04/2010.）

4.列出username从member只投票给了drama movie,必须用set operator MINUS
（是SQL的资料）


[ 本帖最后由 jackyshen 于 2010-5-17 17:45 编辑 ]

我第1，4都做完了，只有2和3不会。哪位高手会？

这是演员的表
insert into actor values (1,'Abigail','Breslin','F','US');
insert into actor values (2,'Adam','Baldwin','M','US');
insert into actor values (3,'Ade','','M','UK');
insert into actor values (4,'Adrien','Brody','M','US');
insert into actor values (5,'Akira','Terao','m','Japan');
insert into actor values (6,'Al','Pacino','M','US');
insert into actor values (7,'Alan','Howard','M','UK');
insert into actor values (8,'Albert','Brooks','M','US');
insert into actor values (9,'Albert','Finney','M','UK');
insert into actor values (10,'Alec','Guinness','M','UK');
insert into actor values (11,'Alexandra','Astin','F','US');
insert into actor values (12,'Alexandra','Lara','F','Romania');
insert into actor values (13,'Alexandre','Rodrigues','M','Brazil');
insert into actor values (14,'Alfred','Abel','M','Germany');
insert into actor values (15,'Andie','MacDowell','F','US');
insert into actor values (16,'Angelina','Jolie','F','US');
insert into actor values (17,'Anita','Ekberg','F','Sweden');
insert into actor values (18,'Anne','Bancroft','F','US');
insert into actor values (19,'Anne','Baxter','F','US');
insert into actor values (20,'Annette','Bening','F','US');
insert into actor values (21,'Anthony','Hopkins','M','UK');
insert into actor values (22,'Anthony','Perkins','M','US');
insert into actor values (23,'Anthony','Quinn','M','Mexico');
insert into actor values (24,'Antonella','Attili','F','Italy');
insert into actor values (25,'Arnold','Schwarzenegger','M','Austria');
insert into actor values (26,'Audrey','Hepburn','F','Belgium');
insert into actor values (27,'Audrey','Tautou','F','France');
insert into actor values (28,'Ayano','Shiraishi','F','Japan');
insert into actor values (29,'Barbara','O''Neil','F','US');
insert into actor values (30,'Barbara','Stanwyck','F','US');
insert into actor values (31,'Ben','Burtt','M','US');
insert into actor values (32,'Ben','Kingsley','M','UK');
insert into actor values (33,'Bengt','Ekerot','M','Sweden');
insert into actor values (34,'Bette','Davis','F','US');
insert into actor values (35,'Bibi','Andersson','M','Sweden');
insert into actor values (36,'Bill','Murray','M','US');
insert into actor values (37,'Bonnie','Bedelia','F','US');
insert into actor values (38,'Brad','Pitt','M','US');
insert into actor values (39,'Bradley','Cooper','m','US');
insert into actor values (40,'Brahim','Hadjadj','M','Saudi Arabia');
insert into actor values (41,'Brendan','Gleeson','M','Ireland');
insert into actor values (42,'Bruce','Allpress','M','New Zealand');
insert into actor values (43,'Bruce','Willis','M','Germany');
insert into actor values (44,'Bruno','Ganz','M','Switzerland');
insert into actor values (45,'Bud','Cort','M','US');
insert into actor values (46,'Burt','Lancaster','M','US');
insert into actor values (47,'Candice','Bergen','F','US');
insert into actor values (48,'Carl','Miller','M','US');
insert into actor values (49,'Carlo','Battisti','M','Italy');
insert into actor values (50,'Carole','Lombard','F','US');
insert into actor values (51,'Carrie','Henn','F','US');
insert into actor values (52,'Carrie-Anne','Moss','F','Canada');
insert into actor values (53,'Cary','Elwes','M','UK');
insert into actor values (54,'Cary','Grant','M','UK');
insert into actor values (55,'Cate','Blanchett','F','Australia');
insert into actor values (56,'Cathy','Moriarty','F','US');
insert into actor values (57,'Celia','Johnson','F','UK');
insert into actor values (58,'Charles','Chaplin','M','UK');
insert into actor values (59,'Charles','Vanel','M','France');
insert into actor values (60,'Charlton','Heston','M','US');
insert into actor values (61,'Chris','Pine','M','US');
insert into actor values (62,'Christian','Bale','M','UK');
insert into actor values (63,'Christopher','Carley','M','US');
insert into actor values (64,'Christopher','Lloyd','M','US');
insert into actor values (65,'Christopher','Plummer','M','Canada');
insert into actor values (66,'Clark','Gable','M','US');
insert into actor values (67,'Claudette','Colbert','F','France');
insert into actor values (68,'Claudia','Cardinale','F','Tunisia');
insert into actor values (69,'Clint','Eastwood','M','US');
insert into actor values (70,'Coleen','Gray','F','US');
insert into actor values (71,'Colin','Clive','M','France');
insert into actor values (72,'Colin','Farrell','M','Ireland');
insert into actor values (73,'Craig','Nelson','M','US');
insert into actor values (74,'Dana','Andrews','M','US');
insert into actor values (75,'Daniel','Day-Lewis','M','UK');
insert into actor values (76,'Dato','Bakhtadze','M','Georgia');
insert into actor values (77,'David','Carradine','M','US');
insert into actor values (78,'David','Morse','M','US');
insert into actor values (79,'Dennis','Price','M','UK');
insert into actor values (80,'Denzel','Washington','M','US');
insert into actor values (81,'Dev','Patel','M','UK');
insert into actor values (82,'Devon','Aoki','F','US');
insert into actor values (83,'Dexter','Fletcher','M','UK');
insert into actor values (84,'Diane','Keaton','F','US');
insert into actor values (85,'Don','Cheadle','M','US');
insert into actor values (86,'Don','Taylor','F','US');
insert into actor values (87,'Donald','O''Connor','M','US');
insert into actor values (88,'Donna','Reed','F','US');
insert into actor values (89,'Dorothy','Comingore','F','US');
insert into actor values (90,'Dustin','Hoffman','M','US');
insert into actor values (91,'Ed','Helms','M','US');
insert into actor values (92,'Edna','Purviance','F','US');
insert into actor values (93,'Edward','Asner','M','US');
insert into actor values (94,'Edward','Furlong','M','US');
insert into actor values (95,'Edward','Norton','M','US');
insert into actor values (96,'Eli','Wallach','M','US');
insert into actor values (97,'Elissa','Knight','F','US');
insert into actor values (98,'Elizabeth','Taylor','F','UK');
insert into actor values (99,'Ellen','Burstyn','F','US');
insert into actor values (100,'Ellen','DeGeneres','F','US');
insert into actor values (101,'Ellen','Widmann','F','Switzerland');
insert into actor values (102,'Emile','Hirsch','M','US');
insert into actor values (103,'Emilio','Echevarria','M','Mexico');
insert into actor values (104,'Emmanuelle','Seigner','F','France');
insert into actor values (105,'Enzo','Cannavale','M','Italy');
insert into actor values (106,'Enzo','Staiola','M','Italy');
insert into actor values (107,'Ernest','Borgnine','M','US');
insert into actor values (108,'Errol','Flynn','M','Australia');
insert into actor values (109,'Eva','Saint','F','US');
insert into actor values (110,'Ewan','McGregor','M','UK');
insert into actor values (111,'Ewen','Bremner','M','Scotland');
insert into actor values (112,'F.','Abraham','M','US');
insert into actor values (113,'Farley','Crowe','M','US');
insert into actor values (114,'Fay','Wray','F','Canada');
insert into actor values (115,'Faye','Dunaway','F','US');
insert into actor values (116,'Florence','Lee','F','US');
insert into actor values (117,'Forest','Whitaker','M','US');
insert into actor values (118,'Francois','Perier','M','France');
insert into actor values (119,'Frank','Morgan','M','US');
insert into actor values (120,'Frank','Sinatra','M','US');
insert into actor values (121,'Fred','MacMurray','M','US');
insert into actor values (122,'Fredric','March','M','US');
insert into actor values (123,'Gabriel','Byrne','M','Ireland');
insert into actor values (124,'Gael','Bernal','M','Mexico');
insert into actor values (125,'Gary','Cooper','M','US');
insert into actor values (126,'Gary','Lockwood','M','US');
insert into actor values (127,'Gary','Oldman','M','UK');
insert into actor values (128,'Gattlin','Griffith','M','US');
insert into actor values (129,'Gene','Hackman','M','US');
insert into actor values (130,'Gene','Kelly','M','US');
insert into actor values (131,'Gene','Tierney','F','US');
insert into actor values (132,'George','Scott','M','US');
insert into actor values (133,'George','Kennedy','M','US');
insert into actor values (134,'George','O''Brien','M','US');
insert into actor values (135,'Giulietta','Masina','F','Italy');
insert into actor values (136,'Glen','Cavender','M','US');
insert into actor values (137,'Gloria','Swanson','F','US');
insert into actor values (138,'Grace','Kelly','F','US');
insert into actor values (139,'Graham','Chapman','M','UK');
insert into actor values (140,'Greg','Kinnear','M','US');
insert into actor values (141,'Gregory','Peck','M','US');
insert into actor values (142,'Groucho','Marx','M','US');
insert into actor values (143,'Gunnar','Bjornstrand','M','Sweden');
insert into actor values (144,'Gustav','Frohlich','M','Switzerland');
insert into actor values (145,'Gustav','Wangenheim','M','Germany');
insert into actor values (146,'Guy','Pearce','M','UK');
insert into actor values (147,'Haley','Osment','M','US');
insert into actor values (148,'Harold','Lloyd','M','US');
insert into actor values (149,'Harpo','Marx','M','US');
insert into actor values (150,'Harrison','Ford','M','US');
insert into actor values (151,'Harvey','Keitel','M','US');
insert into actor values (152,'Heath','Ledger','M','Australia');
insert into actor values (153,'Henry','Fonda','M','US');
insert into actor values (154,'Herbert','Gronemeyer','M','Germany');
insert into actor values (155,'Hilary','Swank','F','US');
insert into actor values (156,'Holly','Hunter','F','US');
insert into actor values (157,'Holmes','Osborne','M','US');
insert into actor values (158,'Hugh','Jackman','M','Australia');
insert into actor values (159,'Hugo','Weaving','M','Nigeria');
insert into actor values (160,'Humphrey','Bogart','M','US');
insert into actor values (161,'Ian','Holm','M','UK');
insert into actor values (162,'Ingrid','Bergman','F','Sweden');
insert into actor values (163,'Ivana','Baquero','F','Spain');
insert into actor values (164,'Jack','Hawkins','M','UK');
insert into actor values (165,'Jack','Lemmon','M','US');
insert into actor values (166,'Jack','Nicholson','M','US');
insert into actor values (167,'Jack','Oakie','M','US');
insert into actor values (168,'Jackie','Gleason','M','US');
insert into actor values (169,'Jake','Gyllenhaal','M','US');
insert into actor values (170,'James','Garner','M','US');
insert into actor values (171,'James','Robinson','M','UK');
insert into actor values (172,'James','Stewart','M','US');
insert into actor values (173,'James','Woods','M','US');
insert into actor values (174,'Jane','Darwell','F','US');
insert into actor values (175,'Jane','Wyman','F','US');
insert into actor values (176,'Janet','Gaynor','F','US');
insert into actor values (177,'Janet','Leigh','F','US');
insert into actor values (178,'Jared','Leto','M','US');
insert into actor values (179,'Jason','Flemyng','M','UK');
insert into actor values (180,'Javier','Bardem','M','Spain');
insert into actor values (181,'Jean','Arthur','F','US');
insert into actor values (182,'Jean','Martin','M','France');
insert into actor values (183,'Jean','Reno','M','Morocco');
insert into actor values (184,'Jeff','Bridges','M','US');
insert into actor values (185,'Jessica','Alba','F','US');
insert into actor values (186,'Jim','Carrey','M','Canada');
insert into actor values (187,'Ji-tae','Yu','M','Korea');
insert into actor values (188,'Joan','Fontaine','F','Japan');
insert into actor values (189,'Joaquin','Phoenix','M','Puerto Rico');
insert into actor values (190,'Jodie','Foster','F','US');
insert into actor values (191,'John','Cassavetes','M','US');
insert into actor values (192,'John','Cleese','M','UK');
insert into actor values (193,'John','Dall','M','US');
insert into actor values (194,'John','Fiedler','M','US');
insert into actor values (195,'John','Goodman','M','US');
insert into actor values (196,'John','Hurt','M','UK');
insert into actor values (197,'John','Megna','M','US');
insert into actor values (198,'John','Mills','M','UK');
insert into actor values (199,'John','Travolta','M','US');
insert into actor values (200,'Johnny','Depp','M','US');
insert into actor values (201,'Jonathan','Thomas','M','US');
insert into actor values (202,'Joseph','Cotten','M','US');
insert into actor values (203,'Alida','Valli','F','Italy');
insert into actor values (204,'Joseph','Melito','M','US');
insert into actor values (205,'Josephine','Hull','F','US');
insert into actor values (206,'Juan','Yacuzzi','M','Argentina');
insert into actor values (207,'Judy','Garland','F','US');
insert into actor values (208,'J¨¹rgen','Prochnow','M','Germany');
insert into actor values (209,'Julia','Ormond','F','UK');
insert into actor values (210,'Julia','Stiles','F','US');
insert into actor values (211,'Julianne','Moore','F','US');
insert into actor values (212,'Kare','Hedebrant','M','Sweden');
insert into actor values (213,'Karen','Allen','F','US');
insert into actor values (214,'Karina','Arroyave','F','Colombia');
insert into actor values (215,'Karl','Malden','M','US');
insert into actor values (216,'Kate','Winslet','F','UK');
insert into actor values (217,'Katharine','Hepburn','F','US');
insert into actor values (218,'Kazunari','Ninomiya','M','Japan');
insert into actor values (219,'Keanu','Reeves','M','Lebanon');
insert into actor values (220,'Keir','Dullea','F','US');
insert into actor values (221,'Keith','David','M','US');
insert into actor values (222,'Ken','Watanabe','M','Japan');
insert into actor values (223,'Kevin','Spacey','M','US');
insert into actor values (224,'Kim','Novak','F','US');
insert into actor values (225,'Kirk','Douglas','M','US');
insert into actor values (226,'Kurt','Russell','M','US');
insert into actor values (227,'Lamberto','Maggiorani','M','Italy');
insert into actor values (228,'Lauren','Bacall','F','US');
insert into actor values (229,'Laurence','Fishburne','M','US');
insert into actor values (230,'Laurence','Harvey','M','Lithuania');
insert into actor values (231,'Laurence','Olivier','M','UK');
insert into actor values (232,'Leandro','Firmino','M','Brazil');
insert into actor values (233,'Lee','Cleef','M','US');
insert into actor values (234,'Leonardo','DiCaprio','M','US');
insert into actor values (235,'Lew','Ayres','M','US');
insert into actor values (236,'Liam','Neeson','M','UK');
insert into actor values (237,'Lina','Leandersson','F','Sweden');
insert into actor values (238,'Linda','Hamilton','F','US');
insert into actor values (239,'Louis','Wolheim','M','US');
insert into actor values (240,'Lucy','Liu','F','US');
insert into actor values (241,'Machiko','Ky','F','Japan');
insert into actor values (242,'Mack','Swain','M','US');
insert into actor values (243,'Malcolm','McDowell','M','UK');
insert into actor values (244,'Mandy','Patinkin','M','US');
insert into actor values (245,'Marcello','Mastroianni','M','Italy');
insert into actor values (246,'Marcia','Harden','F','US');
insert into actor values (247,'Margaret','Lockwood','F','Pakistan');
insert into actor values (248,'Maria-Pia','Casilio','F','Italy');
insert into actor values (249,'Marilyn','Monroe','F','US');
insert into actor values (250,'Marion','Mack','F','US');
insert into actor values (251,'Marisa','Tomei','F','US');
insert into actor values (252,'Mark','Hamill','M','US');
insert into actor values (253,'Marlene','Dietrich','F','Germany');
insert into actor values (254,'Marlon','Brando','M','US');
insert into actor values (255,'Martin','Balsam','M','US');
insert into actor values (256,'Martin','Landau','M','US');
insert into actor values (257,'Martin','Sheen','M','US');
insert into actor values (258,'Martin','Stringer','M','US');
insert into actor values (259,'Martina','Gedeck','F','Germany');
insert into actor values (260,'Mary','Astor','M','US');
insert into actor values (261,'Mathieu','Amalric','M','France');
insert into actor values (262,'Mathieu','Kassovitz','M','France');
insert into actor values (263,'Matt','Damon','M','US');
insert into actor values (264,'Matthew','Broderick','M','US');
insert into actor values (265,'Matthew','Modine','M','US');
insert into actor values (266,'Max','Schreck','M','Germany');
insert into actor values (267,'Max','Sydow','M','Sweden');
insert into actor values (268,'Mel','Gibson','M','US');
insert into actor values (269,'Mia','Farrow','M','US');
insert into actor values (270,'Michael','Berryman','M','US');
insert into actor values (271,'Michael','Biehn','M','US');
insert into actor values (272,'Michael','Caine','M','UK');
insert into actor values (273,'Michael','Fox','M','Canada');
insert into actor values (274,'Michael','Redgrave','M','UK');
insert into actor values (275,'Michael','Rennie','M','UK');
insert into actor values (276,'Michelle','Yeoh','F','Malaysia');
insert into actor values (277,'Mickey','Rourke','M','US');
insert into actor values (278,'Mildred','Davis','F','US');
insert into actor values (279,'Min-sik','Choi','M','Korea');
insert into actor values (280,'Mishal','Husain','F','UK');
insert into actor values (281,'Miyu','Irino','M','Japan');
insert into actor values (282,'Morgan','Freeman','M','US');
insert into actor values (283,'Myrna','Loy','F','US');
insert into actor values (284,'Natalie','Portman','F','Israel');
insert into actor values (285,'Nicoletta','Braschi','F','Italy');
insert into actor values (286,'Noel','Appleby','M','US');
insert into actor values (287,'Olivia','Havilland','F','Japan');
insert into actor values (288,'Patricia','Neal','F','US');
insert into actor values (289,'Patrick','Magee','M','UK');
insert into actor values (290,'Patton','Oswalt','M','US');
insert into actor values (291,'Paul','Newman','M','US');
insert into actor values (292,'Paulette','Goddard','F','US');
insert into actor values (293,'Peter','Brocco','M','US');
insert into actor values (294,'Peter','Lorre','M','Slovakia');
insert into actor values (295,'Peter','O''Toole','M','Ireland');
insert into actor values (296,'Peter','Sellers','M','UK');
insert into actor values (297,'Priscilla','Lane','F','US');
insert into actor values (298,'Ralph','Meeker','M','US');
insert into actor values (299,'Ray','Liotta','M','US');
insert into actor values (300,'Ray','Milland','M','UK');
insert into actor values (301,'Richard','Burton','M','UK');
insert into actor values (302,'River','Phoenix','M','UK');
insert into actor values (303,'Robert','Armstrong','M','US');
insert into actor values (304,'Robert','Niro','M','US');
insert into actor values (305,'Robert','Duvall','M','US');
insert into actor values (306,'Robert','Mitchum','M','US');
insert into actor values (307,'Robert','Redford','M','US');
insert into actor values (308,'Robert','Shaw','M','UK');
insert into actor values (309,'Roberto','Benigni','M','Italy');
insert into actor values (310,'Robin','Williams','M','US');
insert into actor values (311,'Robin','Penn','F','US');
insert into actor values (312,'Rod','Steiger','M','US');
insert into actor values (313,'Roddy','McDowall','M','UK');
insert into actor values (314,'Rosalind','Russell','F','US');
insert into actor values (315,'Roy','Scheider','M','US');
insert into actor values (316,'Rumi','Hragi','F','Japan');
insert into actor values (317,'Russell','Crowe','M','New Zealand');
insert into actor values (318,'Rutger','Hauer','M','Netherlands');
insert into actor values (319,'Ruth','Gordon','F','US');
insert into actor values (320,'Ruth','Roman','F','US');
insert into actor values (321,'Samuel','Jackson','M','US');
insert into actor values (322,'Saurabh','Shukla','M','US');
insert into actor values (323,'Sean','Astin','M','US');
insert into actor values (324,'Sean','Connery','M','UK');
insert into actor values (325,'Sean','Penn','M','US');
insert into actor values (326,'Sergi','L¨®pez','M','Spain');
insert into actor values (327,'Sharon','Stone','F','US');
insert into actor values (328,'Shelley','Duvall','F','US');
insert into actor values (329,'Shelley','Winters','F','US');
insert into actor values (330,'Shirley','MacLaine','F','US');
insert into actor values (331,'Sidney','Poitier','F','US');
insert into actor values (332,'Sigourney','Weaver','F','US');
insert into actor values (333,'Simone','Signoret','F','Germany');
insert into actor values (334,'Spencer','Tracy','M','US');
insert into actor values (335,'Stephen','Baldwin','M','US');
insert into actor values (336,'Sterling','Hayden','M','US');
insert into actor values (337,'Steve','Buscemi','M','US');
insert into actor values (338,'Steve','McQueen','M','US');
insert into actor values (339,'Steven','Bauer','M','Cuba');
insert into actor values (340,'Sylvester','Stallone','M','US');
insert into actor values (341,'Takashi','Shimura','M','Japan');
insert into actor values (342,'Talia','Shire','F','US');
insert into actor values (343,'Tatsuya','Nakadai','M','Japan');
insert into actor values (344,'Teresa','Wright','F','US');
insert into actor values (345,'Thomas','Kretschmann','M','Germany');
insert into actor values (346,'Thomas','Mitchell','M','US');
insert into actor values (347,'Tim','Allen','M','US');
insert into actor values (348,'Tim','Robbins','M','US');
insert into actor values (349,'Tim','Roth','M','UK');
insert into actor values (350,'Tom','Hanks','M','US');
insert into actor values (351,'Tom','Hulce','M','US');
insert into actor values (352,'Tom','Sizemore','M','US');
insert into actor values (353,'Tom','Skerritt','M','US');
insert into actor values (354,'Tommy','Jones','M','US');
insert into actor values (355,'Tony','Curtis','M','US');
insert into actor values (356,'Tony','Wager','M','UK');
insert into actor values (357,'Toshir','Mifune','M','China');
insert into actor values (358,'Trevor','Howard','M','UK');
insert into actor values (359,'Tsutomu','Tatsumi','M','Japan');
insert into actor values (360,'Tyrone','Power','M','US');
insert into actor values (361,'Ulrich','Muhe','M','Germany');
insert into actor values (362,'Uma','Thurman','F','US');
insert into actor values (363,'Valerie','Hobson','F','UK');
insert into actor values (364,'Veera','Clouzot','F','Brazil');
insert into actor values (365,'Vera','Miles','F','US');
insert into actor values (366,'Victor','Sjostrom','M','Sweden');
insert into actor values (367,'Virginia','Cherrill','F','US');
insert into actor values (368,'Vivien','Leigh','F','India');
insert into actor values (369,'Walter','Huston','M','Canada');
insert into actor values (370,'Warren','Beatty','M','US');
insert into actor values (371,'Wil','Wheaton','M','US');
insert into actor values (372,'Wilford','Brimley','M','US');
insert into actor values (373,'William','Beck','M','UK');
insert into actor values (374,'William','Macy','M','US');
insert into actor values (375,'William','Holden','M','US');
insert into actor values (376,'William','Powell','M','US');
insert into actor values (377,'Woody','Allen','M','US');
insert into actor values (378,'Xolani','Mali','M','US');
insert into actor values (379,'Yji','Matsuda','M','Japan');
insert into actor values (380,'Yun-Fat','Chow','M','China');
insert into actor values (381,'Yuriko','Ishida','F','Japan');
insert into actor values (382,'Yves','Montand','M','Italy');
insert into actor values (383,'Zachary','Quinto','M','US');
insert into actor values (384,'John','Cazale','M','US');

这个是director
insert into director values(1,'Akira','Kurosawa');
insert into director values(2,'Alejandro','Inarritu');
insert into director values(3,'Alexander','Mackendrick');
insert into director values(4,'Alfonso','Cuar¨®n');
insert into director values(5,'Alfred','Hitchcock');
insert into director values(6,'Andrew','Stanton');
insert into director values(7,'Andy','Wachowski');
insert into director values(8,'Ang','Lee');
insert into director values(9,'Arthur','Penn');
insert into director values(10,'Billy','Wilder');
insert into director values(11,'Bob','Peterson');
insert into director values(12,'Brad','Bird');
insert into director values(13,'Brian','De Palma');
insert into director values(14,'Bryan','Singer');
insert into director values(15,'Buster','Keaton');
insert into director values(16,'Carol','Reed');
insert into director values(17,'Chan-wook','Park');
insert into director values(18,'Charles','Chaplin');
insert into director values(19,'Charles','Laughton');
insert into director values(20,'Christopher','Nolan');
insert into director values(21,'Clint','Eastwood');
insert into director values(22,'Clyde','Bruckman');
insert into director values(23,'Curtis','Hanson');
insert into director values(24,'Danny','Boyle');
insert into director values(25,'Darren','Aronofsky');
insert into director values(26,'David','Fincher');
insert into director values(27,'David','Lean');
insert into director values(28,'David','Lynch');
insert into director values(29,'derico','Fellini');
insert into director values(30,'Edward','Zwick');
insert into director values(31,'Elia','Kazan');
insert into director values(32,'Ethan','Coen');
insert into director values(33,'F.W.','Murnau');
insert into director values(34,'Federico','Fellini');
insert into director values(35,'Fernando','Meirelles');
insert into director values(36,'Florian','von Donnersmarck');
insert into director values(37,'Francis','Coppola');
insert into director values(38,'Frank','Capra');
insert into director values(39,'Frank','Darabont');
insert into director values(40,'Frank','Miller');
insert into director values(41,'Franklin','Schaffner');
insert into director values(42,'Fred','Newmeyer');
insert into director values(43,'Fred','Zinnemann');
insert into director values(44,'Fritz','Lang');
insert into director values(45,'Gene','Kelly');
insert into director values(46,'George','Cukor');
insert into director values(47,'George','Lucas');
insert into director values(48,'George','Hill');
insert into director values(49,'Gillo','Pontecorvo');
insert into director values(50,'Giuseppe','Tornatore');
insert into director values(51,'Gregory','La Cava');
insert into director values(52,'Guillermo','del Toro');
insert into director values(53,'Gus','Van Sant');
insert into director values(54,'Guy','Ritchie');
insert into director values(55,'Hal','Ashby');
insert into director values(56,'Harold','Ramis');
insert into director values(57,'Hayao','Miyazaki');
insert into director values(58,'Henri-Georges','Clouzot');
insert into director values(59,'Henry','Koster');
insert into director values(60,'Howard','Hawks');
insert into director values(61,'Ingmar','Bergman');
insert into director values(62,'Irvin','Kershner');
insert into director values(63,'Isao','Takahata');
insert into director values(64,'J.J.','Abrams');
insert into director values(65,'James','Cameron');
insert into director values(66,'James','McTeigue');
insert into director values(67,'James','Whale');
insert into director values(68,'Jan','Pinkava');
insert into director values(69,'Jean-Pierre','Jeunet');
insert into director values(70,'Joel','Coen');
insert into director values(71,'Mike','Leigh');
insert into director values(72,'John','Carpenter');
insert into director values(73,'John','Ford');
insert into director values(74,'John','Frankenheimer');
insert into director values(75,'John','Avildsen');
insert into director values(76,'John','Huston');
insert into director values(77,'John','Lasseter');
insert into director values(78,'John','McTiernan');
insert into director values(79,'John','Sturges');
insert into director values(80,'Jonathan','Dayton');
insert into director values(81,'Jonathan','Demme');
insert into director values(82,'Joseph','Mankiewicz');
insert into director values(83,'Julian','Schnabel');
insert into director values(84,'Katia','Lund');
insert into director values(85,'Larry','Wachowski');
insert into director values(86,'Lee','Unkrich');
insert into director values(87,'Leo','McCarey');
insert into director values(88,'Lewis','Milestone');
insert into director values(89,'Loveleen','Tandan');
insert into director values(90,'Luc','Besson');
insert into director values(91,'M.','Shyamalan');
insert into director values(92,'Martin','McDonagh');
insert into director values(93,'Martin','Scorsese');
insert into director values(94,'Mel','Gibson');
insert into director values(95,'Michael','Cimino');
insert into director values(96,'Michael','Curtiz');
insert into director values(97,'Michael','Mann');
insert into director values(98,'Michel','Gondry');
insert into director values(99,'Mike','Nichols');
insert into director values(100,'Milos','Forman');
insert into director values(101,'Norman','Jewison');
insert into director values(102,'Oliver','Hirschbiegel');
insert into director values(103,'Oliver','Stone');
insert into director values(104,'Orson','Welles');
insert into director values(105,'Otto','Preminger');
insert into director values(106,'Paul','Greengrass');
insert into director values(107,'Paul','Haggis');
insert into director values(108,'Paul','Anderson');
insert into director values(109,'Pete','Docter');
insert into director values(110,'Peter','Jackson');
insert into director values(111,'Quentin','Tarantino');
insert into director values(112,'Richard','Attenborough');
insert into director values(113,'Richard','Kelly');
insert into director values(114,'Richard','Marquand');
insert into director values(115,'Ridley','Scott');
insert into director values(116,'Rob','Minkoff');
insert into director values(117,'Rob','Reiner');
insert into director values(118,'Robert','Hamer');
insert into director values(119,'Robert','Mulligan');
insert into director values(120,'Robert','Rodriguez');
insert into director values(121,'Robert','Rossen');
insert into director values(122,'Robert','Wise');
insert into director values(123,'Robert','Zemeckis');
insert into director values(124,'Roberto','Benigni');
insert into director values(125,'Roger','Allers');
insert into director values(126,'Roman','Polanski');
insert into director values(127,'Sam','Mendes');
insert into director values(128,'Sam','Peckinpah');
insert into director values(129,'Sam','Taylor');
insert into director values(130,'Sean','Penn');
insert into director values(131,'Sergio','Leone');
insert into director values(132,'Sidney','Lumet');
insert into director values(133,'Stanley','Donen');
insert into director values(134,'Stanley','Kramer');
insert into director values(135,'Stanley','Kubrick');
insert into director values(136,'Steven','Spielberg');
insert into director values(137,'Stuart','Rosenberg');
insert into director values(138,'Terry','George');
insert into director values(139,'Terry','Gilliam');
insert into director values(140,'Terry','Jones');
insert into director values(141,'Tim','Burton');
insert into director values(142,'Todd','Phillips');
insert into director values(143,'Tomas','Alfredson');
insert into director values(144,'Tony','Kaye');
insert into director values(145,'Valerie','Faris');
insert into director values(146,'Victor','Fleming');
insert into director values(147,'Vittorio','Sica');
insert into director values(148,'William','Wellman');
insert into director values(149,'William','Friedkin');
insert into director values(150,'William','Keighley');
insert into director values(151,'William','Wyler');
insert into director values(152,'Wolfgang','Petersen');
insert into director values(153,'Woody','Allen');

这个是电影
insert into MovieInfo values (1,'The Shawshank Redemption','MA',1994,142,'Castle Rock Entertainment');
insert into MovieInfo values (2,'The Godfather','MA',1972,175,'Alfran Production');
insert into MovieInfo values (3,'The Godfather: Part II','M',1974,200,'Paramount Picture');
insert into MovieInfo values (4,'Il buono,il brutto,il cattivo.','MA',1966,161,'Arturo Gonz¨¢lez Producciones Cinematogr¨¢ficas, S.A');
insert into MovieInfo values (5,'Pulp Fiction','R',1994,154,'A Band Apart');
insert into MovieInfo values (6,'Schindler''s List','M',1993,195,'Universal Picture');
insert into MovieInfo values (7,'The Dark Knight','M',2008,152,'Warner Bros. Picture');
insert into MovieInfo values (8,'12 Angry Men','G',1957,96,'Orion-Nova Production');
insert into MovieInfo values (9,'One Flew Over the Cuckoo''s Nest','M',1975,133,'Fantasy Film');
insert into MovieInfo values (10,'Star Wars: Episode V - The Empire Strikes Back','PG',1980,124,'Lucasfilm');
insert into MovieInfo values (11,'Casablanca','PG',1942,102,'Warner Bros. Picture');
insert into MovieInfo values (12,'Star Wars','PG',1977,121,'Lucasfilm');
insert into MovieInfo values (13,'The Lord of the Rings: The Return of the King','M',2003,201,'New Line Cinema');
insert into MovieInfo values (14,'Shichinin no samurai','PG',1954,160,'Toho Company');
insert into MovieInfo values (15,'Goodfellas','R',1990,146,'Warner Bros. Picture');
insert into MovieInfo values (16,'Rear Window','PG',1954,112,'Paramount Picture');
insert into MovieInfo values (17,'Cidade de Deus','R',2002,130,NULL);
insert into MovieInfo values (18,'Raiders of the Lost Ark','M',1981,115,'Lucasfilm');
insert into MovieInfo values (19,'C''era una volta il West','M',1968,175,'Finanzia San Marco');
insert into MovieInfo values (20,'Fight Club','R',1999,139,'Art Linson Production');
insert into MovieInfo values (21,'The Lord of the Rings: The Fellowship of the Ring','M',2001,178,'New Line Cinema');
insert into MovieInfo values (22,'The Usual Suspects','MA',1994,106,'PolyGram Filmed Entertainment');
insert into MovieInfo values (23,'Psycho','M',1960,109,'Shamley Production');
insert into MovieInfo values (24,'The Silence of the Lambs','MA',1991,118,'Orion Pictures Corporation');
insert into MovieInfo values (25,'Up','PG',2009,96,'Walt Disney Picture');
insert into MovieInfo values (26,'Sunset Blvd.','PG',1950,110,'Paramount Picture');
insert into MovieInfo values (27,'The Matrix','M',1999,136,'Groucho II Film Partnership');
insert into MovieInfo values (28,'Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb','PG',1964,93,'Columbia Pictures Corporation');
insert into MovieInfo values (29,'Memento','MA',2000,113,'Newmarket Capital Group');
insert into MovieInfo values (30,'North by Northwest','G',1959,131,'Metro-Goldwyn-Mayer (MGM)');
insert into MovieInfo values (31,'It''s a Wonderful Life','PG',1946,130,'Liberty Films (II)');
insert into MovieInfo values (32,'Se7en','R',1995,127,'New Line Cinema');
insert into MovieInfo values (33,'The Lord of the Rings: The Two Towers','M',2002,179, NULL);
insert into MovieInfo values (34,'Citizen Kane','G',1941,119,'Mercury Production');
insert into MovieInfo values (35,'L¨¦on','M',1994,110,'Gaumont');
insert into MovieInfo values (36,'Apocalypse Now','R',1979,153,'Zoetrope Studio');
insert into MovieInfo values (37,'American Beauty','MA',1999,122,'DreamWorks SKG');
insert into MovieInfo values (38,'Taxi Driver','R',1976,113,'Columbia Pictures Corporation');
insert into MovieInfo values (39,'American History X','MA',1998,119,'New Line Cinema');
insert into MovieInfo values (40,'Vertigo','PG',1958,128,'Alfred J. Hitchcock Production');
insert into MovieInfo values (41,'Lawrence of Arabia','M',1962,216,'Horizon Pictures (II)');
insert into MovieInfo values (42,'Forrest Gump','PG',1994,142,'Paramount Picture');
insert into MovieInfo values (43,'WALL¡¤E','G',2008,98,'Pixar Animation Studio');
insert into MovieInfo values (44,'Paths of Glory','PG',1957,87,'Bryna Production');
insert into MovieInfo values (45,'Le fabuleux destin d''Am¨¦lie Poulain','M',2001,122,'Claudie Ossard Production');
insert into MovieInfo values (46,'M','PG',1931,117,'Nero-Film AG');
insert into MovieInfo values (47,'Double Indemnity','PG',1944,NULL,'Paramount Picture');
insert into MovieInfo values (48,'Alien','M',1979,117,'Brandywine Production');
insert into MovieInfo values (49,'To Kill a Mockingbird','PG',1962,129,'Brentwood Production');
insert into MovieInfo values (50,'The Treasure of the Sierra Madre','PG',1948,126,'Warner Bros. Picture');
insert into MovieInfo values (51,'A Clockwork Orange','R',1971,136,'Warner Bros. Picture');
insert into MovieInfo values (52,'The Shining','MA',NULL,142,'Hawk Film');
insert into MovieInfo values (53,'Saving Private Ryan','MA',1998,170,'Amblin Entertainment');
insert into MovieInfo values (54,'Terminator 2: Judgment Day','M',1991,137,'Carolco Picture');
insert into MovieInfo values (55,'The Third Man','PG',1949,104,'London Film Production');
insert into MovieInfo values (56,'The Departed','MA',2006,151,'Warner Bros. Picture');
insert into MovieInfo values (57,'Das Leben der Anderen','MA',2006,137,'Arte');
insert into MovieInfo values (58,'The Pianist','MA',2002,150,'R.P. Production');
insert into MovieInfo values (59,'Chinatown','M',1974,131,'Paramount Picture');
insert into MovieInfo values (60,'Sen to Chihiro no kamikakushi','PG',2001,125,'Studio Ghibli');
insert into MovieInfo values (61,'City Lights','G',1931,87,'Charles Chaplin Production');
insert into MovieInfo values (62,'Eternal Sunshine of the Spotless Mind','M',2004,108,'Anonymous Content');
insert into MovieInfo values (63,'Aliens','M',1986,137,'Twentieth Century-Fox Film Corporation');
insert into MovieInfo values (64,'L.A. Confidential','MA',1997,138,'Regency Enterprise');
insert into MovieInfo values (65,'Requiem for a Dream','R',2000,102,'Artisan Entertainment');
insert into MovieInfo values (66,'Das Boot','M',1981,149,'Bavaria');
insert into MovieInfo values (67,'Monty Python and the Holy Grail','PG',1975,91,'Michael White Production');
insert into MovieInfo values (68,'The Bridge on the River Kwai','PG',1957,161,'Horizon Pictures (II)');
insert into MovieInfo values (69,'Reservoir Dogs','R',1992,99,'Live Entertainment');
insert into MovieInfo values (70,'Slumdog Millionaire','MA',2008,120,'Fox Searchlight Picture');
insert into MovieInfo values (71,'El laberinto del fauno','MA',2006,119,'Tequila Gang');
insert into MovieInfo values (72,'Raging Bull','MA',1980,129,'Chartoff-Winkler Production');
insert into MovieInfo values (73,'All About Eve','PG',NULL,NULL,'Twentieth Century-Fox Film Corporation');
insert into MovieInfo values (74,'The Maltese Falcon','G',1941,101,'Warner Bros. Picture');
insert into MovieInfo values (75,'In the wood','M',1950,88,'Daiei Motion Picture Company');
insert into MovieInfo values (76,'Singin'' in the Rain','G',1952,103,'Loew''');
insert into MovieInfo values (77,'Modern Times','G',1936,87,'Charles Chaplin Production');
insert into MovieInfo values (78,'Gran Torino','M',2008,116,'Matten Production');
insert into MovieInfo values (79,'Some Like It Hot','PG',1959,120,'Ashton Production');
insert into MovieInfo values (80,'Rebecca','PG',1940,130,'Selznick International Picture');
insert into MovieInfo values (81,'Der Untergang','MA',2004,156,'Constantin Film Produktion');
insert into MovieInfo values (82,'The Prestige','M',2006,130,'Touchstone Picture');
insert into MovieInfo values (83,'Metropolis','G',1927,153,'Universum Film (UFA)');
insert into MovieInfo values (84,'The Apartment','PG',1960,125,'Mirisch Corporation');
insert into MovieInfo values (85,'Amadeus','PG',1984,160,'The Saul Zaentz Company');
insert into MovieInfo values (86,'The Elephant Man','M',1980,124,'Brooksfilm');
insert into MovieInfo values (87,'Nuovo cinema Paradiso','PG',1988,155,'Cristaldifilm');
insert into MovieInfo values (88,'La vita bella','M',1997,NULL,'Cecchi Gori Group Tiger Cinematografica');
insert into MovieInfo values (89,'2001: A Space Odyssey','G',1968,141,'Metro-Goldwyn-Mayer (MGM)');
insert into MovieInfo values (90,'The Great Dictator','G',1940,125,'Charles Chaplin Production');
insert into MovieInfo values (91,'Once Upon a Time in America','R',1984,229,'Embassy International Picture');
insert into MovieInfo values (92,'Full Metal Jacket','R',1987,116,'Natant');
insert into MovieInfo values (93,'Ladri di biciclette','PG',1948,93,'Produzioni De Sica');
insert into MovieInfo values (94,'Back to the Future','M',1985,117,'Universal Picture');
insert into MovieInfo values (95,'The Great Escape','PG',1963,172,'Mirisch Corporation');
insert into MovieInfo values (96,'Mr. Smith Goes to Washington','G',1939,129,'Columbia Pictures Corporation');
insert into MovieInfo values (97,'The Sting','PG',1973,129,'Zanuck/Brown Production');
insert into MovieInfo values (98,'Sin City','MA',2005,124,'Dimension Film');
insert into MovieInfo values (99,'Touch of Evil','M',NULL,95,'Universal International Pictures (UI)');
insert into MovieInfo values (100,'Braveheart','MA',1995,177,'Icon Entertainment International');
insert into MovieInfo values (101,'Star Trek','M',2009,127,'Paramount Picture');
insert into MovieInfo values (102,'On the Waterfront','PG',1954,108,'Horizon Picture');
insert into MovieInfo values (103,'Det sjunde inseglet','PG',1957,96,'Svensk Filmindustri (SF)');
insert into MovieInfo values (104,'Hotel Rwanda','M',2004,121,'United Artist');
insert into MovieInfo values (105,'The Wrestler','MA',2008,111,'Wild Bunch');
insert into MovieInfo values (106,'Batman Begins','M',NULL,140,'Warner Bros. Picture');
insert into MovieInfo values (107,'Indiana Jones and the Last Crusade','PG',1989,127,'Lucasfilm');
insert into MovieInfo values (108,'Jaws','M',1975,124,'Zanuck/Brown Production');
insert into MovieInfo values (109,'The Green Mile','MA',1999,188,'Castle Rock Entertainment');
insert into MovieInfo values (110,'No Country for Old Men','MA',2007,122,'Paramount Vantage');
insert into MovieInfo values (111,'Strangers on a Train','M',1951,101,'Warner Bros. Picture');
insert into MovieInfo values (112,'Unforgiven','M',1992,131,'Malpaso Production');
insert into MovieInfo values (113,'Star Wars: Episode VI - Return of the Jedi','PG',1983,134,'Lucasfilm');
insert into MovieInfo values (114,'Blade Runner','M',1982,117,'Ladd Company');
insert into MovieInfo values (115,'Gladiator','M',2000,155,'DreamWorks SKG');
insert into MovieInfo values (116,'The Manchurian Candidate','M',1962,126,'M.C. Production');
insert into MovieInfo values (117,'Notorious','M',1946,101,'Vanguard Film');
insert into MovieInfo values (118,'Oldboy','MA',2003,120,'Egg Film');
insert into MovieInfo values (119,'Per qualche dollaro in pi¨´','M',1965,132,'Arturo Gonz¨¢lez Producciones Cinematogr¨¢fica');
insert into MovieInfo values (120,'Die Hard','M',1988,131,'Twentieth Century-Fox Film Corporation');
insert into MovieInfo values (121,'High Noon','PG',1952,85,'Stanley Kramer Production');
insert into MovieInfo values (122,'The Big Sleep','M',1946,114,'Warner Bros. Picture');
insert into MovieInfo values (123,'Cool Hand Luke','M',1967,126,'Jalem Production');
insert into MovieInfo values (124,'Fargo','MA',1996,98,NULL);
insert into MovieInfo values (125,'The Wizard of Oz','G',1939,101,'Metro-Goldwyn-Mayer (MGM)');
insert into MovieInfo values (126,'The General','G',1926,107,'Buster Keaton Production');
insert into MovieInfo values (127,'Witness for the Prosecution','G',NULL,116,'Edward Small Production');
insert into MovieInfo values (128,'Mononoke-hime','M',1997,134,'DENTSU Music And Entertainment');
insert into MovieInfo values (129,'There Will Be Blood','M',2007,158,'Ghoulardi Film Company');
insert into MovieInfo values (130,'Smultronstallet','RC',1957,91,'Svensk Filmindustri (SF)');
insert into MovieInfo values (131,'Donnie Darko','M',2001,113,'Pandora Cinema');
insert into MovieInfo values (132,'It Happened One Night','PG',1934,105,'Columbia Pictures Corporation');
insert into MovieInfo values (133,'Heat','MA',1995,171,'Warner Bros. Picture');
insert into MovieInfo values (134,'Kind Hearts and Coronets','G',1949,106,'Ealing Studio');
insert into MovieInfo values (135,'Yojimbo','PG',1961,110,'Kurosawa Production Co.');
insert into MovieInfo values (136,'Annie Hall','M',1977,93,'Rollins-Joffe Production');
insert into MovieInfo values (137,'Ran','PG',1985,160,'Greenwich Film Production');
insert into MovieInfo values (138,'The Deer Hunter','R',1978,182,'EMI Film');
insert into MovieInfo values (139,'The Sixth Sense','M',1999,107,'Barry Mendel Production');
insert into MovieInfo values (140,'Ben-Hur','PG',1959,212,'Metro-Goldwyn-Mayer (MGM)');
insert into MovieInfo values (141,'Les diaboliques','PG',1955,114,'Filmsonor');
insert into MovieInfo values (142,'Judgment at Nuremberg','PG',1961,186,'Roxlom Films Inc.');
insert into MovieInfo values (143,'Platoon','MA',1986,120,'Hemdale Film');
insert into MovieInfo values (144,'Kill Bill: Vol. 1','R',2003,111,'Miramax');
insert into MovieInfo values (145,'Into the Wild','M',2007,148,'Paramount Vantage');
insert into MovieInfo values (146,'Le salaire de la peur','M',1953,131,'Compagnie Industrielle et Commerciale Cin¨¦matographique (CICC)');
insert into MovieInfo values (147,'Le notti di Cabiria','M',1957,110,'Dino de Laurentiis Cinematografica');
insert into MovieInfo values (148,'Million Dollar Baby','M',2004,132,'Warner Bros. Picture');
insert into MovieInfo values (149,'Butch Cassidy and the Sundance Kid','PG',1969,110,'Campanile Production');
insert into MovieInfo values (150,'The Bourne Ultimatum','M',2007,115,'Universal Picture');
insert into MovieInfo values (151,'The Grapes of Wrath','PG',1940,128,'Twentieth Century-Fox Film Corporation');
insert into MovieInfo values (152,'Eight and a half','PG',1963,138,'Cineriz');
insert into MovieInfo values (153,'Life of Brian','M',1979,94,'HandMade Film');
insert into MovieInfo values (154,'Snatch.','MA',2000,104,'Columbia Pictures Corporation');
insert into MovieInfo values (155,'The Big Lebowski','MA',1998,117,'Polygram Filmed Entertainment');
insert into MovieInfo values (156,'The Gold Rush','G',1925,96,'Charles Chaplin Production');
insert into MovieInfo values (157,'The Graduate','M',1967,105,'Embassy Pictures Corporation');
insert into MovieInfo values (158,'The Night of the Hunter','M',1955,92,'Paul Gregory Production');
insert into MovieInfo values (159,'Stand by Me','M',1986,89,'Act III');
insert into MovieInfo values (160,'Finding Nemo','G',2003,110,'Walt Disney Picture');
insert into MovieInfo values (161,'The Killing','PG',1956,85,'Harris-Kubrick Production');
insert into MovieInfo values (162,'Ratatouille','PG',2007,NULL,'Pixar Animation Studio');
insert into MovieInfo values (163,'Gandhi','PG',1982,188,'Columbia Pictures Corporation');
insert into MovieInfo values (164,'Dog Day Afternoon','M',1975,125,'Artists Entertainment Complex');
insert into MovieInfo values (165,'Brief Encounter','G',1945,86,'Cineguild');
insert into MovieInfo values (166,'Amores perros','MA',2000,154,'Altavista Film');
insert into MovieInfo values (167,'Gone with the Wind','PG',1939,238,'Selznick International Picture');
insert into MovieInfo values (168,'The Lion King','G',1994,89,'Walt Disney Feature Animation');
insert into MovieInfo values (169,'The Hangover','MA',2009,100,'Warner Bros. Picture');
insert into MovieInfo values (170,'Trainspotting','R',1996,94,'Channel Four Film');
insert into MovieInfo values (171,'Sunrise: A Song of Two Humans','G',1927,95,'Fox Film Corporation');
insert into MovieInfo values (172,'Scarface','R',1983,170,'Universal Picture');
insert into MovieInfo values (173,'The Thing','R',1982,109,'David Foster Production');
insert into MovieInfo values (174,'Groundhog Day','PG',1993,101,'Columbia Pictures Corporation');
insert into MovieInfo values (175,'The Terminator','M',1984,108,'Hemdale Film');
insert into MovieInfo values (176,'The Wild Bunch','MA',1969,134,'Warner Brothers/Seven Art');
insert into MovieInfo values (177,'Sleuth','M',1972,138,'Palomar Picture');
insert into MovieInfo values (178,'V for Vendetta','MA',2005,132,'Silver Picture');
insert into MovieInfo values (179,'The Kid','G',1921,68,'Charles Chaplin Production');
insert into MovieInfo values (180,'Harvey','G',1950,104,'Universal International Pictures (UI)');
insert into MovieInfo values (181,'Toy Story','G',1995,81,'Walt Disney Picture');
insert into MovieInfo values (182,'The Hustler','PG',1961,134,'Rossen Film');
insert into MovieInfo values (183,'The Best Years of Our Lives','PG',1946,172,'Samuel Goldwyn Company');
insert into MovieInfo values (184,'Umberto D.','PG',1952,89,'Amato Film');
insert into MovieInfo values (185,'Shadow of a Doubt','PG',1943,108,'Skirball Production');
insert into MovieInfo values (186,'The Princess Bride','PG',1987,98,'Act III Communication');
insert into MovieInfo values (187,'The Incredibles','PG',2004,115,'Walt Disney Picture');
insert into MovieInfo values (188,'Twelve Monkeys','M',1995,129,'Universal Picture');
insert into MovieInfo values (189,'Lock,  Stock and Two Smoking Barrels','MA',1998,107,'Summit Entertainment');
insert into MovieInfo values (190,'Stalag 17','G',1953,120,'Paramount Picture');
insert into MovieInfo values (191,'Children of Men','MA',2006,109,'Universal Picture');
insert into MovieInfo values (192,'Casino','R',1995,178,'Universal Picture');
insert into MovieInfo values (193,'Hotaru no haka','M',1988,89,'Shinchosha Company');
insert into MovieInfo values (194,'The Curious Case of Benjamin Button','M',2008,166,'Warner Bros. Picture');
insert into MovieInfo values (195,'Duck Soup','G',1933,68,'Paramount Picture');
insert into MovieInfo values (196,'The Lady Vanishes','G',1938,96,'Gainsborough Picture');
insert into MovieInfo values (197,'The African Queen','G',1951,105,'Horizon Pictures (II)');
insert into MovieInfo values (198,'The Ox-Bow Incident','PG',1943,75,'Twentieth Century-Fox Film Corporation');
insert into MovieInfo values (199,'Dial M for Murder','PG',1954,105,'Warner Bros. Picture');
insert into MovieInfo values (200,'Anatomy of a Murder','M',1959,160,'Carlyle Production');
insert into MovieInfo values (201,'La battaglia di Algeri','M',1966,121,'Igor Film');
insert into MovieInfo values (202,'A Streetcar Named Desire','M',1951,122,'Charles K. Feldman Group');
insert into MovieInfo values (203,'In Bruges','MA',2008,107,'Blueprint Picture');
insert into MovieInfo values (204,'Letters from Iwo Jima','MA',2006,141,'Amblin Entertainment');
insert into MovieInfo values (205,'The Adventures of Robin Hood','PG',1938,102,'Warner Bros. Picture');
insert into MovieInfo values (206,'King Kong','PG',1933,100,'RKO Radio Picture');
insert into MovieInfo values (207,'Lt den rtte komma in','MA',2008,115,'EFTI');
insert into MovieInfo values (208,'Who''s Afraid of Virginia Woolf?','M',1966,131,'Warner Bros. Picture');
insert into MovieInfo values (209,'The Lost Weekend','PG',1945,101,'Paramount Picture');
insert into MovieInfo values (210,'The Exorcist','R',1973,122,'Hoya Production');
insert into MovieInfo values (211,'The Conversation','M',1974,113,'American Zoetrope');
insert into MovieInfo values (212,'La strada','G',1954,108,'Ponti-De Laurentiis Cinematografica');
insert into MovieInfo values (213,'Ed Wood','M',1994,127,'Touchstone Picture');
insert into MovieInfo values (214,'His Girl Friday','PG',NULL,92,'Columbia Pictures Corporation');
insert into MovieInfo values (215,'Rope','PG',1948,80,'Transatlantic Picture');
insert into MovieInfo values (216,'Safety Last!','G',1923,73,'Hal Roach Studio');
insert into MovieInfo values (217,'Le scaphandre et le papillon','M',2007,112,'Path¨¦ Renn Production');
insert into MovieInfo values (218,'Changeling','MA',2008,141,'Imagine Entertainment');
insert into MovieInfo values (219,'Rosemary''s Baby','M',1968,136,'William Castle Production');
insert into MovieInfo values (220,'Bonnie and Clyde','M',1967,112,'Tatira-Hiller Production');
insert into MovieInfo values (221,'All Quiet on the Western Front','PG',1930,96,'Universal Picture');
insert into MovieInfo values (222,'Sweet Smell of Success','M',1957,96,'Curtleigh Production');
insert into MovieInfo values (223,'Manhattan','M',1979,96,'Jack Rollins and Charles H. Joffe Production');
insert into MovieInfo values (224,'Network','M',1976,121,'Metro-Goldwyn-Mayer (MGM)');
insert into MovieInfo values (225,'Crash','MA',2004,112,'Bob Yari Production');
insert into MovieInfo values (226,'The Philadelphia Story','PG',1940,112,'Loew''');
insert into MovieInfo values (227,'Frankenstein','M',1931,71,'Universal Picture');
insert into MovieInfo values (228,'Patton','M',1970,170,'Twentieth Century-Fox Film Corporation');
insert into MovieInfo values (229,'Kill Bill: Vol. 2','MA',2004,136,'Miramax Film');
insert into MovieInfo values (230,'Great Expectations','G',1946,118,'Cineguild');
insert into MovieInfo values (231,'Laura','G',1944,88,'Twentieth Century-Fox Film Corporation');
insert into MovieInfo values (232,'Arsenic and Old Lace','PG',1944,118,'Warner Bros. Picture');
insert into MovieInfo values (233,'Big Fish','PG',2003,125,'Columbia Pictures Corporation');
insert into MovieInfo values (234,'The Day the Earth Stood Still','PG',1951,92,'Twentieth Century-Fox Film Corporation');
insert into MovieInfo values (235,'Magnolia','MA',1999,188,'Ghoulardi Film Company');
insert into MovieInfo values (236,'Mystic River','MA',2003,137,'Warner Bros. Picture');
insert into MovieInfo values (237,'Good Will Hunting','M',1997,126,'Be Gentlemen Limited Partnership');
insert into MovieInfo values (238,'Wo hu cang long','M',2000,120,'Asia Union Film and Entertainment Ltd.');
insert into MovieInfo values (239,'My Man Godfrey','G',1936,94,'Universal Picture');
insert into MovieInfo values (240,'Roman Holiday','G',1953,118,'Paramount Picture');
insert into MovieInfo values (241,'Rocky','G',1976,119,'Chartoff-Winkler Production');
insert into MovieInfo values (242,'Glory','PG',1989,122,'TriStar Picture');
insert into MovieInfo values (243,'Little Miss Sunshine','M',2006,101,'Fox Searchlight Picture');
insert into MovieInfo values (244,'La dolce vita','PG',1960,174,'Riama Film');
insert into MovieInfo values (245,'Nosferatu eine Symphonie des Grauens','PG',1922,94,'Jofa-Atelier Berlin-Johannisthal');
insert into MovieInfo values (246,'In the Heat of the Night','M',1967,109,'Mirisch Corporation');
insert into MovieInfo values (247,'Harold and Maude','M',1971,91,'Mildred Lewis and Colin Higgins Production');
insert into MovieInfo values (248,'Bringing Up Baby','G',1938,102,'RKO Radio Picture');
insert into MovieInfo values (249,'Planet of the Apes','PG',1968,112,'APJAC Production');
insert into MovieInfo values (250,'Spartacu','PG',1960,184,'Bryna Production');

这个是投票的表
insert into ranking values ('aden373',1,5,'11/10/1998');
insert into ranking values ('aden373',3,3,'13/9/2003');
insert into ranking values ('aden373',56,2,'19/11/2004');
insert into ranking values ('adria',27,2,'8/7/2004');
insert into ranking values ('adria',122,2,'1/2/2006');
insert into ranking values ('adria',145,3,'2/11/2000');
insert into ranking values ('ashlea36',2,3,'25/11/2000');
insert into ranking values ('ashlea830',12,4,'31/10/2007');
insert into ranking values ('ashlea877',25,5,'25/6/1998');
insert into ranking values ('ashley',24,5,'7/9/1999');
insert into ranking values ('ashley',6,3,'11/4/2000');
insert into ranking values ('ashley519',22,4,'7/10/2002');
insert into ranking values ('ashley519',2,4,'7/1/2006');
insert into ranking values ('ashley519',3,5,'18/7/2000');
insert into ranking values ('brian827',11,3,'17/7/2000');
insert into ranking values ('bryce',2,5,'3/3/2003');
insert into ranking values ('bryce',3,2,'27/8/2004');
insert into ranking values ('bryony427',3,3,'20/1/2001');
insert into ranking values ('buddy',2,2,'30/5/2001');
insert into ranking values ('buddy421',55,4,'13/7/1998');
insert into ranking values ('buddy421',12,5,'26/1/1998');
insert into ranking values ('burke152',5,2,'1/10/2003');
insert into ranking values ('caden',44,3,'30/5/1999');
insert into ranking values ('caden',25,3,'13/6/2000');
insert into ranking values ('cadence',6,5,'28/9/1998');
insert into ranking values ('cadence',53,5,'20/1/2002');
insert into ranking values ('cailyn',5,3,'9/3/2007');
insert into ranking values ('camden529',21,3,'25/9/2006');
insert into ranking values ('camden529',125,5,'5/12/2005');
insert into ranking values ('camden529',225,2,'28/8/2006');
insert into ranking values ('camden529',37,2,'12/11/2007');
insert into ranking values ('camden529',56,4,'16/10/2001');
insert into ranking values ('clinton',23,2,'15/4/1999');
insert into ranking values ('colbert',23,2,'10/8/2004');
insert into ranking values ('dianna',11,3,'2/5/2001');
insert into ranking values ('dianna',99,5,'19/9/1999');
insert into ranking values ('diantha518',2,4,'13/2/2005');
insert into ranking values ('docia',2,4,'21/9/1998');
insert into ranking values ('dominic',45,2,'5/6/1999');
insert into ranking values ('dorinda',8,3,'5/2/2005');
insert into ranking values ('dorinda765',7,3,'17/4/2007');
insert into ranking values ('ethan',7,4,'23/2/2006');
insert into ranking values ('ethelyn',76,5,'8/7/1998');
insert into ranking values ('ethelyn',19,2,'26/10/2007');
insert into ranking values ('eugene566',9,4,'30/10/2001');
insert into ranking values ('eustace',5,4,'13/10/2004');
insert into ranking values ('eustace',16,5,'23/12/2006');
insert into ranking values ('eustace279',4,5,'4/2/2002');
insert into ranking values ('eustace862',84,5,'18/10/2001');
insert into ranking values ('evan',55,5,'14/12/2000');
insert into ranking values ('evan',212,5,'9/12/2001');
insert into ranking values ('evan',214,4,'9/5/2000');
insert into ranking values ('evan',223,4,'10/12/2005');
insert into ranking values ('gilbert',59,3,'18/12/2003');
insert into ranking values ('gilbert520',75,2,'1/8/2006');
insert into ranking values ('gilbert520',95,3,'24/1/2005');
insert into ranking values ('ginny',46,5,'21/1/2000');
insert into ranking values ('ginny576',54,2,'4/9/1998');
insert into ranking values ('hailey',5,4,'5/3/2004');
insert into ranking values ('hailey568',4,2,'28/9/2006');
insert into ranking values ('hall',6,3,'27/6/2003');
insert into ranking values ('hamnet',54,3,'7/8/2003');
insert into ranking values ('hamnet367',28,3,'6/6/2001');
insert into ranking values ('hamnet367',168,4,'20/4/2000');
insert into ranking values ('india',35,3,'18/5/1998');
insert into ranking values ('india542',77,2,'18/4/2001');
insert into ranking values ('india542',246,4,'16/12/2005');
insert into ranking values ('iona',96,5,'10/2/2006');
insert into ranking values ('iona92',55,4,'9/4/2002');
insert into ranking values ('irene',34,4,'27/8/2004');
insert into ranking values ('isaac',18,2,'2/5/2004');
insert into ranking values ('isebella684',25,2,'9/11/2006');
insert into ranking values ('ivory972',106,3,'31/7/2002');
insert into ranking values ('ivory972',199,3,'4/10/2000');
insert into ranking values ('jacob',72,4,'15/7/2006');
insert into ranking values ('jacob552',98,5,'8/10/2007');
insert into ranking values ('jacob552',197,5,'23/11/2007');
insert into ranking values ('jacob679',37,4,'26/6/1999');
insert into ranking values ('jacob679',150,2,'17/1/2005');
insert into ranking values ('jasper',86,5,'8/9/2004');
insert into ranking values ('jeanette',43,4,'4/1/2001');
insert into ranking values ('jeanette',217,4,'6/3/1999');
insert into ranking values ('jeanette710',23,2,'24/6/2002');
insert into ranking values ('jeanette710',218,3,'26/9/2006');
insert into ranking values ('jeanette710',219,2,'30/11/2001');
insert into ranking values ('jeanette80',123,2,'22/5/1999');
insert into ranking values ('jeanette840',156,2,'29/10/1999');
insert into ranking values ('jeanette840',203,4,'7/10/2001');
insert into ranking values ('jemima',224,4,'19/10/2006');
insert into ranking values ('jemima',229,4,'23/9/2001');
insert into ranking values ('jemima',230,5,'20/2/1998');
insert into ranking values ('jemima',245,4,'19/4/2001');
insert into ranking values ('jemima365',221,3,'23/5/2000');
insert into ranking values ('ladonna',178,2,'26/10/2006');
insert into ranking values ('ladonna',180,2,'22/2/2001');
insert into ranking values ('lainey37',202,5,'12/4/2003');
insert into ranking values ('lainey686',133,5,'23/9/2004');
insert into ranking values ('lakisha',78,5,'25/9/2003');
insert into ranking values ('pearl',237,5,'4/6/2004');
insert into ranking values ('peers',156,4,'20/7/2006');
insert into ranking values ('peggy621',74,3,'13/4/2001');
insert into ranking values ('peggy621',135,5,'29/6/2007');
insert into ranking values ('percy',89,4,'26/12/2005');
insert into ranking values ('percy101',144,2,'16/7/1998');
insert into ranking values ('percy259',196,5,'17/11/2004');
insert into ranking values ('percy559',54,3,'20/5/2000');
insert into ranking values ('percy745',79,3,'30/11/2005');
insert into ranking values ('philippa441',166,4,'2/7/1999');

第2题我自己也做好了，谁帮助我做第3题？