Homework Assignment 4 • Database file – Movies_database.mdb – Design and run queries to find the information retrieved from three tables Homework Assignment 4 • Query questions 1. The list of movie stars who won Best Male Actor Awards for a movie in the Drama category – Star Name (ascending), movie title 2. The sum of total OSCAR awards (regardless of category) won by all the movies in which a particular star played a role – Star Name, Sum of Awards (descending order) 3. Distinct Best Picture Award Winning movies in which a New Jersey-born star has played a role – Movie Year (ascending order), Movie Title (ascending) Homework Assignment 4 • Requirements – For each question: • Capture the screen display of query result and paste it to a Word document • Add the question description and SQL statement on top of the screen shot – The Word file must be saved in PDF format as “Assignment4_YOURlastname.pdf” – Due time: April/3 (mid-night)
CLASSIC MOVIES CATIDCategoryDesc ADVAdventure ANMAnimation BIOBiography COMComedy CRMCrime DRMDrama HORHorror HSTHistory MUSMusical MYSMystery RLGReligious SFIScience Fiction SPTSports SUSSuspense WARWar WSTWestern FAMFamily THRThriller RMCRomance FNTFantasy SHKShakespeare POLPolitical DOCDocumentary CNTRYIDCountryName ARGArgentina AUSAustralia BOSBosnia BRZBrazil CANCanada CHNChina DMKDenmark FINFinland FRNFrance GRMGermany INDIndia IREIreland IRNIran ISRIsrael ITLItaly JPNJapan MEXMexico SPNSpain SWDSweden UKUnited Kingdom USUnited States ASTAustria BLGBelgium CZRCzech Republic EGTEgypt GRCGreece HNGHungary LBNLebanon LTHLithuania MLYMalaysia NZLNew Zealand PAKPakistan RMNRomania RUSRussia SAFSouth Africa TUNTunisia LTVLatvia CAMCambodia CBACuba SVKSlovakia GRGGeorgia UKRUkraine BNNBenin PRPuerto Rico NGNew Guinea POLPoland SWZSwitzerland UNKUnknown IVCIvory Coast NTHNetherlands VTNVietnam TWNTaiwan BOTBotswana SGLSenegal AZRAzerbaijan KNYKenya TRKTurkey MLDMoldova UGDUganda CYPCyprus ALGAlgeria CHLChile COLColombia DIRNAMEDIRBORNDIRDIEDSEXDIRNUMCNTRYID McCarthy, Thomas1/30/69M243US Tanovic, Danis2/20/69M244BOS Lund, KatiaF245BRZ Miyazaki, Hayao1/5/41M246JPN Lang, Fritz12/5/908/2/76M247AST Stanton, AndrewM248US Tornatore, Guiseppe5/27/56M249ITL Rosenberg, Stuart1/16/27M250US Figgis, Mike2/28/48M251UK Robbins, Tim10/16/58M252US Columbus, Chris11/10/58M101US Emmerich, Roland11/10/55M183GRM Raimi, Sam10/23/59M205US Sonnenfeld, Barry4/1/53M59US Marquand, Richard4/17/389/4/87M60UK Bay, Michael2/17/65M102US Woo, John5/1/46M40CHN Zucker, Jerry3/11/50M254US Clements, Ron4/25/53M158US De Bont, Jan10/22/43M159NTH Almodovar, Pedro9/24/49M255SPN Powell, Michael9/30/052/19/90M272UK Bennett, Compton1/15/008/13/74M273UK Koster, Henry5/1/059/21/88M274GRM Logan, Joshua10/5/087/12/88M16US Wayne, John5/26/076/11/79M275US Dassin, Jules12/18/11M24US Cardiff, Jack9/18/14M27UK Thompson, J. Lee8/1/148/30/02M28UK Wicki, Bernhard10/28/191/5/00M276AST DaCosta, Morton3/7/141/29/89M277US Germi, Pietro9/14/1412/5/74M29ITL Marshall, George12/29/912/17/75M285US Glenville, Peter10/28/136/3/96M30UK Cacoyannis, Michael6/11/22M182CYP Lelouch, Claude10/30/37M256FRN Lewis, Gilbert3/6/20M278US Zeffirelli, Franco2/12/23M257ITL Hiller, Arthur11/22/23M258CAN Rafelson, Bob2/21/33M279US Bogdanovich, Peter7/30/39M259US Boorman, John1/18/33M260UK Troell, Jan7/23/31M261SWD Wertmuller, Lina8/14/26F262ITL Parker, Alan2/14/44M263UK Molinaro, Edouard5/31/28M264FRN Malle, Louis10/30/3211/23/95M265FRN Joffe, Roland11/17/45M266UK Allen, Woody12/1/35M1US Hitchcock, Alfred8/13/994/28/80M2UK Eastwood, Clint5/31/30M8US De Mille, Cecil B.8/12/811/21/59M3US Lee, Spike10/2/56M9US Kramer, Stanley9/23/132/19/01M4US Penn, Arthur9/27/22M10US Kubrick, Stanley7/6/283/7/99M5US Preminger, Otto12/5/064/23/86M6US Ford, John2/1/958/31/73M7US Mankiewicz, Joseph2/11/092/5/93M11US Curtiz, Michael12/14/8812/11/62M12HNG Huston, John8/5/068/28/87M13US Zinnemann, Fred4/29/073/14/97M14AST Forman, Milos2/18/32M15CZR Werner, Peter5/25/49M17US Pollack, Sydney7/1/34M18US Ross, Herbert5/13/2710/9/01M19US Hackford, Taylor12/3/44M20US Donner, Richard3/30/39M21US Coppola, Francis4/7/33M22US Wise, Robert9/10/14M23US Lucas, George5/14/44M25US Attenborough, Richard8/29/23M26UK Rossen, Robert3/16/0811/2/66M31US Pakula, Alan4/7/2811/19/98M32US Hill, George Roy12/20/2212/27/02M33US Demme, Jonathan2/22/44M34US Ivory, James6/7/28M35US Zemeckis, Robert3/21/52M36US Stone, Oliver9/15/46N37US Levinson, Barry7/2/42M38US Nichols, Mike11/6/31M39US Crichton, Charles8/6/109/14/99M41UK Stevens, George12/18/043/8/75M42US Redford, Robert8/18/37M43US Edwards, Blake7/26/22M44US Kazan, Elia9/7/099/28/03M45TRK Cukor, George7/7/995/9/83M46US Wilder, Billy6/22/063/27/02M47POL McCarey, Leo10/3/987/3/69M48US Burton, Tim4/13/58M49US Brooks, Mel6/28/26M50US Keaton, Buster10/4/952/1/66M61US Antonioni, Michelangelo9/29/12M51ITL Taurog, Norman2/23/994/7/81M52US Singleton, John1/6/68M53US Lean, David3/25/084/6/91M54UK Hawks, Howard5/30/9612/26/77M55US Fosse, Bob6/23/275/1/87M56US Fleming, Victor2/23/834/6/49M57US Seaton, George4/17/119/16/79M58US Chaplin, Charlie4/16/8912/25/77M62UK Gordon, Michael9/6/094/29/93M64US Capra, Frank5/18/979/3/91M65ITL Butler, David12/17/9410/14/79M66US Van Dyke, W. S.3/21/892/5/43M67US Altman, Robert2/20/25M63US Spielberg, Steven12/18/47M68US Davis, Ossie12/18/17M69US Zwick, Edward10/8/52M70US Jewison, Norman7/21/26M71US Nelson, Ralph8/12/1612/21/87M72US Van Peebles, Melvin8/21/32M73US Lynch, David1/20/46M74US Mate, Rudolph1/21/984/15/64M75POL Annaud, Jean-Jacques10/1/43M76FRN Truffaut, Francois2/6/3210/21/84M77FRN Ray, Nicholas8/7/114/20/79M78US Hallstrom, Lasse2/5/46M79SWD Petersen, Wolfgang3/14/41M80GRM Ephron, Nora5/19/41F81US Reiner, Rob3/6/45M82US Benton, Robert9/29/32M83US Walters, Charles11/17/115/20/82M84US Minnelli, Vincente2/28/107/25/86M85US Bertolucci, Bernardo3/16/40M86ITL Fellini, Federico1/20/2010/31/93M87ITL Milestone, Lewis9/30/956/10/80M88MLD Lloyd, Frank2/2/8811/1/60M89UK Green, Alfred4/4/897/9/60M90US Dieterle, William7/15/9311/14/72M91GRM Wyler, William7/1/021/15/81M92FRN Wood, Sam7/18/835/1/49M93US Shumlin, Herman12/6/986/4/79M94US King, Henry6/24/867/20/82M95US Brown, Clarence5/10/908/17/87M96US Leisen, Mitchell10/6/989/3/72M97US Potter, H. C.11/3/044/21/77M98US Olivier, Laurence5/22/077/11/89M99UK Negulesco, Jean2/26/007/18/93M100RMN Leonard, Robert10/7/893/20/68M149US Franklin, Sydney3/21/934/27/72M150US Mann, Daniel8/8/1211/21/91M103US Lang, Walter8/10/962/7/72M105US Litvak, Anatole5/10/0212/2/74M106UKR Johnson, Nunnally12/5/973/12/77M108US Clayton, Jack3/1/212/25/94M109US Brooks, Richard5/18/123/11/92M110US De Sica, Vittorio7/7/022/12/74M111ITL Ritt, Martin3/2/1412/8/90M113US Richardson, Tony6/5/2811/14/91M114UK Stevenson, Robert4/1/057/11/86M115UK Reed, Carol12/30/064/25/76M119UK Hathaway, Henry3/13/986/12/85M120US Schaffner, Franklin J.5/30/207/2/89M122JPN Frank, Melvin8/13/1310/13/88M126US Ashby, Hal7/9/2912/27/88M130US Mann, Delbert1/30/20M104US Anderson, Michael1/30/204/13/97M107US Mulligan, Robert8/23/2510/9/85M112US Silverstein, Elliott10/9/277/1/99M116US Schlesinger, John2/16/267/25/03M117UK Harvey, Anthony6/3/31M118US Neame, Ronald8/2/11M121UK Russell, Ken7/3/27M123US Friedkin, William8/29/39M124US Avildsen, John8/3/36M125US Mazursky, Paul4/25/30M127US Lumet, Sidney6/25/24M129US Cimino, Michael11/25/43M131US Apted, Michael2/10/41M132US Rydell, Mark3/23/34M133US Beatty, Warren3/30/37M134US Hudson, Hugh6/19/36M135US Brooks, James L.5/9/40M137US Babenco, Hector8/16/40M138ARG Masterson, Peter6/1/34M139US Haines, Randa1/19/45M140US De Palma, Brian9/11/40M141US Sheridan, Jim6/12/49M142IRE Kaplan, Jonathan11/25/47M143FRN Schroeder, Barbet4/26/41M144IRN Costner, Kevin1/18/55M145US Gibson, Mel1/3/56M146US Yates, Peter7/24/29M147UK Howard, Ron3/1/54M148US Scorsese, Martin11/17/42M128US Beresford, Bruce8/16/40M136AUS Kaufman, Philip10/23/36M151US Kelly, Gene8/23/122/2/96M152US Welles, Orson5/6/1510/10/85M153US Dmytryk, Edward9/4/087/1/99M154CAN Davis, Andrew9/7/52M155US Campion, Jane8/14/54F156NZL Brest, Martin10/21/51M157US Madden, John4/8/49M160UK Kapur, Shekhar6/6/459/6/98M161PAK Malick, Terence11/30/43M162US Benigni, Roberto10/27/52M163ITL Cameron, James8/16/54M164CAN Cattaneo, Peter10/5/61M165UK Van Sant, Gus7/24/524/30/89M166US Henson, Curtis9/30/53M167US Minghella, Anthony1/6/54M168UK Coen, Joel11/29/54M169US Crowe, Cameron7/13/57M170US Leigh, Mike2/20/43M171UK Hicks, Scott3/4/53M172UGD Miller, George3/3/45M173US Radford, Michael2/24/46M174IND Lee, Ang10/23/54M175TWN Newell, Mike3/28/42M176UK Tarantino, Quentin3/27/63M177US Darabont, Frank1/28/59M178FRN Jordan, Neil2/25/50M179IRE Trousdale, Gary2/17/46M180US Mendes, Sam8/1/65M181UK Shyamalan, M. Night8/6/70M184IND Peirce, Kimberly9/8/67F185US Mangold, JamesM186US Jonze, Spike9/1/69M187US Mann, Michael2/5/43M188US Soderbergh, Steven1/14/63M190US Harris, Ed11/28/50M191US Nolan, Christopher7/30/70M192UK Aronofsky, Darren2/12/69M193US Adamson, AndrewM194NZL Kurosawa, Akira3/23/109/6/98M195JPN Singer, Bryan6/30/66M196US Kirshner, Irvin4/29/23M197US Fincher, David6/30/62M198US Wachowski, Andy12/29/67M199US Leone, Sergio1/3/294/30/89M200ITL Scott, Ridley11/30/37M189UK Polanski, Roman3/18/33M201FRN Brannon, AshM202US Gilliam, Terry11/22/40M203US Frankenheimer, John2/19/307/6/02M204US Sturges, John1/3/118/18/92M206US Veber, Francis7/28/37M207FRN Jeunet, Jean-Pierre9/3/53M208FRN Eyre, Richard3/28/43M209UK Cuaron, Alfonso11/28/61M210MEX Nair, Mira10/15/57F211IND Majidi, Majid6/30/59M212IRN Lawrence, RayM213AUS Scherfig, Lone5/2/59F214DMK Bielinsky, FabianM215ARG Koshashvili, Dover6/30/66M216GRG Weir, Peter8/8/44M217AUS Donen, Stanley4/13/24M218US Costa-Gavras2/12/33M219GRC Zwick, Joel1/11/42M220US Sturges, Preston8/29/988/6/59M221US Borzage, Frank4/23/936/19/62M223US Bergman, Ingmar7/14/18M222SWD Goulding, Edmund3/20/9112/24/59M225UK Ruggles, Wesley6/11/891/8/72M226US Beaumont, Harry2/10/8812/22/66M224US Wellman, William2/29/9612/9/75M227US Verbinski, GoreM228US Jenkins, PattyF229US Jackson, Peter10/31/61M230NZL Marshall, Rob10/17/60M231US Daldry, Stephen5/2/61M232UK Link, Caroline6/2/64F233GRM Fuqua, Antoine1/19/66M234US Forster, Marc1/15/69M235GRM Arcand, Denys6/25/41M236CAN Zhang, Yimou11/14/51M237CHN Kaurismaki, Aki4/4/57M238FIN Taymor, Julie12/15/52F239US Hafstrom, Mikael7/1/60M240SWD Ross, Gary11/3/56M241US Salles, Walter4/12/56M242BRZ Lyne, Adrian3/4/41M267UK Frears, Stephen6/20/41M286US Robinson, Phil3/1/50M280US Branagh, Kenneth12/10/60M268UK Marshall, Penny10/15/42F281US Streisand, Barbra4/24/42F282US Kieslowski, Krzysztof6/27/41M269POL Egoyan, Atom7/19/60M270EGT Luhrman, Baz9/17/62M283AUS Coppola, Sofia5/14/71F271US Webber, Peter6/15/43M284US Docter, PeterM253US Aldrich, Robert8/9/1812/5/83M287US Anderson, Lindsay4/17/238/30/94M288US Anderson, Paul Thomas1/1/70M289US Anderson, Wes5/1/69M290US Anspaugh, David9/24/46M291US Anthony, Joseph5/24/121/20/93M292US Armstrong, Gillian12/18/50F293AUS Asquith, Anthony11/9/022/20/68M294UK August, Bille11/9/48M295DMK Avnet, Jon11/17/49M296US Badham, John8/25/39M297US Ballard, Carroll10/14/37M298US Benedek, Laszlo3/5/053/11/92M299HNG Benjamin, Richard5/22/38M300US Berkeley, Busby11/29/953/11/76M301US Bernhardt, Curtis4/15/992/22/81M302GRM Berry, John9/6/1711/29/99M303US Bogayevicz, Yurek9/16/48M304POL Bridges, James2/3/366/6/93M305US Bunuel, Luis2/22/007/29/83M306SPN Burge, Stuart1/15/181/24/02M307UK Carlino, Lewis John1/1/32M308US Caro, Niki4/20/67F309NZL Carpenter, John1/16/48M310US Cassavetes, John12/9/292/3/89M311US Cates, Gilbert6/6/34M312US Caton-Jones, Michael8/2/58M313UK Clark, Bob8/5/41M314US Clifford, Graeme11/6/42M316AUS Coe, Fred12/23/144/29/79M317US Condon, Bill10/22/55M318US Coolidge, Martha8/17/46F319US Craven, Wes8/2/39M320US Cromwell, John12/23/879/26/79M321US Crystal, Billy3/14/47M322US Daves, Delmer7/24/048/17/77M323US DeVito, Danny11/17/44M324US Donehue, Vincent J.9/22/151/17/66M325US Duvall, Robert1/5/31M326US Dwan, Allan4/3/8512/28/81M327CAN Edzard, Christine2/15/45F328FRN Faiman, Peter2/14/45M329US Bird, Brad3/25/57M315US Field, Todd2/24/64M330US Fleischer, Richard12/8/16M331US Foley, James12/18/53M332US Foster, Lewis R.8/5/986/10/74M333US Frankliln, Carl4/11/49M334US Furie, Sidney J.2/28/33M335CAN Garnett, Tay6/13/9410/3/77M336US Gibson, Brian9/22/441/4/04M337US Gilbert, Lewis3/6/20M339US Gilbert, Brian2/24/46M338US Glazer, Jonathan9/14/66M340US Gonzalez Inarritu, Alejandro8/15/63M341MEX Gordon, Steve6/21/3811/27/82M342US Green, Guy11/5/13M343UK Grosbard, Ulu1/9/29M344BLG Guillermin, John11/11/25M345UK Hall, Alexander1/11/947/30/68M346US Hamer, Robert3/31/1112/4/63M347US Hancock, John D.2/12/39M348US Hanson, Curtis3/24/45M349US Hardwicke, Catherine3/5/64F350UK Haynes, Todd1/2/61M351US Hedges, Peter7/6/62M352US Heisler, Stuart12/5/968/21/79M353US Herek, Stephen11/10/58M354US Herman, Mark2/28/54M355US Higgins, Colin7/28/418/5/88M356AUS Hoblit, Gregory11/27/44M357US Holland, Agnieszka11/28/48F358POL Hopper, Dennis5/17/36M359US Howard, Cy9/27/154/29/93M360US Hytner, Nicholas5/7/56M361UK James, Steve10/6/57M362US Jarrott, Charles6/6/27M363UK Johnson, Alan4/26/33M364US Jordan, Glenn4/5/36M365US Kadar, Jan4/1/186/1/79M366HNG Kasdan, Lawrence1/14/49M367US Kaye, Tony5/5/52M368UK Kimmins, Anthony11/10/015/19/64M369UK Kloves, Steven7/9/60M370US Konchalovsky, Andrei8/20/37M371RUS Kotcheff, Ted4/7/31M372CAN Kramer, Wayne11/14/65M373US Kresel, Lee2/6/1812/25/80M374US La Cava, Gregory3/10/923/1/52M375US Lamorisse, Albert1/13/226/2/70M376FRN Lasseter, John1/12/57M377US LeRoy, Mervyn10/15/009/13/87M378US Littman, Lynne6/26/41F379US Lonergan, Kenneth7/17/63M380US Lurie, Rod5/15/62M381ISR Lynn, Jonathan4/3/43M382UK Mackendrick, Alexander9/8/1212/22/93M383US Maguire, Sharon10/19/71F384UK Mandoki, Luis10/4/54M385MEX Marshall, Garry11/13/34M386US May, Elaine4/21/32F387US McTiernan, John1/8/51M388US Medak, Peter12/23/37M389HNG Menendez, Ramon1/27/39M390MEX Merhige, E. Elias4/3/64M391US Meyers, Nancy12/8/49F392US Mikhalkov, Nikita10/21/45M393RUS Miller, David11/28/094/14/92M394US Miller, Robert Ellis7/18/32M395US Moore, Robert8/7/275/10/84M396US Narizzano, Silvio2/8/27M397CAN Nava, Gregory4/10/49M398US Nelson, Jessie6/14/72F399US Newman, Paul1/26/25M400US Nichols, Dudley4/6/951/4/60M401US Noyce, Phillip4/29/50M402AUS Nunez, Victor3/27/45M403US Nuytten, Bruno8/28/45M404FRN O'Connor, Gavin3/14/65M405US Odets, Clifford7/18/068/18/63M406US Oz, Frank5/25/44M407UK Page, Anthony9/21/35M408IND Palcy, Euzhan1/13/58F409FRN Payne, Alexander2/10/61M410US Pearce, Richard1/25/43M411US Peckinpah, Sam2/21/2512/28/84M412US Peerce, Larry4/19/30M413US Perelman, Vadim10/22/73M414UKR Perry, Frank8/21/308/29/95M415US Petrie, Daniel11/26/208/22/04M416CAN Puenzo, Luis2/19/46M417ARG Rappeneau, Jean-Paul4/8/32M418FRN Rapper, Irving1/16/9812/20/99M419UK Rash, Steve4/7/27M420US Reiner, Carl3/20/22M421US Reisz, Karel7/21/2611/25/02M422CZR Reitman, Ivan10/27/46M423SLV Rene, Norman10/5/515/24/96M424US Resnais, Alain6/3/22M425FRN Richards, Dick8/14/36M426US Ritchie, Michael11/28/384/16/01M427US Robson, Mark12/4/136/20/78M428US Rudolph, Alan12/18/43M429US Rush, Richard6/8/30M430US Saks, Gene11/8/21M431US Sandrich, Mark8/26/003/4/45M432US Sayles, John9/28/50M433US Schatzberg, Jerry11/25/27M434US Schepisi, Fred12/26/39M435AUS Schnabel, Julian5/4/51M436US Schrader, Paul7/22/46M437US Schumacher, Joel8/29/39M438US Scola, Ettore5/10/31M439ITL Scott, Tony7/21/44M440UK Sherman, Vincent7/16/06M441US Sidney, George10/4/165/5/02M442US Sirk, Douglas4/26/971/14/87M443GRM Softley, Iain5/22/44M444UK Stahl, John M.1/21/861/12/50M445US Tacchella, Jean Charles9/23/25M446FRN Tati, Jacques10/9/0911/4/82M447FRN Tavernier, Bertrand4/25/41M448FRN Thornton, Billy Bob8/4/55M449US Tucker, Anand11/16/51M450US Underwood, Ron11/6/53M451US Verhoeven, Paul7/18/38M452NTH Vidor, Charles7/27/006/4/59M453HNG Vidor, King2/8/9411/1/82M454US Von Trier, Lars4/30/56M455DMK Wadleigh, Michael9/24/41M456US Wargnier, Regis1/29/31M457US Yorkin, Bud2/22/26M458US Young, Terence6/20/159/7/94M459CHN Zaillian, Steven1/30/53M460US Zaks, Jerry9/7/46M461GRM Zieff, Howard10/21/27M462US Guest, Christopher2/5/48M463US Blitz, Jeffrey2/19/69M464US Van Peebles, Mario1/15/57M465MEX George, Terry9/2/67M466UK Sembene, Ousmane1/1/23M467SGL Green, David Gordon4/9/75M468US Gondry, Michel5/8/63M469FRN Cloche, Maurice6/17/073/20/90M470FRN Clement, Rene3/18/133/17/96M471FRN Kinugasa, Teinosuke1/1/962/26/82M472JPN Inagaki, Hiroshi12/30/055/21/80M473JPN Wirth, Franz Peter9/22/1910/17/99M474GRM Camus, Marcel4/21/121/13/82M475FRN Bourguignon, Serge11/21/28M476FRN Widerberg, Bo6/8/305/1/97M477SWD Demy, Jacques6/5/3110/27/90M478FRN Pontecorvo, Gillo11/19/19M479ITL Menzel, Jiri2/23/38M480CZR Bondarchuk, Sergei9/25/2010/20/94M481UKR Lavrov, Kirill9/15/25M482RUS Rohmer, Eric4/4/20M483FRN Mizrahi, MosheM484ISR Blier, Bertrand3/14/39M485FRN Schlondorff, Volker3/31/39M486GRM Menshov, Vladimir9/17/39M487AZR Szabo, Istvan2/18/38M488HNG Garci, Jose Luis1/20/44M489SPN Dembo, Richard5/24/4811/11/04M490FRN Rademakers, Fons9/5/20M491NTH Axel, Gabriel4/18/18M492DMK Koller, Xavier9/2/44M493SWZ Salvatores, Gabriele7/30/50M494ITL Trueba, Fernando1/18/55M495SPN Chen, Kaige8/12/52M496CHN Tran, Anh Hung12/23/62M497VTN Gorris, Marleen12/9/48F498NTH Sverak, Jan2/6/65M499CZR Van Diem, Mike8/27/59M500NTH Saura, Carlos1/4/32M501SPN Hrebejk, Jan6/26/67M502CZR Trojan, Ondrej12/31/59M503CZR Kulik, Buzz7/23/221/13/99M504US Katselas, Milton12/22/33M505US Geronimi, Clyde6/12/014/24/89M506ITL Clark, Matt11/25/36M507US Bartel, Paul8/6/385/13/00M508US Uys, Jamie5/30/211/29/96M509SAF Chadha, Gurinder8/14/61F510KNY Risi, Dino12/23/16M511ITL Shadyac, Tom12/2/60M512US Sears, Ted3/13/008/22/58M513US Moore, Michael4/23/54M514US Roach, Jay5/27/57M515US Hand, David1/23/0010/11/86M516US Buck, Chris6/30/56F517US Tamahori, Lee11/29/50M518NZL Silberling, Brad10/5/62M519US Kleiser, Randal7/20/46M520US Farrelly, Bobby7/9/58M521US Sherman, Lowell10/11/8512/28/34M523US Pollak, Kay5/21/38M522SWD Barratier, ChristopheM524FRN Hirschbiegel, OliverM525GRM Amenabar, Alejandro3/31/72M526CHL Roodt, Darrell7/27/63M527SAF Linklater, Richard7/30/60M528US Marston, Joshua2/14/61M529US MVTITLEMPAAMVNUMMVYEARCATEGORYLENNOMSAWRDSCNTRYIDDIRNUMBESTDIRBESTPICWWGROSSBESTEDITBESTWRITEBESTFORUSGROSS SeabiscuitPG132962003BIO14170US241N157230NN120147 Motorcycle DiariesR2972004ADV1282US242N Station AgentR2982003COM8800US243 No Man's LandR2992001WAR9811BOS244N AmelieR3002001COM12240FRN208 The Lord of the Rings: Fellowship of the RingPG133012001FNT178134US230NN860700NN313838 Seven SamuraiNR3021954ADV16020JPN195 The Lord of the Rings: The Two TowersPG133032002FNT17962US230N921600N340479 City of GodR3052003CRM13040BRZ245NNN Good FellasR3061990CRM14561US128NNNN Spirited AwayPG3072001ANM12511JPN24625920094750 MNR3081931CRM11700GRM247 Kill Bill: Vol. 1R3092003CRM11100US177 Finding NemoG3102003ANM10041US248865000N339714 MetropolisNR3111927SFI15300GRM247 Cinema ParadisoNR3121989DRM15511ITL249W The Great DictatorNR3131940COM12450US62NN YojimboNR3141961CRM11010JPN195 NotoriousNR3151946MYS10120US2N Butch Cassidy and the Sundance KidNR3161969WST11074US33NN183642W102309 Once Upon a Time in AmericaR3171984CRM13900ITL200 Cool Hand LukeNR3181967DRM12641US250N Leaving Las VegasR3191995RMC11141US251NN Dead Man WalkingR3201995CRM12241US252N Harry Potter and the Sorcerer's StonePG662001SFI15230US101968600317558 Annie HallPG11977COM9454US1WWW Dr. StrangelovePG21964COM9340US5NNN A Clockwork OrangeR31971SFI13730US5NNNN North by NorthwestPG41959SUS13610US2NN RopeNR51948SUS8000US2 PsychoPG61960HOR10930US2N InteriorsPG71978DRM9330US1NN The BirdsNR81963HOR12000US2 Samson and DelilahNR91949RLG12810US3 Guess Who's Coming to Dinner?NR101967COM108102US4NNNW ManhattanR111979COM9620US1N VertigoNR121958MYS12800US2 Judgment at NurembergNR131961HST178112US4NNNW 2001: A Space OdysseyG141968SFI13920US5NN The Man with the Golden ArmNR151955DRM11910US6 Anatomy of a MurderNR161959MYS16040US6NNN Inherit the WindNR171960HST12720US4NN LauraNR181944MYS8551US6NN The Ten CommandmentsNR191956RLG22010US3NN The Moon is BlueNR201953COM9910US6N StagecoachNR211939WST9672US7NNN Rear WindowNR221954MYS11210US2NN MogamboNR231953ADV11520US7 The Grapes of WrathNR241940DRM12942US7WNNN Malcolm XPG251992BIO20100US9 UnforgivenR261992WST12700US8WW165200WN101157 Bonnie and ClydeNR271967CRM111102US10NNN Adventures of Robin HoodNR281938ADV10242US12NW Advise and ConsentNR291962DRM13920US6 The African QueenNR301951COM10563US13NN All About EveNR311950DRM138146US11WWNW The Treasure of the Sierra MadreNR331948WST12463US13WNW BoomtownNR341958ADV11620US7 High NoonNR351952WST8462US14NNWN AmadeusPG361984BIO158118US15WWNW Wall StreetR371987CRM12441US37 No Man's LandR381987DRM10630US17 Out of AfricaPG391985RMC161117US18WW239500NW94566 Max Dugan ReturnsPG401983COM9810US19 Lethal WeaponR421989SUS11020US21 The GodfatherR431972CRM175103US22NW244900NW134822 West Side StoryNR441961MUS1511110US23WWWN Star WarsPG461977SFI122106US25NN797900WN460936 GandhiPG471982BIO188118US26WWWW All the King's MenNR511949DRM10984US31NWNN All the President's MenPG521976HST13884US32NNNW The Quiet ManNR531952COM12973US7WNN The StingPG541973COM129107US33WW187000WW159600 The Silence of the LambsR551991HOR11875US34WW272700NW130727 Remains of the DayPG561993DRM13580US35NNN PhiladelphiaPG571993DRM10952US34201300N83450 Forrest GumpPG581994COM142136US36WW679400WW329691 JFKR591991MYS18882US37NN205400WN70405 Born on the 4th of JulyR601989WAR14482US37WNWN Rain ManR611988DRM14084US38WW412800NW172825 TootsiePG621982COM116101US18NN260000NN177200 Sophie's ChoiceR631982DRM15751US32N SilkwoodR641983DRM12850US39NNN The Bridges of Madison CountyPG651995RMC13500US8 A Fish Called WandaR711988COM10831US41NN A Place in the SunNR721951RMC12296US42WNWW A River Runs Through ItPG731992DRM12331US43N Shot in the DarkNR741964COM10100US44 A Tree Grows in BrooklynNR751945DRM12832US45N Adam's RibNR761949COM10010US46N An Officer and A GentlemanR771982RMC12562US20164000NN129796 The