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)


而要求的是哪些演员没有出现在电影里，列出他们的ID，和姓名

应该怎么做


[ 本帖最后由 jackyshen 于 2010-5-16 20:06 编辑 ]

是不是我问的不够详细，MovieInfo和actor的sql资料是有，不过有好多呢，我怕太多，贴不上来。如果就这点资料，这题目能做吗

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 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');

select Actor.actorID,Actor.firstname+' '+lastname
from Cast inner join Actor
on Cast.actorID = Actor.ActorID
where isnull(Cast.mvID,'')=''
cast表里应该是actorID和mvID的对应关系信息吧？

嗯，没错是对应的这个是cast的表
insert into cast values (1,348);
insert into cast values (2,254);
insert into cast values (3,6);
insert into cast values (4,96);
insert into cast values (5,199);
insert into cast values (6,236);
insert into cast values (7,62);
insert into cast values (8,255);
insert into cast values (9,270);
insert into cast values (10,252);
insert into cast values (11,160);
insert into cast values (12,252);
insert into cast values (13,286);
insert into cast values (14,341);
insert into cast values (15,304);
insert into cast values (16,172);
insert into cast values (17,13);
insert into cast values (18,150);
insert into cast values (19,153);
insert into cast values (20,95);
insert into cast values (21,7);
insert into cast values (22,335);
insert into cast values (23,22);
insert into cast values (24,190);
insert into cast values (25,93);
insert into cast values (26,375);
insert into cast values (27,219);
insert into cast values (28,296);
insert into cast values (29,146);
insert into cast values (30,54);
insert into cast values (31,172);
insert into cast values (32,38);
insert into cast values (33,42);
insert into cast values (34,202);
insert into cast values (35,183);
insert into cast values (36,254);
insert into cast values (37,223);
insert into cast values (38,304);
insert into cast values (39,95);
insert into cast values (40,172);
insert into cast values (41,295);
insert into cast values (42,351);
insert into cast values (43,31);
insert into cast values (44,225);
insert into cast values (45,27);
insert into cast values (46,294);
insert into cast values (47,121);
insert into cast values (48,353);
insert into cast values (49,141);
insert into cast values (50,160);
insert into cast values (51,243);
insert into cast values (52,166);
insert into cast values (53,350);
insert into cast values (54,25);
insert into cast values (55,203);
insert into cast values (55,202);
insert into cast values (56,234);
insert into cast values (57,259);
insert into cast values (58,4);
insert into cast values (59,166);
insert into cast values (60,316);
insert into cast values (61,367);
insert into cast values (62,186);
insert into cast values (63,332);
insert into cast values (64,223);
insert into cast values (65,99);
insert into cast values (66,208);
insert into cast values (67,139);
insert into cast values (68,375);
insert into cast values (69,151);
insert into cast values (70,81);
insert into cast values (71,163);
insert into cast values (72,304);
insert into cast values (73,34);
insert into cast values (74,160);
insert into cast values (75,357);
insert into cast values (76,130);
insert into cast values (77,58);
insert into cast values (78,69);
insert into cast values (79,249);
insert into cast values (80,231);
insert into cast values (81,44);
insert into cast values (82,158);
insert into cast values (83,14);
insert into cast values (84,165);
insert into cast values (85,112);
insert into cast values (86,21);
insert into cast values (87,24);
insert into cast values (88,309);
insert into cast values (89,220);
insert into cast values (90,58);
insert into cast values (91,304);
insert into cast values (92,265);
insert into cast values (93,227);
insert into cast values (94,273);
insert into cast values (95,338);
insert into cast values (96,181);
insert into cast values (97,291);
insert into cast values (98,185);
insert into cast values (99,60);
insert into cast values (100,268);
insert into cast values (101,61);
insert into cast values (102,254);
insert into cast values (103,143);
insert into cast values (104,378);
insert into cast values (105,277);
insert into cast values (106,62);
insert into cast values (107,150);
insert into cast values (108,315);
insert into cast values (109,350);
insert into cast values (110,354);
insert into cast values (111,113);
insert into cast values (112,69);
insert into cast values (113,252);
insert into cast values (114,150);
insert into cast values (115,317);
insert into cast values (116,120);
insert into cast values (117,54);
insert into cast values (118,279);
insert into cast values (119,69);
insert into cast values (120,43);
insert into cast values (121,125);
insert into cast values (122,160);
insert into cast values (123,291);
insert into cast values (124,374);
insert into cast values (125,207);
insert into cast values (126,250);
insert into cast values (127,360);
insert into cast values (128,379);
insert into cast values (129,75);
insert into cast values (130,366);
insert into cast values (131,169);
insert into cast values (132,66);
insert into cast values (133,6);
insert into cast values (134,79);
insert into cast values (135,357);
insert into cast values (136,377);
insert into cast values (137,343);
insert into cast values (138,304);
insert into cast values (139,43);
insert into cast values (140,60);
insert into cast values (141,333);
insert into cast values (142,334);
insert into cast values (143,221);
insert into cast values (144,362);
insert into cast values (145,102);
insert into cast values (146,182);
insert into cast values (147,135);
insert into cast values (148,69);
insert into cast values (149,291);
insert into cast values (150,263);
insert into cast values (151,153);
insert into cast values (152,245);
insert into cast values (153,139);
insert into cast values (154,3);
insert into cast values (155,184);
insert into cast values (156,58);
insert into cast values (157,18);
insert into cast values (158,306);
insert into cast values (159,371);
insert into cast values (160,8);
insert into cast values (161,336);
insert into cast values (162,290);
insert into cast values (163,32);
insert into cast values (164,6);
insert into cast values (165,57);
insert into cast values (166,103);
insert into cast values (167,346);
insert into cast values (168,201);
insert into cast values (169,39);
insert into cast values (170,110);
insert into cast values (171,134);
insert into cast values (172,6);
insert into cast values (173,226);
insert into cast values (174,36);
insert into cast values (175,25);
insert into cast values (176,375);
insert into cast values (177,231);
insert into cast values (178,284);
insert into cast values (179,48);
insert into cast values (180,172);
insert into cast values (181,350);
insert into cast values (182,291);
insert into cast values (183,283);
insert into cast values (184,49);
insert into cast values (185,344);
insert into cast values (186,53);
insert into cast values (187,73);
insert into cast values (188,204);
insert into cast values (189,179);
insert into cast values (190,375);
insert into cast values (191,206);
insert into cast values (192,304);
insert into cast values (193,359);
insert into cast values (194,55);
insert into cast values (195,142);
insert into cast values (196,247);
insert into cast values (197,160);
insert into cast values (198,153);
insert into cast values (199,300);
insert into cast values (201,40);
insert into cast values (202,368);
insert into cast values (203,72);
insert into cast values (204,222);
insert into cast values (205,108);
insert into cast values (206,114);
insert into cast values (207,212);
insert into cast values (208,98);
insert into cast values (209,300);
insert into cast values (210,99);
insert into cast values (211,129);
insert into cast values (212,23);
insert into cast values (213,200);
insert into cast values (214,54);
insert into cast values (215,172);
insert into cast values (216,148);
insert into cast values (217,261);
insert into cast values (218,16);
insert into cast values (219,269);
insert into cast values (220,370);
insert into cast values (221,239);
insert into cast values (222,46);
insert into cast values (223,377);
insert into cast values (224,115);
insert into cast values (225,214);
insert into cast values (226,54);
insert into cast values (227,71);
insert into cast values (228,132);
insert into cast values (229,362);
insert into cast values (230,198);
insert into cast values (231,131);
insert into cast values (232,54);
insert into cast values (233,110);
insert into cast values (234,275);
insert into cast values (235,211);
insert into cast values (236,325);
insert into cast values (237,310);
insert into cast values (238,380);
insert into cast values (239,376);
insert into cast values (240,141);
insert into cast values (241,340);
insert into cast values (242,264);
insert into cast values (243,1);
insert into cast values (244,245);
insert into cast values (245,266);
insert into cast values (246,331);
insert into cast values (247,319);
insert into cast values (248,217);
insert into cast values (249,60);
insert into cast values (250,225);
insert into cast values (1,282);
insert into cast values (2,6);
insert into cast values (3,305);
insert into cast values (4,69);
insert into cast values (5,321);
insert into cast values (6,32);
insert into cast values (7,152);
insert into cast values (8,194);
insert into cast values (9,293);
insert into cast values (10,150);
insert into cast values (11,162);
insert into cast values (12,150);
insert into cast values (13,11);
insert into cast values (14,357);
insert into cast values (15,299);
insert into cast values (16,138);
insert into cast values (17,232);
insert into cast values (18,213);
insert into cast values (19,68);
insert into cast values (20,38);
insert into cast values (21,286);
insert into cast values (22,123);
insert into cast values (23,365);
insert into cast values (24,21);
insert into cast values (25,65);
insert into cast values (26,137);
insert into cast values (27,229);
insert into cast values (28,132);
insert into cast values (29,52);
insert into cast values (30,109);
insert into cast values (31,88);
insert into cast values (32,282);
insert into cast values (33,323);
insert into cast values (34,89);
insert into cast values (35,127);
insert into cast values (36,257);
insert into cast values (37,20);
insert into cast values (38,190);
insert into cast values (39,94);
insert into cast values (40,224);
insert into cast values (41,10);
insert into cast values (42,311);
insert into cast values (43,97);
insert into cast values (44,298);
insert into cast values (45,262);
insert into cast values (46,101);
insert into cast values (47,30);
insert into cast values (48,332);
insert into cast values (49,197);
insert into cast values (50,369);
insert into cast values (51,289);
insert into cast values (52,328);
insert into cast values (53,352);
insert into cast values (54,238);
insert into cast values (56,263);
insert into cast values (57,361);
insert into cast values (58,345);
insert into cast values (59,115);
insert into cast values (60,281);
insert into cast values (61,116);
insert into cast values (62,216);
insert into cast values (63,51);
insert into cast values (64,317);
insert into cast values (65,178);
insert into cast values (66,154);
insert into cast values (67,192);
insert into cast values (68,10);
insert into cast values (69,349);
insert into cast values (70,322);
insert into cast values (71,326);
insert into cast values (72,56);
insert into cast values (73,19);
insert into cast values (74,260);
insert into cast values (75,241);
insert into cast values (76,87);
insert into cast values (77,292);
insert into cast values (78,63);
insert into cast values (79,355);
insert into cast values (80,188);
insert into cast values (81,12);
insert into cast values (82,62);
insert into cast values (83,144);
insert into cast values (84,330);
insert into cast values (85,351);
insert into cast values (86,196);
insert into cast values (87,105);
insert into cast values (88,285);
insert into cast values (89,126);
insert into cast values (90,167);
insert into cast values (91,173);
insert into cast values (92,2);
insert into cast values (93,106);
insert into cast values (94,64);
insert into cast values (95,170);
insert into cast values (96,172);
insert into cast values (97,307);
insert into cast values (98,82);
insert into cast values (99,177);
insert into cast values (100,171);
insert into cast values (101,383);
insert into cast values (102,215);
insert into cast values (103,33);
insert into cast values (104,85);
insert into cast values (105,251);
insert into cast values (106,272);
insert into cast values (107,324);
insert into cast values (108,308);
insert into cast values (109,78);
insert into cast values (110,180);
insert into cast values (111,320);
insert into cast values (112,129);
insert into cast values (113,150);
insert into cast values (114,318);
insert into cast values (115,189);
insert into cast values (116,230);
insert into cast values (117,162);
insert into cast values (118,187);
insert into cast values (119,233);
insert into cast values (120,37);
insert into cast values (121,346);
insert into cast values (122,228);
insert into cast values (123,133);
insert into cast values (124,337);
insert into cast values (125,119);
insert into cast values (126,136);
insert into cast values (127,253);
insert into cast values (128,381);
insert into cast values (129,258);
insert into cast values (130,35);
insert into cast values (131,157);
insert into cast values (132,67);
insert into cast values (133,304);
insert into cast values (134,363);
insert into cast values (135,343);
insert into cast values (136,84);
insert into cast values (137,5);
insert into cast values (138,384);
insert into cast values (139,147);
insert into cast values (140,164);
insert into cast values (141,364);
insert into cast values (142,46);
insert into cast values (143,117);
insert into cast values (144,240);
insert into cast values (145,246);
insert into cast values (146,59);
insert into cast values (147,118);
insert into cast values (148,155);
insert into cast values (149,307);
insert into cast values (150,210);
insert into cast values (151,174);
insert into cast values (152,68);
insert into cast values (153,192);
insert into cast values (154,373);
insert into cast values (155,195);
insert into cast values (156,242);
insert into cast values (157,90);
insert into cast values (158,329);
insert into cast values (159,302);
insert into cast values (160,100);
insert into cast values (161,70);
insert into cast values (162,161);
insert into cast values (163,47);
insert into cast values (164,384);
insert into cast values (165,358);
insert into cast values (166,124);
insert into cast values (167,29);
insert into cast values (168,264);
insert into cast values (169,91);
insert into cast values (170,111);
insert into cast values (171,176);
insert into cast values (172,339);
insert into cast values (173,372);
insert into cast values (174,15);
insert into cast values (175,271);
insert into cast values (176,107);
insert into cast values (177,272);
insert into cast values (178,159);
insert into cast values (179,92);
insert into cast values (180,205);
insert into cast values (181,347);
insert into cast values (182,168);
insert into cast values (183,122);
insert into cast values (184,248);
insert into cast values (185,202);
insert into cast values (186,244);
insert into cast values (187,156);
insert into cast values (188,43);
insert into cast values (189,83);
insert into cast values (190,86);
insert into cast values (191,280);
insert into cast values (192,327);
insert into cast values (193,28);
insert into cast values (194,209);
insert into cast values (195,149);
insert into cast values (196,274);
insert into cast values (197,217);
insert into cast values (198,74);
insert into cast values (199,138);
insert into cast values (200,172);
insert into cast values (201,182);
insert into cast values (202,254);
insert into cast values (203,41);
insert into cast values (204,218);
insert into cast values (205,287);
insert into cast values (206,303);
insert into cast values (207,237);
insert into cast values (208,301);
insert into cast values (209,175);
insert into cast values (210,267);
insert into cast values (211,384);
insert into cast values (212,135);
insert into cast values (213,256);
insert into cast values (214,314);
insert into cast values (215,193);
insert into cast values (216,278);
insert into cast values (217,104);
insert into cast values (218,128);
insert into cast values (219,191);
insert into cast values (220,115);
insert into cast values (221,235);
insert into cast values (222,355);
insert into cast values (223,84);
insert into cast values (224,375);
insert into cast values (225,76);
insert into cast values (226,217);
insert into cast values (228,215);
insert into cast values (229,77);
insert into cast values (230,356);
insert into cast values (231,74);
insert into cast values (232,297);
insert into cast values (233,9);
insert into cast values (234,288);
insert into cast values (235,374);
insert into cast values (236,348);
insert into cast values (237,263);
insert into cast values (238,276);
insert into cast values (239,50);
insert into cast values (240,26);
insert into cast values (241,342);
insert into cast values (242,80);
insert into cast values (243,140);
insert into cast values (244,17);
insert into cast values (245,145);
insert into cast values (246,312);
insert into cast values (247,45);
insert into cast values (248,54);
insert into cast values (249,313);
insert into cast values (250,231);