database_init.sql

INSERT INTO directors VALUES
('Woody Allen',1935),
('Pedro Almodóvar',1949),
('Robert Altman',1925),
('Paul Thomas Anderson',1970),
('Kenneth Anger',1927),
('Michelangelo Antonioni',1912),
('Ingmar Bergman',1918),
('Luis Buñuel',1900),
('Tim Burton',1958),
('Laurent Cantet',1961),
('Nuri Bilge Ceylan',1959),
('Claude Chabrol',1930),
('Charles Chaplin',1889),
('Henri-Georges Clouzot',1907),
('Joel Coen',1954),
('Francis Ford Coppola',1939),
('Alex Cox',1954),
('David Cronenberg',1943),
('Jules Dassin',1911),
('Terence Davies',1945),
('Maya Deren',1917),
('Carl Theodor Dreyer',1889),
('Sergei Eisenstein',1898),
('Abel Ferrara',1951),
('David Fincher',1962),
('John Ford',1894),
('Georges Franju',1912),
('Samuel Fuller',1912),
('Abel Gance',1889),
('Bahman Ghobadi',1969),
('Terry Gilliam',1940),
('Jean-Luc Godard',1930),
('Peter Greenaway',1942),
('D.W. Griffith',1875),
('Michael Haneke',1942),
('Hal Hartley',1959),
('Howard Hawks',1896),
('Todd Haynes',1961),
('Werner Herzog',1942),
('Alfred Hitchcock',1899),
('Hsiao-Hsien Hou',1947),
('John Huston',1906),
('Derek Jarman',1942),
('Jim Jarmusch',1953),
('Alejandro Jodorowsky',1929),
('Mikhail Kalatozov',1903),
('Buster Keaton',1895),
('Krzysztof Kieslowski',1941),
('Takeshi Kitano',1947),
('Stanley Kubrick',1928),
('Akira Kurosawa',1910),
('Fritz Lang',1890),
('Lee Chang-dong',1954),
('Mike Leigh',1943),
('Sergio Leone',1929),
('Ernst Lubitsch',1892),
('David Lynch',1946),
('Alexander Mackendrick',1912),
('Guy Maddin',1956),
('Terrence Malick',1943),
('Louis Malle',1932),
('Michael Mann',1943),
('Yasuzô Masumura',1924),
('Shane Meadows',1972),
('Jean-Pierre Melville',1917),
('Lukas Moodysson',1969),
('F.W. Murnau',1888),
('Christopher Nolan',1970),
('Mamoru Oshii',1951),
('Nagisa Ôshima',1932),
('Pier Paolo Pasolini',1922),
('Sam Peckinpah',1925),
('Roman Polanski',1933),
('Michael Powell',1905),
('Otto Preminger',1905),
('Nicholas Ray',1911),
('Satyajit Ray',1921),
('Jean Renoir',1894),
('Alain Resnais',1922),
('Leni Riefenstahl',1902),
('Jacques Rivette',1928),
('John Sayles',1950),
('Martin Scorsese',1942),
('Victor Sjöström',1879),
('Steven Spielberg',1946),
('Josef von Sternberg',1894),
('Preston Sturges',1898),
('Quentin Tarantino',1963),
('Andrei Tarkovsky',1932),
('Hiroshi Teshigahara',1927),
('Dziga Vertov',1896),
('Jean Vigo',1905),
('Raoul Walsh',1887),
('Orson Welles',1915),
('Wim Wenders',1945),
('James Whale',1889),
('Billy Wilder',1906),
('Robert Wise',1914),
('William Wyler',1902),
('Yimou Zhang',1951),
('Chantal Akerman',1950),
('Theodoros Angelopoulos',1935),
('Matthew Barney',1967),
('Bernardo Bertolucci',1941),
('Albert Brooks',1947),
('James Cameron',1954),
('Frank Capra',1897),
('Leos Carax',1960),
('René Clair',1898),
('Jean Cocteau',1889),
('George Cukor',1899),
('Bavo Defurne',1900),
('Jacques Demy',1931),
('Brian De Palma',1940),
('Vittorio De Sica',1901),
('Yi''nan Diao',1900),
('William Dieterle',1893),
('Stanley Donen',1924),
('Aleksandr Dovzhenko',1894),
('Atom Egoyan',1960),
('Víctor Erice',1940),
('Asghar Farhadi',1972),
('Rainer Werner Fassbinder',1945),
('Federico Fellini',1920),
('Milos Forman',1932),
('John Frankenheimer',1930),
('Ritwik Ghatak',1925),
('Alejandro G. Iñárritu',1963),
('Henry Hathaway',1898),
('Kon Ichikawa',1915),
('Shôhei Imamura',1926),
('Spike Jonze',1969),
('Elia Kazan',1909),
('Abbas Kiarostami',1940),
('Masaki Kobayashi',1916),
('Satoshi Kon',1963),
('Hirokazu Koreeda',1962),
('Lev Kuleshov',1899),
('Claude Lanzmann',1925),
('David Lean',1908),
('Ang Lee',1954),
('Spike Lee',1957),
('Marcel L''Herbier',1888),
('Richard Linklater',1960),
('Joseph Losey',1909),
('Sidney Lumet',1924),
('Joseph L. Mankiewicz',1909),
('Anthony Mann',1906),
('Chris Marker',1921),
('Sergio Martino',1938),
('Jirí Menzel',1938),
('Takashi Miike',1960),
('Vincente Minnelli',1903),
('Hayao Miyazaki',1941),
('Kenji Mizoguchi',1898),
('Mikio Naruse',1905),
('Yasujirô Ozu',1903),
('Sergei Parajanov',1924),
('Park Chan-wook',1963),
('Alexander Payne',1961),
('Arthur Penn',1922),
('Vsevolod Pudovkin',1893),
('Man Ray',1890),
('Godfrey Reggio',1940),
('Rob Reiner',1947),
('Glauber Rocha',1939),
('Éric Rohmer',1920),
('Claude Sautet',1924),
('Ridley Scott',1937),
('Masahiro Shinoda',1931),
('Don Siegel',1912),
('Robert Siodmak',1900),
('Douglas Sirk',1897),
('Steven Soderbergh',1963),
('Aleksandr Sokurov',1951),
('Todd Solondz',1959),
('Sion Sono',1961),
('Erich von Stroheim',1885),
('Seijun Suzuki',1923),
('Jan Svankmajer',1934),
('István Szabó',1938),
('Isao Takahata',1935),
('Béla Tarr',1955),
('Zhuangzhuang Tian',1900),
('François Truffaut',1932),
('Shin''ya Tsukamoto',1960),
('Agnès Varda',1928),
('King Vidor',1894),
('Andrzej Wajda',1926),
('Kôji Wakamatsu',1936),
('Peter Weir',1944),
('William A. Wellman',1896),
('Michael Winterbottom',1961),
('Kar-Wai Wong',1956),
('Yôji Yamada',1931),
('Edward Yang',1947),
('Yoshishige Yoshida',1933),
('Woo-Ping Yuen',1945),
('Fred Zinnemann',1907),
('Andrey Zvyagintsev',1964),
('Robert Aldrich',1918),
('Michael Almereyda',1959),
('Wes Anderson',1969),
('Denys Arcand',1941),
('Dario Argento',1940),
('Darren Aronofsky',1969),
('Hal Ashby',1929),
('Mario Bava',1914),
('Luis García Berlanga',1921),
('Luc Besson',1959),
('Bertrand Blier',1939),
('John Boorman',1933),
('Danny Boyle',1956),
('Richard Brooks',1912),
('Charles Burnett',1944),
('Ken Burns',1953),
('Giuliano Carnimeo',1932),
('John Carpenter',1948),
('John Cassavetes',1929),
('Kaige Chen',1952),
('Patrice Chéreau',1944),
('Alan Clarke',1935),
('René Clément',1913),
('Roger Corman',1926),
('Costa-Gavras',1933),
('Alfonso Cuarón',1961),
('Chris Cunningham',1900),
('Adam Curtis',1955),
('Michael Curtiz',1886),
('Joe Dante',1946),
('Jonathan Demme',1944),
('Claire Denis',1946),
('André De Toth',1913),
('Edward Dmytryk',1908),
('Clint Eastwood',1930),
('Jean Epstein',1897),
('Jacques Feyder',1885),
('Mike Figgis',1948),
('Terence Fisher',1904),
('Ron Fricke',1900),
('William Friedkin',1935),
('Michel Gondry',1963),
('James Gray',1969),
('Val Guest',1911),
('Patricio Guzmán',1941),
('Alexander Hammid',1907),
('Walter Hill',1942),
('Mamoru Hosoda',1967),
('King Hu',1932),
('Jean-Pierre Jeunet',1953),
('Chuck Jones',1912),
('Jon Jost',1943),
('Gene Kelly',1912),
('Jee-woon Kim',1964),
('Kim Ki-duk',1960),
('Henry King',1886),
('Teinosuke Kinugasa',1896),
('Grigoriy Kozintsev',1905),
('Ray Lawrence',1900),
('James Marsh',1963),
('Leo McCarey',1896),
('Sam Mendes',1965),
('Kenji Misumi',1921),
('Kôji Morimoto',1959),
('Errol Morris',1948),
('Vincenzo Natali',1969),
('Jan Nemec',1936),
('Yuri Norstein',1941),
('François Ozon',1967),
('Alan J. Pakula',1928),
('Nick Park',1958),
('Ivan Passer',1933),
('Stephen Quay',1900),
('Martin Ritt',1914),
('Alain Robbe-Grillet',1922),
('Nicolas Roeg',1928),
('Bernard Rose',1960),
('Roberto Rossellini',1906),
('Walter Ruttmann',1887),
('John Schlesinger',1926),
('Ousmane Sembene',1923),
('Wladyslaw Starewicz',1882),
('Oliver Stone',1946),
('John Sturges',1910),
('Frank Tashlin',1913),
('Bertrand Tavernier',1941),
('Shûji Terayama',1935),
('Jacques Tourneur',1904),
('Maurice Tourneur',1876),
('Anh Hung Tran',1962),
('Lars von Trier',1956),
('Jirí Trnka',1912),
('Hark Tsui',1950),
('Gus Van Sant',1952),
('Wayne Wang',1949),
('Shin''ichirô Watanabe',1900),
('Apichatpong Weerasethakul',1970),
('Joss Whedon',1964),
('John Woo',1946),
('Robert Zemeckis',1951),
('Roger Allers',1949),
('Alejandro Amenábar',1972),
('Lindsay Anderson',1923),
('Roy Andersson',1943),
('Anthony Asquith',1902),
('Tex Avery',1908),
('Craig Baldwin',1900),
('Marco Bellocchio',1939),
('Claude Berri',1934),
('Peter Bogdanovich',1939),
('Bong Joon Ho',1969),
('John Boulting',1913),
('Catherine Breillat',1948),
('Kevin Brownlow',1938),
('Jane Campion',1954),
('Shane Carruth',1900),
('Hélène Cattet',1900),
('Alberto Cavalcanti',1897),
('Jack Clayton',1921),
('Larry Cohen',1936),
('Anton Corbijn',1955),
('Sergio Corbucci',1926),
('Charles Crichton',1910),
('Frank Darabont',1959),
('Dean DeBlois',1970),
('Andrew Dominik',1967),
('John Duigan',1949),
('Guru Dutt',1925),
('Blake Edwards',1922),
('Rob Epstein',1955),
('Marco Ferreri',1928),
('Oskar Fischinger',1900),
('Richard Fleischer',1916),
('Stephen Frears',1941),
('François Girard',1963),
('Jonathan Glazer',1965),
('Byron Haskin',1899),
('Jack Hill',1933),
('John Hillcoat',1961),
('Mike Hodges',1932),
('Sammo Kam-Bo Hung',1952),
('Takashi Ishii',1946),
('Joris Ivens',1898),
('Miklós Jancsó',1921),
('Barry Jenkins',1979),
('Zhangke Jia',1970),
('Adam Jones',1965),
('Tommy Lee Jones',1946),
('Dimitri Kirsanoff',1899),
('Patrice Leconte',1947),
('Mervyn LeRoy',1900),
('Albert Lewin',1894),
('Joseph H. Lewis',1907),
('Ye Lou',1965),
('David Mamet',1947),
('Rouben Mamoulian',1897),
('Lucky McKee',1975),
('Steve McQueen',1969),
('Jonas Mekas',1922),
('Russ Meyer',1922),
('Lewis Milestone',1895),
('John Milius',1944),
('Tomm Moore',1977),
('Nanni Moretti',1953),
('Christopher Morris',1965),
('Cristian Mungiu',1968),
('Fred C. Newmeyer',1888),
('Marcel Ophüls',1927),
('Joshua Oppenheimer',1974),
('György Pálfi',1974),
('Alan Parker',1944),
('Raoul Peck',1953),
('Christopher Petit',1900),
('Maurice Pialat',1925),
('Stephen Poliakoff',1952),
('Gillo Pontecorvo',1919),
('Sam Raimi',1959),
('Lynne Ramsay',1969),
('Edgar Reitz',1932),
('Tony Richardson',1928),
('Tim Robbins',1958),
('Bruce Robinson',1946),
('Mark Romanek',1959),
('Francesco Rosi',1922),
('Raúl Ruiz',1941),
('Volker Schlöndorff',1939),
('Julian Schnabel',1951),
('Warwick Thornton',1970),
('Johnnie To',1955),
('Joachim Trier',1974),
('Jan Troell',1931),
('Edgar G. Ulmer',1904),
('Lee Unkrich',1967),
('Denis Villeneuve',1967),
('Luchino Visconti',1906),
('Virgil Widrich',1967),
('Robert Wiene',1873),
('Frederick Wiseman',1930),
('Mai Zetterling',1925),
('Terry Zwigoff',1949),
('Alexandre Aja',1978),
('Richard Attenborough',1923),
('Samuel Bayer',1962),
('Les Blank',1935),
('Budd Boetticher',1916),
('Sergey Bondarchuk',1920),
('Stan Brakhage',1933),
('Nick Broomfield',1948),
('Donald Cammell',1934),
('Marcel Carné',1906),
('Derek Cianfrance',1974),
('Lawrence Gordon Clark',1938),
('Edward F. Cline',1891),
('Bruce Conner',1933),
('Cameron Crowe',1957),
('Basil Dearden',1911),
('Danny DeVito',1944),
('Pete Docter',1968),
('Richard Donner',1930),
('Gordon Douglas',1907),
('Louis Feuillade',1873),
('Robert Florey',1900),
('Marc Forster',1969),
('Bob Fosse',1927),
('Kinji Fukasaku',1930),
('Sidney J. Furie',1933),
('Clyde Geronimi',1901),
('Edmund Goulding',1891),
('David Gordon Green',1975),
('Paul Greengrass',1955),
('John Guillermin',1925),
('Tomás Gutiérrez Alea',1928),
('David Hand',1900),
('George Roy Hill',1921),
('Oliver Hirschbiegel',1957),
('James Ivory',1928),
('Peter Jackson',1961),
('Wilfred Jackson',1906),
('Garth Jennings',1900),
('Terry Jones',1942),
('Neil Jordan',1950),
('Shekhar Kapur',1945),
('Phil Karlson',1908),
('Lawrence Kasdan',1949),
('Philip Kaufman',1936),
('Jack Kinney',1909),
('Stanley Kramer',1913),
('Kiyoshi Kurosawa',1955),
('Emir Kusturica',1954),
('Barry Levinson',1942),
('Doug Liman',1965),
('Tobias Lindholm',1977),
('Bigas Luna',1946),
('Hamilton Luske',1903),
('Adrian Lyne',1941),
('Kevin Macdonald',1967),
('David Mackenzie',1966),
('Mohsen Makhmalbaf',1957),
('Norman Z. McLeod',1895),
('John McTiernan',1951),
('Rich Moore',1963),
('Peter Mullan',1959),
('Robert Mulligan',1925),
('Jimmy T. Murakami',1933),
('Tetsuya Nakashima',1959),
('Hideo Nakata',1961),
('Gaspar Noé',1963),
('Ermanno Olmi',1931),
('Göran Olsson',1965),
('Ruben Östlund',1974),
('Jafar Panahi',1960),
('Pawel Pawlikowski',1957),
('Christian Petzold',1960),
('Dominic Polcino',1964),
('Sydney Pollack',1934),
('H.C. Potter',1904),
('Alex Proyas',1963),
('Carol Reed',1906),
('Wolfgang Reitherman',1909),
('Matthew Rolston',1955),
('George A. Romero',1940),
('Alan Rudolph',1943),
('David O. Russell',1958),
('Walter Salles',1956),
('Chris Sanders',1962),
('Jerry Schatzberg',1927),
('Paul Schrader',1946),
('Ben Sharpsteen',1895),
('David Silverman',1957),
('Bryan Singer',1965),
('Jerzy Skolimowski',1938),
('Barry Sonnenfeld',1953),
('Walter A. Stern',1965),
('George Stevens',1904),
('Sam Taylor',1895),
('Giuseppe Tornatore',1956),
('Gary Trousdale',1960),
('Gore Verbinski',1964),
('Nicolas Winding Refn',1970),
('Edgar Wright',1974),
('Fatih Akin',1973),
('Tomas Alfredson',1965),
('James Algar',1912),
('Wesley Archer',1961),
('Pupi Avati',1938),
('Hector Babenco',1946),
('Boris Barnet',1902),
('Paul Bartel',1938),
('Warren Beatty',1937),
('Julie Bertuccelli',1968),
('Brad Bird',1957),
('Shane Black',1961),
('Bertrand Bonello',1968),
('Craig Brewer',1971),
('Peter Brook',1925),
('Jörg Buttgereit',1963),
('Niki Caro',1966),
('Enzo G. Castellari',1938),
('Liliana Cavani',1933),
('Youssef Chahine',1926),
('Benjamin Christensen',1879),
('Bob Clark',1939),
('Bill Condon',1955),
('Paddy Considine',1973),
('Julie Delpy',1969),
('Arnaud Desplechin',1960),
('Robert Downey Sr.',1936),
('Stephan Elliott',1964),
('Gareth Evans',1900),
('Aleksey Fedorchenko',1966),
('Tom Ford',1961),
('Hollis Frampton',1936),
('Grant Gee',1900),
('Ashutosh Gowariker',1964),
('Rachel Grady',1900),
('Ciro Guerra',1981),
('Wojciech Has',1925),
('Rutger Hauer',1944),
('Brian Henson',1963),
('Agnieszka Holland',1948),
('Ann Hui',1947),
('Hiroyuki Imaishi',1900),
('Shun''ya Itô',1937),
('Wen Jiang',1963),
('JR',1983),
('Tom Kalin',1900),
('Tony Kaye',1900),
('Lodge Kerrigan',1964),
('Hiroyuki Kitakubo',1963),
('Albert Lamorisse',1922),
('John Landis',1950),
('Paul Leni',1885),
('Irving Lerner',1909),
('Wei Lo',1900),
('Phil Lord',1975),
('David Lowery',1980),
('Samira Makhmalbaf',1980),
('Djibril Diop Mambéty',1945),
('Samuel Maoz',1962),
('Lucrecia Martel',1966),
('Tom McCarthy',1966),
('Georges Méliès',1861),
('Roger Michell',1956),
('Mike Mills',1900),
('Emilio Miraglia',1900),
('László Moholy-Nagy',1895),
('Sophie Muller',1962),
('Amir Naderi',1946),
('Mira Nair',1957),
('László Nemes',1977),
('Jeff Nichols',1978),
('Hiroyuki Okiura',1966),
('Katsuhiro Ôtomo',1954),
('Rithy Panh',1964),
('Robert Parrish',1916),
('Prachya Pinkaew',1962),
('Diego Quemada-Díez',1969),
('Carl Reiner',1922),
('Dick Richards',1900),
('Wolf Rilla',1920),
('Ken Russell',1927),
('Mark Sandrich',1900),
('Ariel Schulman',1900),
('Céline Sciamma',1978),
('Steven Shainberg',1963),
('Anup Singh',1900),
('Florent-Emilio Siri',1965),
('Kevin Smith',1970),
('Gisaburô Sugii',1940),
('Danis Tanovic',1969),
('Norman Taurog',1899),
('Fernando Trueba',1955),
('Thomas Vinterberg',1969),
('Frantisek Vlácil',1924),
('Xiaoshuai Wang',1966),
('Paul Andrew Williams',1900),
('Sadao Yamanaka',1909),
('Adam Yauch',1964),
('Masaaki Yuasa',1965),
('Franco Zeffirelli',1923),
('Ben Affleck',1972),
('Brad Anderson',1900),
('Michael Apted',1941),
('Jaume Balagueró',1968),
('Lamberto Bava',1944),
('Lucas Belvaux',1961),
('Susanne Bier',1960),
('Kathryn Bigelow',1951),
('Icíar Bollaín',1967),
('Frank Borzage',1894),
('Kenneth Branagh',1960),
('Tinto Brass',1933),
('Robert Bresson',1901),
('Mel Brooks',1926),
('Tod Browning',1880),
('Martin Campbell',1943),
('Joe Carnahan',1969),
('Jackie Chan',1954),
('Cheh Chang',1923),
('Larry Clark',1943),
('Ron Clements',1953),
('George Clooney',1961),
('Robert Clouse',1928),
('Sofia Coppola',1971),
('Destin Daniel Cretton',1978),
('Stephen Daldry',1960),
('Ronnie Del Carmen',1959),
('Guillermo del Toro',1964),
('Cecil B. DeMille',1881),
('Florian Henckel von Donnersmarck',1973),
('Bill Douglas',1934),
('Allan Dwan',1885),
('Richard Eyre',1943),
('Dave Fleischer',1894),
('Friz Freleng',1904),
('Vincent Gallo',1961),
('Alex Gibney',1953),
('Amos Gitai',1950),
('Jack Gold',1930),
('Stuart Gordon',1947),
('Paul Gore',1900),
('Robert Greene',1976),
('Howard Greenhalgh',1900),
('Dave Grohl',1969),
('Luca Guadagnino',1971),
('Christopher Guest',1948),
('Guy Hamilton',1922),
('Stuart Heisler',1896),
('Hong Sang-soo',1960),
('Tom Hooper',1972),
('Byron Howard',1968),
('Ken Jacobs',1933),
('Thomas Job',1900),
('Mathieu Kassovitz',1967),
('Aki Kaurismäki',1957),
('Yoshiaki Kawajiri',1950),
('Richard Kelly',1975),
('Irvin Kershner',1923),
('Yoshifumi Kondô',1950),
('Harry Kümel',1940),
('Pablo Larraín',1976),
('Mitchell Leisen',1898),
('David Leland',1941),
('Kenneth Lonergan',1962),
('Peter Lord',1953),
('Ida Lupino',1918),
('Gustav Machatý',1901),
('Károly Makk',1925),
('James Mangold',1963),
('George Marshall',1891),
('John Maybury',1900),
('Melodie McDaniel',1900),
('Julio Medem',1958),
('William Cameron Menzies',1896),
('Nicholas Meyer',1945),
('Carol Morley',1966),
('Emil Nava',1985),
('Jean Negulesco',1900),
('Chris Newby',1900),
('Mike Nichols',1931),
('Phillip Noyce',1950),
('Idrissa Ouedraogo',1954),
('Horace Ové',1900),
('Mark Pellington',1962),
('Jesse Peretz',1900),
('John Pilger',1939),
('Sally Potter',1949),
('Johan Renck',1966),
('Hans Richter',1888),
('Robert Rodriguez',1968),
('Robert Rossen',1908),
('Franklin J. Schaffner',1920),
('Jake Scott',1900),
('Edward Sedgwick',1892),
('Floria Sigismondi',1900),
('Jean-Marie Straub',1933),
('Peter Strickland',1900),
('Jamie Thraves',1900),
('Charles Vidor',1900),
('Terence Young',1915),
('Hany Abu-Assad',1961),
('Masao Adachi',1939),
('Mathieu Amalric',1965),
('Ana Lily Amirpour',1976),
('Asia Argento',1975),
('Gabriel Axel',1918),
('Richard Ayoade',1977),
('Lloyd Bacon',1889),
('Roy Ward Baker',1916),
('Noah Baumbach',1969),
('Hugo Blick',1900),
('James Brown',1900),
('Kate Bush',1958),
('Robert Clampett',1913),
('Jem Cohen',1900),
('Mark Cousins',1965),
('Michael Cuesta',1963),
('John Curran',1960),
('Delmer Daves',1904),
('Jay Duplass',1973),
('Ryan Fleck',1976),
('Victor Fleming',1889),
('Hugo Fregonese',1908),
('Tay Garnett',1894),
('Sarah Gavron',1900),
('Lewis Gilbert',1920),
('Andrew Haigh',1973),
('Jessica Hausner',1972),
('Ishirô Honda',1911),
('Ben Hopkins',1900),
('John Hughes',1950),
('Peter Hyams',1943),
('Ivan Ivanov-Vano',1900),
('Julian Jarrold',1960),
('Humphrey Jennings',1907),
('Cédric Kahn',1966),
('William Keighley',1889),
('Andrey Konchalovskiy',1937),
('Andrew Kotting',1958),
('Jae-young Kwak',1959),
('John Lasseter',1957),
('Je-yong Lee',1900),
('Rowland V. Lee',1891),
('Michael Lehmann',1957),
('Joseph Kahn',1972),
('Shouji Kawamori',1960),
('Mat Kirkby',1900),
('Alexander Korda',1893),
('David Michôd',1900),
('Bennett Miller',1966),
('Anthony Minghella',1954),
('Dudley Murphy',1897),
('Masashi Muto',1900),
('Manoel de Oliveira',1908),
('Laurence Olivier',1907),
('Max Ophüls',1902),
('Georg Wilhelm Pabst',1885),
('Oxide Chun Pang',1900),
('Paco Plaza',1900),
('Bob Rafelson',1933),
('Jean-Paul Rappeneau',1932),
('Robert Redford',1936),
('Karel Reisz',1926),
('Jason Reitman',1977),
('Herb Ritts',1952),
('Mark Robson',1913),
('Alice Rohrwacher',1900),
('Michaël R. Roskam',1972),
('Eli Roth',1972),
('Zbigniew Rybczynski',1949),
('Stuart Samuels',1940),
('Esteban Sapir',1967),
('Peter Sasdy',1935),
('Carlos Saura',1932),
('Fred Schepisi',1939),
('Swinton O. Scott III',1956),
('Henry Selick',1952),
('Menelik Shabazz',1954),
('Ron Shelton',1945),
('Adrian Shergold',1948),
('Jim Sheridan',1949),
('Makoto Shinkai',1973),
('George Sidney',1916),
('Tarsem Singh',1961),
('John Singleton',1968),
('Bruce Sinofsky',1956),
('Zack Snyder',1966),
('Michele Soavi',1957),
('Ben Stiller',1965),
('Whit Stillman',1952),
('Joseph Strick',1923),
('Jamie Uys',1921),
('Matthew Vaughn',1971),
('Lana Wachowski',1965),
('Taika Waititi',1975),
('Baillie Walsh',1900),
('Albert Watson',1900),
('Monty Whitebloom',1900),
('WIZ Andrew John Whiston',1900),
('Peter Yates',1929),
('Shinji Aoyama',1964),
('Andrea Arnold',1961),
('Rodney Ascher',1900),
('Peter Avanzino',1900),
('John G. Avildsen',1935),
('David Ayer',1968),
('Drew Barrymore',1975),
('Ritesh Batra',1979),
('Bruce Beresford',1940),
('Amy Berg',1900),
('Busby Berkeley',1895),
('Fabián Bielinsky',1959),
('Christoffer Boe',1974),
('John Brahm',1893),
('Sarah Burns',1900),
('Adam Buxton',1969),
('Peter Care',1900),
('Christian Carion',1963),
('Siu-Tung Ching',1900),
('Barry Cook',1958),
('Roman Coppola',1965),
('Catherine Corsini',1956),
('Vondie Curtis-Hall',1950),
('Patrick Daughters',1900),
('Jonathan Dayton',1957),
('Rolf de Heer',1951),
('Walt Disney',1901),
('Julien Duvivier',1896),
('Jean Eustache',1938),
('Philippe Falardeau',1968),
('Saam Farahmand',1900),
('Bryan Forbes',1926),
('Carl Franklin',1949),
('Liz Friedlander',1970),
('Philippe Garrel',1948),
('Romain Gavras',1981),
('Florian Habicht',1900),
('Don Hall',1969),
('Robert Hamer',1911),
('Mia Hansen-Løve',1981),
('Curtis Hanson',1945),
('Robert Harmon',1900),
('Mary Harron',1953),
('Yasuharu Hasebe',1932),
('Sean Hogan',1900),
('Joel Hopkins',1970),
('Paul Hunter',1900),
('Ub Iwerks',1901),
('Tamara Jenkins',1962),
('Pavel Jurácek',1935),
('Je-kyu Kang',1962),
('Garson Kanin',1912),
('Jonathan Kaplan',1947),
('Naomi Kawase',1969),
('Paul King',1900),
('Damian Kulash',1975),
('Jeffrey Lau',1900),
('Chia-Liang Liu',1936),
('Saxon Logan',1900),
('Kátia Lund',1900),
('Elaine May',1932),
('Jim McBride',1941),
('Winsor McCay',1871),
('John McNaughton',1950),
('Megaforce',1900),
('Fernando Meirelles',1955),
('Sidney Meyers',1906),
('Dominik Moll',1962),
('Robert Montgomery',1904),
('Nobuo Nakagawa',1905),
('Yoshihiro Nakamura',1900),
('Mark Osborne',1970),
('Ron Peck',1900),
('D.A. Pennebaker',1925),
('Joseph Pevney',1911),
('Rafi Pitts',1900),
('Michael Polish',1970),
('Edwin S. Porter',1870),
('Lucía Puenzo',1976),
('Cristi Puiu',1967),
('Pen-Ek Ratanaruang',1900),
('Lotte Reiniger',1899),
('Jean-François Richet',1966),
('Rihanna',1988),
('Guy Ritchie',1968),
('Rick Rosenthal',1949),
('Joseph Sargent',1925),
('Ettore Scola',1931),
('Stephane Sednaoui',1900),
('Gary Sherman',1900),
('Kaneto Shindô',1912),
('Noboru Tanaka',1937),
('Paolo Taviani',1931),
('Rhys Thomas',1978),
('Nora Twomey',1971),
('Ron Underwood',1953),
('Gregg Vanzo',1961),
('Chris Williams',1968),
('Hiromasa Yonebayashi',1973),
('Edward Zwick',1952),
('Jonas Åkerlund',1965),
('Lewis Allen',1905),
('Joey Ansah',1982),
('Gregg Araki',1959),
('Jacques Audiard',1952),
('Ramin Bahrani',1975),
('Ralph Bakshi',1938),
('Richard Benjamin',1938),
('Robert Benton',1932),
('Sanjay Leela Bhansali',1963),
('Serge Bromberg',1961),
('Clyde Bruckman',1894),
('James L. Brooks',1940),
('Henry Cass',1903),
('William Castle',1914),
('Michael Cimino',1939),
('Chris Cottam',1973),
('William Eubank',1900),
('Peter Farrelly',1956),
('John Farrow',1904),
('Jon Favreau',1966),
('Paul Fedor',1900),
('Dexter Fletcher',1966),
('Alex Garland',1970),
('Lesli Linka Glatter',1953),
('Michael Gordon',1909),
('F. Gary Gray',1969),
('Brian Griffin',1900),
('James Gunn',1966),
('Curtis Harrington',1926),
('Dominic Hawley',1900),
('Joern Heitmann',1900),
('Ludovic Houplain',1900),
('Tim Hunter',1947),
('Im Sang-soo',1962),
('Rex Ingram',1892),
('Gakuryû Ishii',1957),
('Anders Thomas Jensen',1972),
('Norman Jewison',1926),
('Paul Johnson',1900),
('Rian Johnson',1973),
('Dean Karr',1900),
('Tom Kingsley',1900),
('Tim Kirkby',1970),
('Tom Kuntz',1900),
('René Laloux',1929),
('Kyoung Hee Lim',1900),
('Niall MacCormick',1900),
('John Mackenzie',1928),
('Gillies MacKinnon',1948),
('Alan Mak',1965),
('Craig McCracken',1971),
('Bruce McDonald',1959),
('Scott McGehee',1900),
('Andrew V. McLaglen',1920),
('Peter Medak',1937),
('David Miller',1909),
('Jonathan Miller',1934),
('Rob Minkoff',1962),
('Jean-Baptiste Mondino',1949),
('Anders Morgenthaler',1972),
('Andrew Niccol',1964),
('Marcus Nispel',1963),
('Sean Penn',1960),
('Louis Pepe',1966),
('Tony Petrossian',1900),
('Jindrich Polák',1925),
('John Rice',1900),
('Chris Robinson',1900),
('Stuart Rosenberg',1927),
('Herbert Ross',1927),
('Anthony Russo',1970),
('Gene Saks',1921),
('Jan Schmidt',1934),
('Henry Scholfield',1900),
('Jeffrey Schwarz',1969),
('Peter Graham Scott',1923),
('Dawn Shadforth',1900),
('Brian Sheesley',1967),
('Shynola',1900),
('David Slade',1969),
('George Albert Smith',1864),
('Michal Socha',1900),
('Paolo Sorrentino',1970),
('Yôjirô Takita',1955),
('Julien Temple',1953),
('Colin Tilley',1900),
('Traktor',1900),
('Tom Tykwer',1965),
('Marina de Van',1971),
('Paul Verhoeven',1938),
('Nacho Vigalondo',1900),
('Andrucha Waddington',1970),
('Ben Wheatley',1900),
('Hype Williams',1900),
('Sam Wood',1883),
('Joe Wright',1972),
('Wilson Yip',1900),
('Rob Zombie',1965),
('Andrzej Zulawski',1940);
INSERT INTO movies (title,"year",director,budget,gross)
SELECT i.*
FROM (VALUES 
('Guardians of the Galaxy',2014,'James Gunn',246000000,333130000),
('Prometheus',2012,'Ridley Scott',296000000,126460000),
('Split',2016,'M. Night Shyamalan',611000000,138120000),
('Sing',2016,'Christophe Lourdelet',791000000,270320000),
('Suicide Squad',2016,'David Ayer',221000000,325020000),
('The Great Wall',2016,'Yimou Zhang',976000000,45130000),
('La La Land',2016,'Damien Chazelle',986000000,151060000),
('Mindhorn',2016,'Sean Foley',811000000,0),
('The Lost City of Z',2016,'James Gray',991000000,8010000),
('Passengers',2016,'Morten Tyldum',451000000,100010000),
('Fantastic Beasts and Where to Find Them',2016,'David Yates',846000000,234020000),
('Hidden Figures',2016,'Theodore Melfi',681000000,169270000),
('Rogue One',2016,'Gareth Edwards',226000000,532170000),
('Moana',2016,'Ron Clements',981000000,248750000),
('Colossal',2016,'Nacho Vigalondo',236000000,2870000),
('The Secret Life of Pets',2016,'Chris Renaud',581000000,368310000),
('Hacksaw Ridge',2016,'Mel Gibson',561000000,67120000),
('Jason Bourne',2016,'Paul Greengrass',976000000,162160000),
('Lion',2016,'Garth Davis',806000000,51690000),
('Arrival',2016,'Denis Villeneuve',511000000,100500000),
('Gold',2016,'Stephen Gaghan',311000000,7220000),
('Manchester by the Sea',2016,'Kenneth Lonergan',896000000,47700000),
('Hounds of Love',2016,'Ben Young',236000000,0),
('Trolls',2016,'Walt Dohrn',26000000,153690000),
('Independence Day: Resurgence',2016,'Roland Emmerich',791000000,103140000),
('Paris pieds nus',2016,'Dominique Abel',191000000,0),
('Bahubali: The Beginning',2015,'S.S. Rajamouli',596000000,6500000),
('Dead Awake',2016,'Phillip Guzman',541000000,10000),
('Bad Moms',2016,'Jon Lucas',26000000,113080000),
('Assassin''s Creed',2016,'Justin Kurzel',771000000,54650000),
('Why Him?',2016,'John Hamburg',966000000,60310000),
('Nocturnal Animals',2016,'Tom Ford',461000000,10640000),
('X-Men: Apocalypse',2016,'Bryan Singer',291000000,155330000),
('Deadpool',2016,'Tim Miller',681000000,363020000),
('Resident Evil: The Final Chapter',2016,'Paul W.S. Anderson',641000000,26840000),
('Captain America: Civil War',2016,'Anthony Russo',801000000,408080000),
('Interstellar',2014,'Christopher Nolan',926000000,187990000),
('Doctor Strange',2016,'Scott Derrickson',996000000,232600000),
('The Magnificent Seven',2016,'Antoine Fuqua',551000000,93380000),
('5/25/1977',2007,'Patrick Read Johnson',986000000,0),
('Sausage Party',2016,'Greg Tiernan',406000000,97660000),
('Moonlight',2016,'Barry Jenkins',851000000,27850000),
('Don''t Fuck in the Woods',2016,'Shawn Burkett',126000000,0),
('The Founder',2016,'John Lee Hancock',246000000,12790000),
('Lowriders',2016,'Ricardo de Montreuil',121000000,4210000),
('Pirates of the Caribbean: On Stranger Tides',2011,'Rob Marshall',61000000,241060000),
('Miss Sloane',2016,'John Madden',736000000,3440000),
('Fallen',2016,'Scott Hicks',986000000,0),
('Star Trek Beyond',2016,'Justin Lin',931000000,158800000),
('The Last Face',2016,'Sean Penn',976000000,0),
('Star Wars: Episode VII - The Force Awakens',2015,'J.J. Abrams',461000000,936630000),
('Underworld: Blood Wars',2016,'Anna Foerster',896000000,30350000),
('Mother''s Day',2016,'Garry Marshall',451000000,32460000),
('John Wick',2014,'Chad Stahelski',161000000,43000000),
('The Dark Knight',2008,'Christopher Nolan',111000000,533320000),
('Silence',2016,'Martin Scorsese',811000000,7080000),
('Don''t Breathe',2016,'Fede Alvarez',256000000,89210000),
('Me Before You',2016,'Thea Sharrock',986000000,56230000),
('Their Finest',2016,'Lone Scherfig',496000000,3180000),
('Sully',2016,'Clint Eastwood',516000000,125070000),
('Batman v Superman: Dawn of Justice',2016,'Zack Snyder',806000000,330250000),
('The Autopsy of Jane Doe',2016,'André Øvredal',876000000,0),
('The Girl on the Train',2016,'Tate Taylor',721000000,75310000),
('Fifty Shades of Grey',2015,'Sam Taylor-Johnson',576000000,166150000),
('The Prestige',2006,'Christopher Nolan',241000000,53080000),
('Kingsman: The Secret Service',2014,'Matthew Vaughn',371000000,128250000),
('Patriots Day',2016,'Peter Berg',706000000,31860000),
('Mad Max: Fury Road',2015,'George Miller',531000000,153630000),
('Wakefield',2016,'Robin Swicord',236000000,10000),
('Deepwater Horizon',2016,'Peter Berg',576000000,61280000),
('The Promise',2016,'Terry George',266000000,0),
('Allied',2016,'Robert Zemeckis',751000000,40070000),
('A Monster Calls',2016,'J.A. Bayona',431000000,3730000),
('Collateral Beauty',2016,'David Frankel',121000000,30980000),
('Zootopia',2016,'Byron Howard',636000000,341260000),
('Pirates of the Caribbean: At World''s End',2007,'Gore Verbinski',621000000,309400000),
('The Avengers',2012,'Joss Whedon',16000000,623280000),
('Inglourious Basterds',2009,'Quentin Tarantino',981000000,120520000),
('Pirates of the Caribbean: Dead Man''s Chest',2006,'Gore Verbinski',91000000,423030000),
('Ghostbusters',2016,'Paul Feig',721000000,128340000),
('Inception',2010,'Christopher Nolan',581000000,292570000),
('Captain Fantastic',2016,'Matt Ross',551000000,5880000),
('The Wolf of Wall Street',2013,'Martin Scorsese',236000000,116870000),
('Gone Girl',2014,'David Fincher',101000000,167740000),
('Furious Seven',2015,'James Wan',46000000,350030000),
('Jurassic World',2015,'Colin Trevorrow',846000000,652180000),
('Live by Night',2016,'Ben Affleck',61000000,10380000),
('Avatar',2009,'James Cameron',811000000,760510000),
('The Hateful Eight',2015,'Quentin Tarantino',131000000,54120000),
('The Accountant',2016,'Gavin O''Connor',996000000,86200000),
('Prisoners',2013,'Denis Villeneuve',906000000,60960000),
('Warcraft',2016,'Duncan Jones',16000000,47170000),
('The Help',2011,'Tate Taylor',346000000,169710000),
('War Dogs',2016,'Todd Phillips',756000000,43020000),
('Avengers: Age of Ultron',2015,'Joss Whedon',546000000,458990000),
('The Nice Guys',2016,'Shane Black',691000000,36250000),
('Kimi no na wa',2016,'Makoto Shinkai',546000000,4680000),
('The Void',2016,'Jeremy Gillespie',506000000,150000),
('Personal Shopper',2016,'Olivier Assayas',6000000,1290000),
('The Departed',2006,'Martin Scorsese',791000000,132370000),
('Legend',2015,'Brian Helgeland',581000000,1870000),
('Thor',2011,'Kenneth Branagh',136000000,181020000),
('The Martian',2015,'Ridley Scott',101000000,228430000),
('Contratiempo',2016,'Oriol Paulo',461000000,0),
('The Man from U.N.C.L.E.',2015,'Guy Ritchie',651000000,45430000),
('Hell or High Water',2016,'David Mackenzie',166000000,26860000),
('The Comedian',2016,'Taylor Hackford',681000000,1660000),
('The Legend of Tarzan',2016,'David Yates',201000000,126590000),
('All We Had',2016,'Katie Holmes',86000000,0),
('Ex Machina',2014,'Alex Garland',271000000,25440000),
('The Belko Experiment',2016,'Greg McLean',796000000,10160000),
('12 Years a Slave',2013,'Steve McQueen',381000000,56670000),
('The Bad Batch',2016,'Ana Lily Amirpour',116000000,0),
('300',2006,'Zack Snyder',316000000,210590000),
('Harry Potter and the Deathly Hallows: Part 2',2011,'David Yates',741000000,380960000),
('Office Christmas Party',2016,'Josh Gordon',411000000,54730000),
('The Neon Demon',2016,'Nicolas Winding Refn',51000000,1330000),
('Dangal',2016,'Nitesh Tiwari',911000000,11150000),
('10 Cloverfield Lane',2016,'Dan Trachtenberg',196000000,71900000),
('Finding Dory',2016,'Andrew Stanton',906000000,486290000),
('Miss Peregrine''s Home for Peculiar Children',2016,'Tim Burton',966000000,87240000),
('Divergent',2014,'Neil Burger',996000000,150830000),
('Mike and Dave Need Wedding Dates',2016,'Jake Szymanski',731000000,46010000),
('Boyka: Undisputed IV',2016,'Todor Chapkanov',71000000,0),
('The Dark Knight Rises',2012,'Christopher Nolan',476000000,448130000),
('The Jungle Book',2016,'Jon Favreau',591000000,364000000),
('Transformers: Age of Extinction',2014,'Michael Bay',711000000,245430000),
('Nerve',2016,'Henry Joost',476000000,38560000),
('Mamma Mia!',2008,'Phyllida Lloyd',671000000,143700000),
('The Revenant',2015,'Alejandro González Iñárritu',516000000,183640000),
('Fences',2016,'Denzel Washington',761000000,57640000),
('Into the Woods',2014,'Rob Marshall',101000000,128000000),
('The Shallows',2016,'Jaume Collet-Serra',106000000,55120000),
('Whiplash',2014,'Damien Chazelle',516000000,13090000),
('Furious 6',2013,'Justin Lin',71000000,238670000),
('The Place Beyond the Pines',2012,'Derek Cianfrance',11000000,21380000),
('No Country for Old Men',2007,'Ethan Coen',966000000,74270000),
('The Great Gatsby',2013,'Baz Luhrmann',606000000,144810000),
('Shutter Island',2010,'Martin Scorsese',861000000,127970000),
('Brimstone',2016,'Martin Koolhoven',606000000,0),
('Star Trek',2009,'J.J. Abrams',346000000,257700000),
('Diary of a Wimpy Kid',2010,'Thor Freudenthal',906000000,64000000),
('The Big Short',2015,'Adam McKay',716000000,70240000),
('Room',2015,'Lenny Abrahamson',421000000,14680000),
('Django Unchained',2012,'Quentin Tarantino',556000000,162800000),
('Ah-ga-ssi',2016,'Chan-wook Park',1000000,2010000),
('The Edge of Seventeen',2016,'Kelly Fremon Craig',496000000,14260000),
('Watchmen',2009,'Zack Snyder',96000000,107500000),
('Superbad',2007,'Greg Mottola',251000000,121460000),
('Inferno',2016,'Ron Howard',431000000,34260000),
('The BFG',2016,'Steven Spielberg',601000000,55470000),
('The Hunger Games',2012,'Gary Ross',721000000,408000000),
('White Girl',2016,'Elizabeth Wood',761000000,200000),
('Sicario',2015,'Denis Villeneuve',306000000,46880000),
('Twin Peaks: The Missing Pieces',2014,'David Lynch',421000000,0),
('Aliens vs Predator - Requiem',2007,'Colin Strause',336000000,41800000),
('Pacific Rim',2013,'Guillermo del Toro',346000000,101790000),
('Crazy, Stupid, Love.',2011,'Glenn Ficarra',206000000,84240000),
('Scott Pilgrim vs. the World',2010,'Edgar Wright',181000000,31490000),
('Hot Fuzz',2007,'Edgar Wright',466000000,23620000),
('Mine',2016,'Fabio Guaglione',821000000,0),
('Free Fire',2016,'Ben Wheatley',856000000,1800000),
('X-Men: Days of Future Past',2014,'Bryan Singer',341000000,233910000),
('Jack Reacher: Never Go Back',2016,'Edward Zwick',111000000,58400000),
('Casino Royale',2006,'Martin Campbell',76000000,167010000),
('Twilight',2008,'Catherine Hardwicke',921000000,191450000),
('Now You See Me 2',2016,'Jon M. Chu',326000000,65030000),
('Woman in Gold',2015,'Simon Curtis',801000000,33310000),
('13 Hours',2016,'Michael Bay',751000000,52820000),
('Spectre',2015,'Sam Mendes',766000000,200070000),
('Nightcrawler',2014,'Dan Gilroy',681000000,32280000),
('Kubo and the Two Strings',2016,'Travis Knight',1000000,48020000),
('Beyond the Gates',2016,'Jackson Stewart',506000000,0),
('Her',2013,'Spike Jonze',566000000,25560000),
('Frozen',2013,'Chris Buck',141000000,400740000),
('Tomorrowland',2015,'Brad Bird',371000000,93420000),
('Dawn of the Planet of the Apes',2014,'Matt Reeves',821000000,208540000),
('Tropic Thunder',2008,'Ben Stiller',346000000,110420000),
('The Conjuring 2',2016,'James Wan',716000000,102460000),
('Ant-Man',2015,'Peyton Reed',991000000,180190000),
('Bridget Jones''s Baby',2016,'Sharon Maguire',356000000,24090000),
('The VVitch: A New-England Folktale',2015,'Robert Eggers',646000000,25140000),
('Cinderella',2015,'Kenneth Branagh',826000000,201150000),
('Realive',2016,'Mateo Gil',191000000,0),
('Forushande',2016,'Asghar Farhadi',41000000,3400000),
('Love',2015,'Gaspar Noé',571000000,0),
('Billy Lynn''s Long Halftime Walk',2016,'Ang Lee',681000000,1720000),
('Crimson Peak',2015,'Guillermo del Toro',61000000,31060000),
('Drive',2011,'Nicolas Winding Refn',56000000,35050000),
('Trainwreck',2015,'Judd Apatow',601000000,110010000),
('The Light Between Oceans',2016,'Derek Cianfrance',866000000,12530000),
('Below Her Mouth',2016,'April Mullen',176000000,0),
('Spotlight',2015,'Tom McCarthy',76000000,44990000),
('Morgan',2016,'Luke Scott',356000000,3910000),
('Warrior',2011,'Gavin O''Connor',436000000,13650000),
('Captain America: The First Avenger',2011,'Joe Johnston',951000000,176640000),
('Hacker',2016,'Akan Satayev',461000000,0),
('Into the Wild',2007,'Sean Penn',66000000,18350000),
('The Imitation Game',2014,'Morten Tyldum',591000000,91120000),
('Central Intelligence',2016,'Rawson Marshall Thurber',681000000,127380000),
('Edge of Tomorrow',2014,'Doug Liman',926000000,100190000),
('A Cure for Wellness',2016,'Gore Verbinski',731000000,8100000),
('Snowden',2016,'Oliver Stone',241000000,21480000),
('Iron Man',2008,'Jon Favreau',466000000,318300000),
('Allegiant',2016,'Robert Schwentke',851000000,66000000),
('X: First Class',2011,'Matthew Vaughn',361000000,146410000),
('Raw (II)',2016,'Julia Ducournau',266000000,510000),
('Paterson',2016,'Jim Jarmusch',341000000,2140000),
('Bridesmaids',2011,'Paul Feig',261000000,169080000),
('The Girl with All the Gifts',2016,'Colm McCarthy',651000000,0),
('San Andreas',2015,'Brad Peyton',711000000,155180000),
('Spring Breakers',2012,'Harmony Korine',576000000,14120000),
('Transformers',2007,'Michael Bay',686000000,318760000),
('Old Boy',2013,'Spike Lee',516000000,0),
('Thor: The Dark World',2013,'Alan Taylor',726000000,206360000),
('Gods of Egypt',2016,'Alex Proyas',681000000,31140000),
('Captain America: The Winter Soldier',2014,'Anthony Russo',536000000,259750000),
('Monster Trucks',2016,'Chris Wedge',121000000,33040000),
('A Dark Song',2016,'Liam Gavin',671000000,0),
('Kick-Ass',2010,'Matthew Vaughn',356000000,48040000),
('Hardcore Henry',2015,'Ilya Naishuller',531000000,9240000),
('Cars',2006,'John Lasseter',26000000,244050000),
('It Follows',2014,'David Robert Mitchell',886000000,14670000),
('The Girl with the Dragon Tattoo',2011,'David Fincher',876000000,102520000),
('We''re the Millers',2013,'Rawson Marshall Thurber',556000000,150370000),
('American Honey',2016,'Andrea Arnold',521000000,660000),
('The Lobster',2015,'Yorgos Lanthimos',846000000,8700000),
('Predators',2010,'Nimród Antal',816000000,52000000),
('Maleficent',2014,'Robert Stromberg',866000000,241410000),
('Rupture',2016,'Steven Shainberg',576000000,0),
('Pan''s Labyrinth',2006,'Guillermo del Toro',996000000,37620000),
('A Kind of Murder',2016,'Andy Goddard',356000000,0),
('Apocalypto',2006,'Mel Gibson',511000000,50860000),
('Mission: Impossible - Rogue Nation',2015,'Christopher McQuarrie',931000000,195000000),
('The Huntsman: Winter''s War',2016,'Cedric Nicolas-Troyan',116000000,47950000),
('The Perks of Being a Wallflower',2012,'Stephen Chbosky',731000000,17740000),
('Jackie',2016,'Pablo Larraín',66000000,13960000),
('The Disappointments Room',2016,'D.J. Caruso',961000000,2410000),
('The Grand Budapest Hotel',2014,'Wes Anderson',121000000,59070000),
('The Host',2013,'Andrew Niccol',481000000,26620000),
('Fury',2014,'David Ayer',451000000,85710000),
('Inside Out',2015,'Pete Docter',526000000,356450000),
('Rock Dog',2016,'Ash Brannon',206000000,9400000),
('Terminator Genisys',2015,'Alan Taylor',171000000,89730000),
('Percy Jackson & the Olympians: The Lightning Thief',2010,'Chris Columbus',431000000,88760000),
('Les Misérables',2012,'Tom Hooper',66000000,148780000),
('Children of Men',2006,'Alfonso Cuarón',416000000,35290000),
('20th Century Women',2016,'Mike Mills',846000000,5660000),
('Spy',2015,'Paul Feig',691000000,110820000),
('The Intouchables',2011,'Olivier Nakache',86000000,13180000),
('Bonjour Anne',2016,'Eleanor Coppola',526000000,320000),
('Kynodontas',2009,'Yorgos Lanthimos',131000000,110000),
('Straight Outta Compton',2015,'F. Gary Gray',671000000,161030000),
('The Amazing Spider-Man 2',2014,'Marc Webb',241000000,202850000),
('The Conjuring',2013,'James Wan',601000000,137390000),
('The Hangover',2009,'Todd Phillips',936000000,277310000),
('Battleship',2012,'Peter Berg',81000000,65170000),
('Rise of the Planet of the Apes',2011,'Rupert Wyatt',791000000,176740000),
('Lights Out',2016,'David F. Sandberg',536000000,67240000),
('Norman: The Moderate Rise and Tragic Fall of a New York Fixer',2016,'Joseph Cedar',291000000,2270000),
('Birdman or (The Unexpected Virtue of Ignorance)',2014,'Alejandro González Iñárritu',621000000,42340000),
('Black Swan',2010,'Darren Aronofsky',146000000,106950000),
('Dear White People',2014,'Justin Simien',701000000,4400000),
('Nymphomaniac: Vol. I',2013,'Lars von Trier',671000000,790000),
('Teenage Mutant Ninja Turtles: Out of the Shadows',2016,'Dave Green',51000000,540000),
('Knock Knock',2015,'Eli Roth',276000000,30000),
('Dirty Grandpa',2016,'Dan Mazer',266000000,35540000),
('Cloud Atlas',2012,'Tom Tykwer',586000000,27100000),
('X-Men Origins: Wolverine',2009,'Gavin Hood',826000000,179880000),
('Satanic',2016,'Jeffrey G. Hunt',286000000,0),
('Skyfall',2012,'Sam Mendes',311000000,304360000),
('The Hobbit: An Unexpected Journey',2012,'Peter Jackson',486000000,303000000),
('21 Jump Street',2012,'Phil Lord',41000000,138450000),
('Sing Street',2016,'John Carney',536000000,3230000),
('Ballerina',2016,'Eric Summer',331000000,0),
('Oblivion',2013,'Joseph Kosinski',976000000,89020000),
('22 Jump Street',2014,'Phil Lord',876000000,191620000),
('Zodiac',2007,'David Fincher',236000000,33050000),
('Everybody Wants Some!!',2016,'Richard Linklater',86000000,3370000),
('Iron Man Three',2013,'Shane Black',596000000,408990000),
('Now You See Me',2013,'Louis Leterrier',311000000,117700000),
('Sherlock Holmes',2009,'Guy Ritchie',291000000,209020000),
('Death Proof',2007,'Quentin Tarantino',151000000,0),
('The Danish Girl',2015,'Tom Hooper',581000000,12710000),
('Hercules',2014,'Brett Ratner',746000000,72660000),
('Sucker Punch',2011,'Zack Snyder',941000000,36380000),
('Keeping Up with the Joneses',2016,'Greg Mottola',166000000,14900000),
('Jupiter Ascending',2015,'Lana Wachowski',21000000,47380000),
('Masterminds',2016,'Jared Hess',756000000,17360000),
('Iris',2016,'Jalil Lespert',791000000,0),
('Busanhaeng',2016,'Sang-ho Yeon',296000000,2130000),
('Pitch Perfect',2012,'Jason Moore',831000000,65000000),
('Neighbors 2: Sorority Rising',2016,'Nicholas Stoller',161000000,55290000),
('The Exception',2016,'David Leveaux',606000000,0),
('Man of Steel',2013,'Zack Snyder',126000000,291020000),
('The Choice',2016,'Ross Katz',21000000,18710000),
('Ice Age: Collision Course',2016,'Mike Thurmeier',946000000,64060000),
('The Devil Wears Prada',2006,'David Frankel',341000000,124730000),
('The Infiltrator',2016,'Brad Furman',456000000,15430000),
('There Will Be Blood',2007,'Paul Thomas Anderson',351000000,40220000),
('The Equalizer',2014,'Antoine Fuqua',751000000,101530000),
('Lone Survivor',2013,'Peter Berg',266000000,125070000),
('The Cabin in the Woods',2012,'Drew Goddard',481000000,42040000),
('The House Bunny',2008,'Fred Wolf',676000000,48240000),
('She''s Out of My League',2010,'Jim Field Smith',316000000,31580000),
('Inherent Vice',2014,'Paul Thomas Anderson',791000000,8090000),
('Alice Through the Looking Glass',2016,'James Bobin',996000000,77040000),
('Vincent N Roxxy',2016,'Gary Michael Schultz',386000000,0),
('The Fast and the Furious: Tokyo Drift',2006,'Justin Lin',291000000,62490000),
('How to Be Single',2016,'Christian Ditter',976000000,46810000),
('The Blind Side',2009,'John Lee Hancock',931000000,255950000),
('La vie d''Adèle',2013,'Abdellatif Kechiche',196000000,2200000),
('The Babadook',2014,'Jennifer Kent',6000000,920000),
('The Hobbit: The Battle of the Five Armies',2014,'Peter Jackson',251000000,255110000),
('Harry Potter and the Order of the Phoenix',2007,'David Yates',261000000,292000000),
('Snowpiercer',2013,'Bong Joon Ho',326000000,4560000),
('The 5th Wave',2016,'J Blakeson',146000000,34910000),
('The Stakelander',2016,'Dan Berk',206000000,0),
('The Visit',2015,'M. Night Shyamalan',601000000,65070000),
('Fast Five',2011,'Justin Lin',871000000,209810000),
('Step Up',2006,'Anne Fletcher',456000000,65270000),
('Lovesong',2016,'So Yong Kim',806000000,10000),
('RocknRolla',2008,'Guy Ritchie',291000000,5690000),
('In Time',2011,'Andrew Niccol',81000000,37550000),
('The Social Network',2010,'David Fincher',936000000,96920000),
('The Last Witch Hunter',2015,'Breck Eisner',61000000,27360000),
('Victor Frankenstein',2015,'Paul McGuigan',276000000,5770000),
('A Street Cat Named Bob',2016,'Roger Spottiswoode',316000000,40000),
('Green Room',2015,'Jeremy Saulnier',506000000,3220000),
('Blackhat',2015,'Michael Mann',466000000,7100000),
('Storks',2016,'Nicholas Stoller',766000000,72660000),
('American Sniper',2014,'Clint Eastwood',761000000,350120000),
('Dallas Buyers Club',2013,'Jean-Marc Vallée',726000000,27300000),
('Lincoln',2012,'Steven Spielberg',331000000,182200000),
('Rush',2013,'Ron Howard',286000000,26900000),
('Before I Wake',2016,'Mike Flanagan',161000000,0),
('Silver Linings Playbook',2012,'David O. Russell',856000000,132090000),
('Tracktown',2016,'Alexi Pappas',971000000,0),
('The Fault in Our Stars',2014,'Josh Boone',666000000,124870000),
('Blended',2014,'Frank Coraci',191000000,46280000),
('Fast & Furious',2009,'Justin Lin',591000000,155020000),
('Looper',2012,'Rian Johnson',571000000,66470000),
('White House Down',2013,'Roland Emmerich',256000000,73100000),
('Pete''s Dragon',2016,'David Lowery',171000000,76200000),
('Spider-Man 3',2007,'Sam Raimi',486000000,336530000),
('The Three Musketeers',2011,'Paul W.S. Anderson',671000000,20320000),
('Stardust',2007,'Matthew Vaughn',431000000,38350000),
('American Hustle',2013,'David O. Russell',511000000,150120000),
('Jennifer''s Body',2009,'Karyn Kusama',586000000,16200000),
('Midnight in Paris',2011,'Woody Allen',681000000,56820000),
('Lady Macbeth',2016,'William Oldroyd',781000000,0),
('Joy',2015,'David O. Russell',921000000,56440000),
('The Dressmaker',2015,'Jocelyn Moorhouse',996000000,2020000),
('Cafe Society',2016,'Woody Allen',466000000,11080000),
('Insurgent',2015,'Robert Schwentke',556000000,130000000),
('Seventh Son',2014,'Sergei Bodrov',521000000,17180000),
('Demain tout commence',2016,'Hugo Gélin',221000000,0),
('The Theory of Everything',2014,'James Marsh',396000000,35890000),
('This Is the End',2013,'Evan Goldberg',141000000,101470000),
('About Time',2013,'Richard Curtis',1000000,15290000),
('Step Brothers',2008,'Adam McKay',496000000,100470000),
('Clown',2014,'Jon Watts',846000000,50000),
('Star Trek Into Darkness',2013,'J.J. Abrams',396000000,228760000),
('Zombieland',2009,'Ruben Fleischer',186000000,75590000),
('Hail, Caesar!',2016,'Ethan Coen',211000000,30000000),
('Slumdog Millionaire',2008,'Danny Boyle',76000000,141320000),
('The Twilight Saga: Breaking Dawn - Part 2',2012,'Bill Condon',266000000,292300000),
('American Wrestler: The Wizard',2016,'Alex Ranarivelo',861000000,0),
('The Amazing Spider-Man',2012,'Marc Webb',511000000,262030000),
('Ben-Hur',2016,'Timur Bekmambetov',821000000,26380000),
('Sleight',2016,'J.D. Dillard',591000000,3850000),
('The Maze Runner',2014,'Wes Ball',191000000,102410000),
('Criminal',2016,'Ariel Vromen',686000000,14270000),
('Wanted',2008,'Timur Bekmambetov',986000000,134570000),
('Florence Foster Jenkins',2016,'Stephen Frears',446000000,27370000),
('Collide',2016,'Eran Creevy',201000000,2200000),
('Black Mass',2015,'Scott Cooper',1000000,62560000),
('Creed',2015,'Ryan Coogler',721000000,109710000),
('Swiss Army Man',2016,'Dan Kwan',101000000,4210000),
('The Expendables 3',2014,'Patrick Hughes',446000000,39290000),
('What We Do in the Shadows',2014,'Jemaine Clement',276000000,3330000),
('Southpaw',2015,'Antoine Fuqua',286000000,52420000),
('Hush',2016,'Mike Flanagan',101000000,0),
('Bridge of Spies',2015,'Steven Spielberg',741000000,72310000),
('The Lego Movie',2014,'Phil Lord',101000000,257760000),
('Everest',2015,'Baltasar Kormákur',286000000,43250000),
('Pixels',2015,'Chris Columbus',961000000,78750000),
('Robin Hood',2010,'Ridley Scott',706000000,105220000),
('The Wolverine',2013,'James Mangold',81000000,132550000),
('John Carter',2012,'Andrew Stanton',961000000,73060000),
('Keanu',2016,'Peter Atencio',911000000,20570000),
('The Gunman',2015,'Pierre Morel',536000000,10640000),
('Steve Jobs',2015,'Danny Boyle',701000000,17750000),
('Whisky Galore',2016,'Gillies MacKinnon',511000000,0),
('Grown Ups 2',2013,'Dennis Dugan',586000000,133670000),
('The Age of Adaline',2015,'Lee Toland Krieger',466000000,42480000),
('The Incredible Hulk',2008,'Louis Leterrier',996000000,134520000),
('Couples Retreat',2009,'Peter Billingsley',576000000,109180000),
('Absolutely Anything',2015,'Terry Jones',951000000,0),
('Magic Mike',2012,'Steven Soderbergh',536000000,113710000),
('Minions',2015,'Kyle Balda',706000000,336030000),
('The Black Room',2016,'Rolfe Kanefsky',336000000,0),
('Bronson',2008,'Nicolas Winding Refn',481000000,100000),
('Despicable Me',2010,'Pierre Coffin',416000000,251500000),
('The Best of Me',2014,'Michael Hoffman',726000000,26760000),
('The Invitation',2015,'Karyn Kusama',96000000,230000),
('Zero Dark Thirty',2012,'Kathryn Bigelow',391000000,95720000),
('Tangled',2010,'Nathan Greno',616000000,200810000),
('The Hunger Games: Mockingjay - Part 2',2015,'Francis Lawrence',186000000,281670000),
('Vacation',2015,'John Francis Daley',601000000,58880000),
('Taken',2008,'Pierre Morel',836000000,145000000),
('Pitch Perfect 2',2015,'Elizabeth Banks',581000000,183440000),
('Monsters University',2013,'Dan Scanlon',11000000,268490000),
('Elle',2016,'Paul Verhoeven',576000000,0),
('Mechanic: Resurrection',2016,'Dennis Gansel',896000000,21200000),
('Tusk',2014,'Kevin Smith',551000000,1820000),
('The Headhunter''s Calling',2016,'Mark Williams',16000000,0),
('Atonement',2007,'Joe Wright',661000000,50920000),
('Harry Potter and the Deathly Hallows: Part 1',2010,'David Yates',111000000,294980000),
('Shame',2011,'Steve McQueen',941000000,4000000),
('Hanna',2011,'Joe Wright',181000000,40250000),
('The Babysitters',2007,'David Ross',556000000,40000),
('Pride and Prejudice and Zombies',2016,'Burr Steers',141000000,10910000),
('300: Rise of an Empire',2014,'Noam Murro',311000000,106370000),
('London Has Fallen',2016,'Babak Najafi',976000000,62400000),
('The Curious Case of Benjamin Button',2008,'David Fincher',311000000,127490000),
('Sin City: A Dame to Kill For',2014,'Frank Miller',286000000,13750000),
('The Bourne Ultimatum',2007,'Paul Greengrass',626000000,227140000),
('Srpski film',2010,'Srdjan Spasojevic',76000000,0),
('The Purge: Election Year',2016,'James DeMonaco',471000000,79000000),
('3 Idiots',2009,'Rajkumar Hirani',16000000,6520000),
('Zoolander 2',2016,'Ben Stiller',361000000,28840000),
('World War Z',2013,'Marc Forster',586000000,202350000),
('Mission: Impossible - Ghost Protocol',2011,'Brad Bird',546000000,209360000),
('Let Me Make You a Martyr',2016,'Corey Asraf',771000000,0),
('Filth',2013,'Jon S. Baird',391000000,30000),
('The Longest Ride',2015,'George Tillman Jr.',701000000,37430000),
('The imposible',2012,'J.A. Bayona',756000000,19000000),
('Kick-Ass 2',2013,'Jeff Wadlow',441000000,28750000),
('Folk Hero & Funny Guy',2016,'Jeff Grace',976000000,0),
('Oz the Great and Powerful',2013,'Sam Raimi',31000000,234900000),
('Brooklyn',2015,'John Crowley',36000000,38320000),
('Coraline',2009,'Henry Selick',171000000,75280000),
('Blue Valentine',2010,'Derek Cianfrance',941000000,9700000),
('The Thinning',2016,'Michael J. Gallagher',561000000,0),
('Silent Hill',2006,'Christophe Gans',901000000,46980000),
('Dredd',2012,'Pete Travis',371000000,13400000),
('Hunt for the Wilderpeople',2016,'Taika Waititi',216000000,5200000),
('Big Hero 6',2014,'Don Hall',406000000,222490000),
('Carrie',2013,'Kimberly Peirce',426000000,35270000),
('Iron Man 2',2010,'Jon Favreau',461000000,312060000),
('Demolition',2015,'Jean-Marc Vallée',966000000,1820000),
('Pandorum',2009,'Christian Alvart',486000000,10330000),
('Olympus Has Fallen',2013,'Antoine Fuqua',86000000,98900000),
('I Am Number Four',2011,'D.J. Caruso',926000000,55090000),
('Jagten',2012,'Thomas Vinterberg',561000000,610000),
('The Proposal',2009,'Anne Fletcher',486000000,163950000),
('Get Hard',2015,'Etan Cohen',546000000,90350000),
('Just Go with It',2011,'Dennis Dugan',56000000,103030000),
('Revolutionary Road',2008,'Sam Mendes',986000000,22880000),
('The Town',2010,'Ben Affleck',146000000,92170000),
('The Boy',2016,'William Brent Bell',491000000,35790000),
('Denial',2016,'Mick Jackson',921000000,4070000),
('Predestination',2014,'Michael Spierig',616000000,0),
('Goosebumps',2015,'Rob Letterman',946000000,80020000),
('Sherlock Holmes: A Game of Shadows',2011,'Guy Ritchie',891000000,186830000),
('Salt',2010,'Phillip Noyce',951000000,118310000),
('Enemy',2013,'Denis Villeneuve',861000000,1010000),
('District 9',2009,'Neill Blomkamp',191000000,115650000),
('The Other Guys',2010,'Adam McKay',746000000,119220000),
('American Gangster',2007,'Ridley Scott',426000000,130130000),
('Marie Antoinette',2006,'Sofia Coppola',571000000,15960000),
('2012',2009,'Roland Emmerich',451000000,166110000),
('Harry Potter and the Half-Blood Prince',2009,'David Yates',731000000,301960000),
('Argo',2012,'Ben Affleck',691000000,136020000),
('Eddie the Eagle',2016,'Dexter Fletcher',581000000,15790000),
('The Lives of Others',2006,'Florian Henckel von Donnersmarck',966000000,11280000),
('Pet',2016,'Carles Torrens',501000000,0),
('Paint It Black',2016,'Amber Tamblyn',511000000,0),
('Macbeth',2015,'Justin Kurzel',571000000,0),
('Forgetting Sarah Marshall',2008,'Nicholas Stoller',281000000,62880000),
('The Giver',2014,'Phillip Noyce',691000000,45090000),
('Triple 9',2016,'John Hillcoat',411000000,12630000),
('Perfetti sconosciuti',2016,'Paolo Genovese',626000000,0),
('Angry Birds',2016,'Clay Kaytis',751000000,107510000),
('Moonrise Kingdom',2012,'Wes Anderson',911000000,45510000),
('Hairspray',2007,'Adam Shankman',766000000,118820000),
('Safe Haven',2013,'Lasse Hallström',21000000,71350000),
('Focus',2015,'Glenn Ficarra',326000000,53850000),
('Ratatouille',2007,'Brad Bird',991000000,206440000),
('Stake Land',2010,'Jim Mickle',421000000,20000),
('The Book of Eli',2010,'Albert Hughes',361000000,94820000),
('Cloverfield',2008,'Matt Reeves',296000000,80030000),
('Point Break',2015,'Ericson Core',511000000,28770000),
('Under the Skin',2013,'Jonathan Glazer',626000000,2610000),
('I Am Legend',2007,'Francis Lawrence',481000000,256390000),
('Men in Black 3',2012,'Barry Sonnenfeld',481000000,179020000),
('Super 8',2011,'J.J. Abrams',41000000,126980000),
('Law Abiding Citizen',2009,'F. Gary Gray',611000000,73340000),
('Up',2009,'Pete Docter',876000000,292980000),
('Maze Runner: The Scorch Trials',2015,'Wes Ball',346000000,81690000),
('Carol',2015,'Todd Haynes',671000000,250000),
('Imperium',2016,'Daniel Ragussis',671000000,0),
('Youth',2015,'Paolo Sorrentino',71000000,2700000),
('Mr. Nobody',2009,'Jaco Van Dormael',616000000,0),
('City of Tiny Lights',2016,'Pete Travis',491000000,0),
('Savages',2012,'Oliver Stone',326000000,47310000),
('(500) Days of Summer',2009,'Marc Webb',876000000,32390000),
('Movie 43',2013,'Elizabeth Banks',676000000,8830000),
('Gravity',2013,'Alfonso Cuarón',841000000,274080000),
('The Boy in the Striped Pyjamas',2008,'Mark Herman',586000000,9030000),
('Shooter',2007,'Antoine Fuqua',556000000,46980000),
('The Happening',2008,'M. Night Shyamalan',381000000,64510000),
('Bone Tomahawk',2015,'S. Craig Zahler',821000000,66010000),
('Magic Mike XXL',2015,'Gregory Jacobs',856000000,0),
('Easy A',2010,'Will Gluck',36000000,58400000),
('Exodus: Gods and Kings',2014,'Ridley Scott',411000000,65010000),
('Chappie',2015,'Neill Blomkamp',511000000,31570000),
('The Hobbit: The Desolation of Smaug',2013,'Peter Jackson',116000000,258360000),
('Half of a Yellow Sun',2013,'Biyi Bandele',266000000,50000),
('Anthropoid',2016,'Sean Ellis',516000000,2960000),
('The Counselor',2013,'Ridley Scott',321000000,16970000),
('Viking',2016,'Andrey Kravchuk',311000000,23050000),
('Whiskey Tango Foxtrot',2016,'Glenn Ficarra',466000000,0),
('Trust',2010,'David Schwimmer',206000000,60000),
('Birth of the Dragon',2016,'George Nolfi',261000000,93050000),
('Elysium',2013,'Neill Blomkamp',481000000,0),
('The Green Inferno',2013,'Eli Roth',871000000,7190000),
('Godzilla',2014,'Gareth Edwards',341000000,200660000),
('The Bourne Legacy',2012,'Tony Gilroy',186000000,113170000),
('A Good Year',2006,'Ridley Scott',531000000,7460000),
('Friend Request',2016,'Simon Verhoeven',626000000,64030000),
('Deja Vu',2006,'Tony Scott',81000000,0),
('Lucy',2014,'Luc Besson',26000000,126550000),
('A Quiet Passion',2016,'Terence Davies',641000000,1080000),
('Need for Speed',2014,'Scott Waugh',561000000,43570000),
('Jack Reacher',2012,'Christopher McQuarrie',381000000,58680000),
('The Do-Over',2016,'Steven Brill',521000000,540000),
('True Crimes',2016,'Alexandros Avranas',971000000,0),
('American Pastoral',2016,'Ewan McGregor',531000000,0),
('The Ghost Writer',2010,'Roman Polanski',196000000,15520000),
('Limitless',2011,'Neil Burger',496000000,79240000),
('Spectral',2016,'Nic Mathieu',531000000,0),
('P.S. I Love You',2007,'Richard LaGravenese',751000000,53680000),
('Zipper',2015,'Mora Stephens',86000000,0),
('Midnight Special',2016,'Jeff Nichols',996000000,3710000),
('Don''t Think Twice',2016,'Mike Birbiglia',191000000,4420000),
('Alice in Wonderland',2010,'Tim Burton',436000000,334190000),
('Chuck',2016,'Philippe Falardeau',21000000,110000),
('I, Daniel Blake',2016,'Ken Loach',556000000,0),
('The Break-Up',2006,'Peyton Reed',516000000,118680000),
('Loving',2016,'Jeff Nichols',771000000,7700000),
('Fantastic Four',2015,'Josh Trank',881000000,56110000),
('The Survivalist',2015,'Stephen Fingleton',531000000,0),
('Colonia',2015,'Florian Gallenberger',76000000,0),
('The Boy Next Door',2015,'Rob Cohen',931000000,35390000),
('The Gift',2015,'Joel Edgerton',171000000,43770000),
('Dracula Untold',2014,'Gary Shore',641000000,55940000),
('In the Heart of the Sea',2015,'Ron Howard',931000000,24990000),
('Idiocracy',2006,'Mike Judge',921000000,440000),
('The Expendables',2010,'Sylvester Stallone',591000000,102980000),
('Evil Dead',2013,'Fede Alvarez',216000000,54240000),
('Sinister',2012,'Scott Derrickson',246000000,48060000),
('Wreck-It Ralph',2012,'Rich Moore',631000000,189410000),
('Snow White and the Huntsman',2012,'Rupert Sanders',531000000,155110000),
('Pan',2015,'Joe Wright',211000000,34960000),
('Transformers: Dark of the Moon',2011,'Michael Bay',681000000,352360000),
('Juno',2007,'Jason Reitman',531000000,143490000),
('A Hologram for the King',2016,'Tom Tykwer',531000000,4200000),
('Money Monster',2016,'Jodie Foster',721000000,41010000),
('The Other Woman',2014,'Nick Cassavetes',26000000,83910000),
('Enchanted',2007,'Kevin Lima',976000000,127710000),
('The Intern',2015,'Nancy Meyers',696000000,75270000),
('Little Miss Sunshine',2006,'Jonathan Dayton',441000000,59890000),
('Bleed for This',2016,'Ben Younger',506000000,4850000),
('Clash of the Titans',2010,'Louis Leterrier',826000000,163190000),
('The Finest Hours',2016,'Craig Gillespie',611000000,27550000),
('Tron',2010,'Joseph Kosinski',141000000,172050000),
('The Hunger Games: Catching Fire',2013,'Francis Lawrence',101000000,424650000),
('All Good Things',2010,'Andrew Jarecki',601000000,580000),
('Kickboxer: Vengeance',2016,'John Stockwell',381000000,131560000),
('The Last Airbender',2010,'M. Night Shyamalan',641000000,0),
('Sex Tape',2014,'Jake Kasdan',916000000,38540000),
('What to Expect When You''re Expecting',2012,'Kirk Jones',251000000,41100000),
('Moneyball',2011,'Bennett Miller',831000000,75610000),
('Ghost Rider',2007,'Mark Steven Johnson',861000000,115800000),
('Unbroken',2014,'Angelina Jolie',436000000,115600000),
('Immortals',2011,'Tarsem Singh',311000000,83500000),
('Sunshine',2007,'Danny Boyle',201000000,3680000),
('Brave',2012,'Mark Andrews',976000000,237280000),
('Män som hatar kvinnor',2009,'Niels Arden Oplev',431000000,10100000),
('Adoration',2013,'Anne Fontaine',781000000,320000),
('The Drop',2014,'Michaël R. Roskam',216000000,10720000),
('She''s the Man',2006,'Andy Fickman',406000000,2340000),
('Daddy''s Home',2015,'Sean Anders',101000000,150320000),
('Let Me In',2010,'Matt Reeves',331000000,12130000),
('Never Back Down',2008,'Jeff Wadlow',76000000,24850000),
('Grimsby',2016,'Louis Leterrier',741000000,6860000),
('Moon',2009,'Duncan Jones',466000000,5010000),
('Megamind',2010,'Tom McGrath',21000000,148340000),
('Gangster Squad',2013,'Ruben Fleischer',931000000,46000000),
('Blood Father',2016,'Jean-François Richet',996000000,93950000),
('He''s Just Not That Into You',2009,'Ken Kwapis',51000000,0),
('Kung Fu Panda 3',2016,'Alessandro Carloni',191000000,143520000),
('The Rise of the Krays',2015,'Zackary Adler',801000000,6530000),
('Handsome Devil',2016,'John Butler',376000000,0),
('Winter''s Bone',2010,'Debra Granik',66000000,0),
('Horrible Bosses',2011,'Seth Gordon',686000000,117530000),
('Mommy',2014,'Xavier Dolan',931000000,3490000),
('Hellboy II: The Golden Army',2008,'Guillermo del Toro',156000000,75750000),
('Beautiful Creatures',2013,'Richard LaGravenese',356000000,19450000),
('Toni Erdmann',2016,'Maren Ade',891000000,1480000),
('The Lovely Bones',2009,'Peter Jackson',726000000,43980000),
('The Assassination of Jesse James by the Coward Robert Ford',2007,'Andrew Dominik',841000000,3900000),
('Don Jon',2013,'Joseph Gordon-Levitt',416000000,24480000),
('Bastille Day',2016,'James Watkins',346000000,40000),
('2307: Winter''s Dream',2016,'Joey Curtis',396000000,20760000),
('Free State of Jones',2016,'Gary Ross',536000000,0),
('Mr. Right',2015,'Paco Cabezas',646000000,30000),
('The Secret Life of Walter Mitty',2013,'Ben Stiller',766000000,58230000),
('Dope',2015,'Rick Famuyiwa',931000000,17470000),
('Underworld Awakening',2012,'Måns Mårlind',421000000,62320000),
('Antichrist',2009,'Lars von Trier',696000000,400000),
('Friday the 13th',2009,'Marcus Nispel',986000000,65000000),
('Taken 3',2014,'Olivier Megaton',596000000,89250000),
('Total Recall',2012,'Len Wiseman',586000000,58880000),
('X-Men: The Last Stand',2006,'Brett Ratner',341000000,234360000),
('The Escort',2016,'Will Slocombe',801000000,0),
('The Whole Truth',2016,'Courtney Hunt',486000000,0),
('Night at the Museum: Secret of the Tomb',2014,'Shawn Levy',586000000,113730000),
('Love & Other Drugs',2010,'Edward Zwick',971000000,32360000),
('The Interview',2014,'Evan Goldberg',311000000,6110000),
('The Host',2006,'Bong Joon Ho',321000000,2200000),
('Megan Is Missing',2011,'Michael Goi',406000000,0),
('WALL-E',2008,'Andrew Stanton',871000000,223810000),
('Knocked Up',2007,'Judd Apatow',321000000,148730000),
('Source Code',2011,'Duncan Jones',756000000,54700000),
('Lawless',2012,'John Hillcoat',686000000,37400000),
('Unfriended',2014,'Levan Gabriadze',711000000,31540000),
('American Reunion',2012,'Jon Hurwitz',531000000,56720000),
('The Pursuit of Happyness',2006,'Gabriele Muccino',86000000,162590000),
('Relatos salvajes',2014,'Damián Szifron',336000000,3080000),
('The Ridiculous 6',2015,'Frank Coraci',206000000,0),
('Frantz',2016,'François Ozon',746000000,860000),
('Viral',2016,'Henry Joost',911000000,0),
('Gran Torino',2008,'Clint Eastwood',601000000,148090000),
('Burnt',2015,'John Wells',321000000,13650000),
('Tall Men',2016,'Jonathan Holbrook',146000000,0),
('Sleeping Beauty',2011,'Julia Leigh',706000000,30000),
('Vampire Academy',2014,'Mark Waters',111000000,7790000),
('Sweeney Todd: The Demon Barber of Fleet Street',2007,'Tim Burton',456000000,52880000),
('Solace',2015,'Afonso Poyart',91000000,0),
('Insidious',2010,'James Wan',701000000,53990000),
('Popstar: Never Stop Never Stopping',2016,'Akiva Schaffer',746000000,9390000),
('The Levelling',2016,'Hope Dickson Leach',61000000,0),
('Public Enemies',2009,'Michael Mann',241000000,97030000),
('Boyhood',2014,'Richard Linklater',181000000,25360000),
('Teenage Mutant Ninja Turtles',2014,'Jonathan Liebesman',646000000,190870000),
('Eastern Promises',2007,'David Cronenberg',776000000,17110000),
('The Daughter',2015,'Simon Stone',951000000,30000),
('Pineapple Express',2008,'David Gordon Green',31000000,87340000),
('The First Time',2012,'Jon Kasdan',121000000,20000),
('Gone Baby Gone',2007,'Ben Affleck',111000000,20300000),
('The Heat',2013,'Paul Feig',166000000,159580000),
('L''avenir',2016,'Mia Hansen-Løve',126000000,280000),
('Anna Karenina',2012,'Joe Wright',36000000,12800000),
('Regression',2015,'Alejandro Amenábar',586000000,50000),
('Ted 2',2015,'Seth MacFarlane',546000000,81260000),
('Pain & Gain',2013,'Michael Bay',321000000,49870000),
('Blood Diamond',2006,'Edward Zwick',841000000,57370000),
('Devil''s Knot',2013,'Atom Egoyan',441000000,0),
('Child 44',2015,'Daniel Espinosa',976000000,1210000),
('The Hurt Locker',2008,'Kathryn Bigelow',161000000,15700000),
('Green Lantern',2011,'Martin Campbell',376000000,116590000),
('War on Everyone',2016,'John Michael McDonagh',646000000,0),
('The Mist',2007,'Frank Darabont',206000000,25590000),
('Escape Plan',2013,'Mikael Håfström',486000000,25120000),
('Love, Rosie',2014,'Christian Ditter',566000000,10000),
('The DUFF',2015,'Ari Sandel',886000000,34020000),
('The Age of Shadows',2016,'Jee-woon Kim',436000000,540000),
('The Hunger Games: Mockingjay - Part 1',2014,'Francis Lawrence',741000000,337100000),
('We Need to Talk About Kevin',2011,'Lynne Ramsay',951000000,1740000),
('Love & Friendship',2016,'Whit Stillman',761000000,14010000),
('The Mortal Instruments: City of Bones',2013,'Harald Zwart',76000000,31170000),
('Seven Pounds',2008,'Gabriele Muccino',856000000,69950000),
('The King''s Speech',2010,'Tom Hooper',476000000,138800000),
('Hunger',2008,'Steve McQueen',661000000,150000),
('Jumper',2008,'Doug Liman',621000000,80170000),
('Toy Story 3',2010,'Lee Unkrich',156000000,414980000),
('Tinker Tailor Soldier Spy',2011,'Tomas Alfredson',461000000,24100000),
('Resident Evil: Retribution',2012,'Paul W.S. Anderson',556000000,42350000),
('Dear Zindagi',2016,'Gauri Shinde',326000000,1400000),
('Genius',2016,'Michael Grandage',396000000,1360000),
('Pompeii',2014,'Paul W.S. Anderson',176000000,23220000),
('Life of Pi',2012,'Ang Lee',656000000,124980000),
('Hachi: A Dog''s Tale',2009,'Lasse Hallström',786000000,0),
('10 Years',2011,'Jamie Linden',656000000,200000),
('I Origins',2014,'Mike Cahill',41000000,330000),
('Live Free or Die Hard',2007,'Len Wiseman',996000000,134520000),
('The Matchbreaker',2016,'Caleb Vetter',336000000,0),
('Funny Games',2007,'Michael Haneke',361000000,1290000),
('Ted',2012,'Seth MacFarlane',286000000,218630000),
('RED',2010,'Robert Schwentke',376000000,90360000),
('Australia',2008,'Baz Luhrmann',816000000,49550000),
('Faster',2010,'George Tillman Jr.',216000000,23230000),
('The Neighbor',2016,'Marcus Dunstan',316000000,0),
('The Adjustment Bureau',2011,'George Nolfi',106000000,62450000),
('The Hollars',2016,'John Krasinski',796000000,1020000),
('The Judge',2014,'David Dobkin',261000000,47110000),
('Closed Circuit',2013,'John Crowley',751000000,5730000),
('Transformers: Revenge of the Fallen',2009,'Michael Bay',906000000,402080000),
('La tortue rouge',2016,'Michael Dudok de Wit',26000000,920000),
('The Book of Life',2014,'Jorge R. Gutiérrez',726000000,50150000),
('Incendies',2010,'Denis Villeneuve',686000000,6860000),
('The Heartbreak Kid',2007,'Bobby Farrelly',206000000,36770000),
('Happy Feet',2006,'George Miller',976000000,197990000),
('Entourage',2015,'Doug Ellin',406000000,32360000),
('The Strangers',2008,'Bryan Bertino',401000000,52530000),
('Noah',2014,'Darren Aronofsky',486000000,101160000),
('Neighbors',2014,'Nicholas Stoller',776000000,150060000),
('Nymphomaniac: Vol. II',2013,'Lars von Trier',431000000,330000),
('Wild',2014,'Jean-Marc Vallée',816000000,37880000),
('Grown Ups',2010,'Dennis Dugan',406000000,162000000),
('Blair Witch',2016,'Adam Wingard',341000000,20750000),
('The Karate Kid',2010,'Harald Zwart',481000000,176590000),
('Dark Shadows',2012,'Tim Burton',606000000,79710000),
('Friends with Benefits',2011,'Will Gluck',276000000,55800000),
('The Illusionist',2006,'Neil Burger',601000000,39830000),
('The A-Team',2010,'Joe Carnahan',601000000,77210000),
('The Guest',2014,'Adam Wingard',831000000,320000),
('The Internship',2013,'Shawn Levy',866000000,44670000),
('Paul',2011,'Greg Mottola',366000000,37370000),
('This Beautiful Fantastic',2016,'Simon Aboud',211000000,0),
('The Da Vinci Code',2006,'Ron Howard',571000000,217540000),
('Mr. Church',2016,'Bruce Beresford',231000000,690000),
('Hugo',2011,'Martin Scorsese',266000000,73820000),
('The Blackcoat''s Daughter',2015,'Oz Perkins',671000000,20000),
('Body of Lies',2008,'Ridley Scott',46000000,39380000),
('Knight of Cups',2015,'Terrence Malick',991000000,560000),
('The Mummy: Tomb of the Dragon Emperor',2008,'Rob Cohen',811000000,102180000),
('The Boss',2016,'Ben Falcone',941000000,63030000),
('Hands of Stone',2016,'Jonathan Jakubowicz',166000000,4710000),
('El secreto de sus ojos',2009,'Juan José Campanella',331000000,20170000),
('True Grit',2010,'Ethan Coen',721000000,171030000),
('We Are Your Friends',2015,'Max Joseph',336000000,3590000),
('A Million Ways to Die in the West',2014,'Seth MacFarlane',716000000,42620000),
('Only for One Night',2016,'Chris Stokes',886000000,0),
('Rules Don''t Apply',2016,'Warren Beatty',91000000,3650000),
('Ouija: Origin of Evil',2016,'Mike Flanagan',361000000,34900000),
('Percy Jackson: Sea of Monsters',2013,'Thor Freudenthal',931000000,68560000),
('Fracture',2007,'Gregory Hoblit',816000000,39000000),
('Oculus',2013,'Mike Flanagan',321000000,27690000),
('In Bruges',2008,'Martin McDonagh',886000000,7760000),
('This Means War',2012,'McG',46000000,54760000),
('the devil''s mistress',2016,'Filip Renc',991000000,0),
('The Road',2009,'John Hillcoat',346000000,60000),
('Lavender',2016,'Ed Gass-Donnelly',521000000,0),
('Deuces',2016,'Jamal Hill',466000000,0),
('Conan the Barbarian',2011,'Marcus Nispel',816000000,21270000),
('The Fighter',2010,'David O. Russell',206000000,93570000),
('August Rush',2007,'Kirsten Sheridan',796000000,31660000),
('Chef',2014,'Jon Favreau',256000000,31240000),
('Eye in the Sky',2015,'Gavin Hood',486000000,18700000),
('Eagle Eye',2008,'D.J. Caruso',541000000,101110000),
('The Purge',2013,'James DeMonaco',506000000,64420000),
('PK',2014,'Rajkumar Hirani',746000000,10570000),
('Ender''s Game',2013,'Gavin Hood',421000000,61660000),
('Indiana Jones and the Kingdom of the Crystal Skull',2008,'Steven Spielberg',896000000,317010000),
('Paper Towns',2015,'Jake Schreier',596000000,31990000),
('High-Rise',2015,'Ben Wheatley',141000000,340000),
('Quantum of Solace',2008,'Marc Forster',986000000,168370000),
('The Assignment',2016,'Walter Hill',806000000,0),
('How to Train Your Dragon',2010,'Dean DeBlois',876000000,217390000),
('Lady in the Water',2006,'M. Night Shyamalan',76000000,42270000),
('The Fountain',2006,'Darren Aronofsky',716000000,10140000),
('Cars 2',2011,'John Lasseter',841000000,191450000),
('31',2016,'Rob Zombie',111000000,780000),
('Final Girl',2015,'Tyler Shields',966000000,0),
('Chalk It Up',2016,'Hisonni Johnson',876000000,0),
('The Man Who Knew Infinity',2015,'Matt Brown',441000000,3860000),
('Unknown',2011,'Jaume Collet-Serra',616000000,61090000),
('Self/less',2015,'Tarsem Singh',186000000,12280000),
('Mr. Brooks',2007,'Bruce A. Evans',851000000,28480000),
('Tramps',2016,'Adam Leon',11000000,0),
('Before We Go',2014,'Chris Evans',291000000,40000),
('Captain Phillips',2013,'Paul Greengrass',866000000,107100000),
('The Secret Scripture',2016,'Jim Sheridan',166000000,0),
('Max Steel',2016,'Stewart Hendler',211000000,3770000),
('Hotel Transylvania 2',2015,'Genndy Tartakovsky',481000000,169690000),
('Hancock',2008,'Peter Berg',571000000,227950000),
('Sisters',2015,'Jason Moore',791000000,87030000),
('The Family',2013,'Luc Besson',871000000,36920000),
('Zack and Miri Make a Porno',2008,'Kevin Smith',896000000,31450000),
('Ma vie de Courgette',2016,'Claude Barras',501000000,290000),
('Man on a Ledge',2012,'Asger Leth',256000000,18600000),
('No Strings Attached',2011,'Ivan Reitman',346000000,70630000),
('Rescue Dawn',2006,'Werner Herzog',501000000,5480000),
('Despicable Me 2',2013,'Pierre Coffin',381000000,368050000),
('A Walk Among the Tombstones',2014,'Scott Frank',236000000,25980000),
('The World''s End',2013,'Edgar Wright',551000000,26000000),
('Yoga Hosers',2016,'Kevin Smith',281000000,0),
('Seven Psychopaths',2012,'Martin McDonagh',216000000,14990000),
('Beowulf',2007,'Robert Zemeckis',511000000,82160000),
('Jack Ryan: Shadow Recruit',2014,'Kenneth Branagh',206000000,50550000),
('1408',2007,'Mikael Håfström',181000000,71980000),
('The Gambler',2014,'Rupert Wyatt',131000000,33630000),
('Prince of Persia: The Sands of Time',2010,'Mike Newell',781000000,90760000),
('The Spectacular Now',2013,'James Ponsoldt',706000000,6850000),
('A United Kingdom',2016,'Amma Asante',551000000,3900000),
('USS Indianapolis: Men of Courage',2016,'Mario Van Peebles',741000000,0),
('Turbo Kid',2015,'François Simard',336000000,50000),
('Mama',2013,'Andrés Muschietti',101000000,71590000),
('Orphan',2009,'Jaume Collet-Serra',336000000,41570000),
('To Rome with Love',2012,'Woody Allen',316000000,16680000),
('Fantastic Mr. Fox',2009,'Wes Anderson',786000000,21000000),
('Inside Man',2006,'Spike Lee',896000000,88500000),
('I.T.',2016,'John Moore',416000000,0),
('127 Hours',2010,'Danny Boyle',486000000,18330000),
('Annabelle',2014,'John R. Leonetti',16000000,84260000),
('Wolves at the Door',2016,'John R. Leonetti',891000000,0),
('suite francaise',2014,'Saul Dibb',386000000,0),
('The Imaginarium of Doctor Parnassus',2009,'Terry Gilliam',246000000,7690000),
('G.I. Joe: The Rise of Cobra',2009,'Stephen Sommers',296000000,150170000),
('Christine',2016,'Antonio Campos',61000000,300000),
('Man Down',2015,'Dito Montiel',771000000,0),
('Crawlspace',2016,'Phil Claydon',461000000,0),
('Shut In',2016,'Farren Blackburn',796000000,6880000),
('The Warriors Gate',2016,'Matthias Hoene',746000000,0),
('Grindhouse',2007,'Robert Rodriguez',791000000,25030000),
('Disaster Movie',2008,'Jason Friedberg',496000000,14170000),
('Rocky Balboa',2006,'Sylvester Stallone',561000000,70270000),
('Diary of a Wimpy Kid: Dog Days',2012,'David Bowers',321000000,49000000),
('Jane Eyre',2011,'Cary Joji Fukunaga',16000000,11230000),
('Fool''s Gold',2008,'Andy Tennant',721000000,70220000),
('The Dictator',2012,'Larry Charles',716000000,59620000),
('The Loft',2014,'Erik Van Looy',456000000,5980000),
('Bacalaureat',2016,'Cristian Mungiu',611000000,130000),
('You Don''t Mess with the Zohan',2008,'Dennis Dugan',506000000,100020000),
('Exposed',2016,'Gee Malik Linton',61000000,0),
('Maudie',2016,'Aisling Walsh',556000000,0),
('Horrible Bosses 2',2014,'Sean Anders',566000000,54410000),
('A Bigger Splash',2015,'Luca Guadagnino',686000000,1980000),
('Melancholia',2011,'Lars von Trier',656000000,3030000),
('The Princess and the Frog',2009,'Ron Clements',501000000,104370000),
('Unstoppable',2010,'Tony Scott',466000000,81560000),
('Flight',2012,'Robert Zemeckis',556000000,93750000),
('Home',2015,'Tim Johnson',991000000,177340000),
('La migliore offerta',2013,'Giuseppe Tornatore',501000000,90000),
('Mean Dreams',2016,'Nathan Morlando',211000000,0),
('42',2013,'Brian Helgeland',336000000,95000000),
('21',2008,'Robert Luketic',881000000,81160000),
('Begin Again',2013,'John Carney',736000000,16170000),
('Out of the Furnace',2013,'Scott Cooper',231000000,11330000),
('Vicky Cristina Barcelona',2008,'Woody Allen',791000000,23210000),
('Kung Fu Panda',2008,'Mark Osborne',671000000,215400000),
('Barbershop: The Next Cut',2016,'Malcolm D. Lee',696000000,54010000),
('Terminator Salvation',2009,'McG',771000000,125320000),
('Freedom Writers',2007,'Richard LaGravenese',6000000,36580000),
('The Hills Have Eyes',2006,'Alexandre Aja',296000000,41780000),
('Changeling',2008,'Clint Eastwood',591000000,35710000),
('Remember Me',2010,'Allen Coulter',561000000,19060000),
('Koe no katachi',2016,'Naoko Yamada',621000000,0),
('Alexander and the Terrible, Horrible, No Good, Very Bad Day',2014,'Miguel Arteta',566000000,66950000),
('Locke',2013,'Steven Knight',181000000,1360000),
('The 9th Life of Louis Drax',2016,'Alexandre Aja',306000000,0),
('Horns',2013,'Alexandre Aja',361000000,160000),
('Indignation',2016,'James Schamus',861000000,3400000),
('The Stanford Prison Experiment',2015,'Kyle Patrick Alvarez',671000000,640000),
('Diary of a Wimpy Kid: Rodrick Rules',2011,'David Bowers',891000000,52690000),
('Mission: Impossible III',2006,'J.J. Abrams',736000000,133380000),
('En man som heter Ove',2015,'Hannes Holm',876000000,3360000),
('Dragonball Evolution',2009,'James Wong',681000000,9350000),
('Red Dawn',2012,'Dan Bradley',841000000,44800000),
('One Day',2011,'Lone Scherfig',816000000,13770000),
('Life as We Know It',2010,'Greg Berlanti',911000000,53360000),
('28 Weeks Later',2007,'Juan Carlos Fresnadillo',661000000,28640000),
('Warm Bodies',2013,'Jonathan Levine',406000000,66360000),
('Blue Jasmine',2013,'Woody Allen',536000000,33400000),
('G.I. Joe: Retaliation',2013,'Jon M. Chu',941000000,122510000),
('Wrath of the Titans',2012,'Jonathan Liebesman',471000000,83640000),
('Shin Gojira',2016,'Hideaki Anno',46000000,1910000),
('Saving Mr. Banks',2013,'John Lee Hancock',661000000,83300000),
('Transcendence',2014,'Wally Pfister',896000000,23010000),
('Rio',2011,'Carlos Saldanha',886000000,143620000),
('Equals',2015,'Drake Doremus',21000000,30000),
('Babel',2006,'Alejandro González Iñárritu',381000000,34300000),
('The Tree of Life',2011,'Terrence Malick',306000000,13300000),
('The Lucky One',2012,'Scott Hicks',876000000,60440000),
('Piranha 3D',2010,'Alexandre Aja',926000000,25000000),
('50/50',2011,'Jonathan Levine',171000000,34960000),
('The Intent',2016,'Femi Oyeniran',306000000,0),
('This Is 40',2012,'Judd Apatow',361000000,67520000),
('Real Steel',2011,'Shawn Levy',811000000,85460000),
('Sex and the City',2008,'Michael Patrick King',881000000,152640000),
('Rambo',2008,'Sylvester Stallone',496000000,42720000),
('Planet Terror',2007,'Robert Rodriguez',886000000,0),
('Concussion',2015,'Peter Landesman',136000000,34530000),
('The Fall',2006,'Tarsem Singh',911000000,2280000),
('The Ugly Truth',2009,'Robert Luketic',961000000,88920000),
('Bride Wars',2009,'Gary Winick',946000000,58720000),
('Sleeping with Other People',2015,'Leslye Headland',796000000,810000),
('Snakes on a Plane',2006,'David R. Ellis',391000000,34010000),
('What If',2013,'Michael Dowse',231000000,3450000),
('How to Train Your Dragon 2',2014,'Dean DeBlois',586000000,177000000),
('RoboCop',2014,'José Padilha',381000000,58610000),
('In Dubious Battle',2016,'James Franco',481000000,0),
('Hello, My Name Is Doris',2015,'Michael Showalter',126000000,14440000),
('Ocean''s Thirteen',2007,'Steven Soderbergh',626000000,117140000),
('Slither',2006,'James Gunn',366000000,7770000),
('Contagion',2011,'Steven Soderbergh',861000000,75640000),
('Il racconto dei racconti - Tale of Tales',2015,'Matteo Garrone',326000000,80000),
('I Am the Pretty Thing That Lives in the House',2016,'Oz Perkins',561000000,0),
('Bridge to Terabithia',2007,'Gabor Csupo',561000000,82230000),
('Coherence',2013,'James Ward Byrkit',931000000,70000),
('Notorious',2009,'George Tillman Jr.',176000000,36840000),
('Goksung',2016,'Hong-jin Na',261000000,790000),
('The Expendables 2',2012,'Simon West',886000000,85020000),
('The Girl Next Door',2007,'Gregory Wilson',896000000,0),
('Perfume: The Story of a Murderer',2006,'Tom Tykwer',11000000,2210000),
('The Golden Compass',2007,'Chris Weitz',201000000,70080000),
('Centurion',2010,'Neil Marshall',641000000,120000),
('Scouts Guide to the Zombie Apocalypse',2015,'Christopher Landon',671000000,3640000),
('17 Again',2009,'Burr Steers',86000000,64150000),
('No Escape',2015,'John Erick Dowdle',21000000,27290000),
('Superman Returns',2006,'Bryan Singer',26000000,200070000),
('The Twilight Saga: Breaking Dawn - Part 1',2011,'Bill Condon',746000000,281280000),
('Precious',2009,'Lee Daniels',436000000,47540000),
('The Sea of Trees',2015,'Gus Van Sant',396000000,20000),
('Good Kids',2016,'Chris McCoy',701000000,0),
('The Master',2012,'Paul Thomas Anderson',726000000,16380000),
('Footloose',2011,'Craig Brewer',701000000,51780000),
('If I Stay',2014,'R.J. Cutler',276000000,50460000),
('The Ticket',2016,'Ido Fluk',96000000,0),
('Detour',2016,'Christopher Smith',11000000,0),
('The Love Witch',2016,'Anna Biller',546000000,220000),
('Talladega Nights: The Ballad of Ricky Bobby',2006,'Adam McKay',956000000,148210000),
('The Human Centipede (First Sequence)',2009,'Tom Six',406000000,180000),
('Super',2010,'James Gunn',536000000,320000),
('The Siege of Jadotville',2016,'Richie Smyth',666000000,0),
('Up in the Air',2009,'Jason Reitman',606000000,83810000),
('The Midnight Meat Train',2008,'Ryûhei Kitamura',626000000,70000),
('The Twilight Saga: Eclipse',2010,'David Slade',766000000,300520000),
('Transpecos',2016,'Greg Kwedar',826000000,0),
('What''s Your Number?',2011,'Mark Mylod',616000000,13990000),
('Riddick',2013,'David Twohy',731000000,42000000),
('Triangle',2009,'Christopher Smith',856000000,0),
('The Butler',2013,'Lee Daniels',696000000,116630000),
('King Cobra',2016,'Justin Kelly',671000000,30000),
('After Earth',2013,'M. Night Shyamalan',241000000,60520000),
('Kicks',2016,'Justin Tipping',131000000,150000),
('Me and Earl and the Dying Girl',2015,'Alfonso Gomez-Rejon',861000000,6740000),
('The Descendants',2011,'Alexander Payne',951000000,82620000),
('Sex and the City 2',2010,'Michael Patrick King',756000000,95330000),
('The Kings of Summer',2013,'Jordan Vogt-Roberts',71000000,1290000),
('Death Race',2008,'Paul W.S. Anderson',166000000,36060000),
('That Awkward Moment',2014,'Tom Gormican',441000000,26050000),
('Legion',2010,'Scott Stewart',746000000,40170000),
('End of Watch',2012,'David Ayer',771000000,40980000),
('3 Days to Kill',2014,'McG',781000000,30690000),
('Lucky Number Slevin',2006,'Paul McGuigan',336000000,22490000),
('Trance',2013,'Danny Boyle',976000000,2320000),
('Into the Forest',2015,'Patricia Rozema',741000000,10000),
('The Other Boleyn Girl',2008,'Justin Chadwick',811000000,26810000),
('I Spit on Your Grave',2010,'Steven R. Monroe',121000000,90000),
('Custody',2016,'James Lapine',721000000,0),
('Inland Empire',2006,'David Lynch',691000000,0),
('The Odyssey',2016,'Jérôme Salle',556000000,0),
('The Walk',2015,'Robert Zemeckis',826000000,10140000),
('Wrecker',2015,'Micheal Bafaro',616000000,0),
('The Lone Ranger',2013,'Gore Verbinski',746000000,89290000),
('Texas Chainsaw 3D',2013,'John Luessenhop',481000000,34330000),
('Disturbia',2007,'D.J. Caruso',606000000,80050000),
('Rock of Ages',2012,'Adam Shankman',846000000,38510000),
('Scream 4',2011,'Wes Craven',866000000,38180000),
('Queen of Katwe',2016,'Mira Nair',46000000,8810000),
('My Big Fat Greek Wedding 2',2016,'Kirk Jones',341000000,59570000),
('Dark Places',2015,'Gilles Paquet-Brenner',651000000,0),
('Amateur Night',2016,'Lisa Addario',601000000,0),
('It''s Only the End of the World',2016,'Xavier Dolan',91000000,0),
('The Skin I Live In',2011,'Pedro Almodóvar',896000000,3190000),
('Miracles from Heaven',2016,'Patricia Riggen',876000000,61690000),
('Annie',2014,'Will Gluck',606000000,85910000),
('Across the Universe',2007,'Julie Taymor',556000000,24340000),
('Let''s Be Cops',2014,'Luke Greenfield',951000000,82390000),
('Max',2015,'Boaz Yakin',916000000,42650000),
('Your Highness',2011,'David Gordon Green',736000000,21560000),
('Final Destination 5',2011,'Steven Quale',391000000,42580000),
('Endless Love',2014,'Shana Feste',851000000,23390000),
('Martyrs',2008,'Pascal Laugier',991000000,0),
('Selma',2014,'Ava DuVernay',876000000,52070000),
('Underworld: Rise of the Lycans',2009,'Patrick Tatopoulos',346000000,45800000),
('Taare Zameen Par',2007,'Aamir Khan',251000000,1200000),
('Take Me Home Tonight',2011,'Michael Dowse',956000000,6920000),
('Resident Evil: Afterlife',2010,'Paul W.S. Anderson',436000000,60130000),
('Project X',2012,'Nima Nourizadeh',781000000,54720000),
('Secret in Their Eyes',2015,'Billy Ray',56000000,0),
('Hostel: Part II',2007,'Eli Roth',206000000,17540000),
('Step Up 2: The Streets',2008,'Jon M. Chu',881000000,58010000),
('Search Party',2014,'Scot Armstrong',831000000,0),
('Nine Lives',2016,'Barry Sonnenfeld',821000000,19640000)) i(title,"year",director,budget,gross)
WHERE EXISTS(
SELECT FROM directors d 
WHERE (d.director)=(i.director)
FOR SHARE)
ON CONFLICT DO NOTHING;
INSERT INTO directorawards(director,"year",award,"result")
SELECT i.*
FROM (VALUES
('Giacomo Gentilomo',1946,'Cannes','nominated'::"awardresult"),
('John Cromwell',1947,'Cannes','nominated'::"awardresult"),
('Anders Henrikson',1948,'Cannes','nominated'::"awardresult"),
('Johan Jacobsen',1949,'Cannes','nominated'::"awardresult"),
('David Lean',1950,'Cannes','nominated'::"awardresult"),
('Gabriel Pascal',1951,'Cannes','nominated'::"awardresult"),
('José Leitao De Barros',1952,'Cannes','nominated'::"awardresult"),
('Mikhail Romm',1953,'Cannes','nominated'::"awardresult"),
('Bodil Ipsen,                                                          Lau Lauritzen',1954,'Cannes','nominated'::"awardresult"),
('Léopold Lindtberg',1955,'Cannes','nominated'::"awardresult"),
('Muhammad Karim',1956,'Cannes','nominated'::"awardresult"),
('Paul Calinescu',1957,'Cannes','nominated'::"awardresult"),
('George Cukor',1958,'Cannes','nominated'::"awardresult"),
('Charles Vidor',1959,'Cannes','nominated'::"awardresult"),
('Lev Arnchtam',1960,'Cannes','nominated'::"awardresult"),
('Alf Sjöberg',1961,'Cannes','nominated'::"awardresult"),
('Alberto Lattuada',1962,'Cannes','nominated'::"awardresult"),
('Aleksandr Ptouchko',1963,'Cannes','nominated'::"awardresult"),
('René Clément',1964,'Cannes','nominated'::"awardresult"),
('Jean Cocteau',1965,'Cannes','nominated'::"awardresult"),
('Jean Delannoy',1966,'Cannes','nominated'::"awardresult"),
('Mario Soldati',1967,'Cannes','nominated'::"awardresult"),
('René Clément',1968,'Cannes','nominated'::"awardresult"),
('Miguel M. Delgado',1969,'Cannes','nominated'::"awardresult"),
('Joshua Meador,                                                          Jack Kinney                                                                                                                                    , ...',1970,'Cannes','nominated'::"awardresult"),
('Emilio Fernandez',1971,'Cannes','nominated'::"awardresult"),
('Frantisek Cap',1972,'Cannes','nominated'::"awardresult"),
('Chetan Anand',1973,'Cannes','nominated'::"awardresult"),
('Otakar Vavra',1974,'Cannes','nominated'::"awardresult"),
('Alfred Hitchcock',1975,'Cannes','nominated'::"awardresult"),
('Louis Daquin',1976,'Cannes','nominated'::"awardresult"),
('Irving Rapper',1977,'Cannes','nominated'::"awardresult"),
('Roberto Rossellini',1978,'Cannes','nominated'::"awardresult"),
('Basil Dearden',1979,'Cannes','nominated'::"awardresult"),
('Billy Wilder',1980,'Cannes','nominated'::"awardresult"),
('Bernard Knowles',1981,'Cannes','nominated'::"awardresult"),
('Compton Bennet',1982,'Cannes','nominated'::"awardresult"),
('Barbara Virginia',1983,'Cannes','nominated'::"awardresult"),
('Alessandro Blasetti',1984,'Cannes','nominated'::"awardresult"),
('. Christian-Jaque',1985,'Cannes','nominated'::"awardresult"),
('Friedrich Ermler',1986,'Cannes','nominated'::"awardresult"),
('H. Bruce Humberstone',1987,'Cannes','nominated'::"awardresult"),
('Sergueï Youtkévitch',1988,'Cannes','nominated'::"awardresult"),
('Lev Arnchtam',1989,'Cannes','nominated'::"awardresult"),
('Alan Parker',1990,'Cannes','nominated'::"awardresult"),
('Jean-Paul Rappeneau',1991,'Cannes','nominated'::"awardresult"),
('Bertrand Tavernier',1992,'Cannes','nominated'::"awardresult"),
('Ken Loach',1993,'Cannes','nominated'::"awardresult"),
('Yang Fengliang,                                                          Zhang Yimou',1994,'Cannes','nominated'::"awardresult"),
('Raymond Depardon',1995,'Cannes','nominated'::"awardresult"),
('Axel Corti',1996,'Cannes','nominated'::"awardresult"),
('Gleb Panfilov',1997,'Cannes','nominated'::"awardresult"),
('Jean-Luc Godard',1998,'Cannes','nominated'::"awardresult"),
('Ryszard Bugajski',1999,'Cannes','nominated'::"awardresult"),
('Victor Manuel Gaviria',2000,'Cannes','nominated'::"awardresult"),
('Kohei Oguri',2001,'Cannes','nominated'::"awardresult"),
('Giuseppe Tornatore',2002,'Cannes','nominated'::"awardresult"),
('Pavel Lounguine',2003,'Cannes','nominated'::"awardresult"),
('Idrissa Ouedraogo',2004,'Cannes','nominated'::"awardresult"),
('Karel Kachyna',2005,'Cannes','nominated'::"awardresult"),
('Clint Eastwood',2006,'Cannes','nominated'::"awardresult"),
('David Lynch',2007,'Cannes','nominated'::"awardresult"),
('Atom Egoyan',2008,'Cannes','nominated'::"awardresult"),
('Fernando Meirelles',2009,'Cannes','nominated'::"awardresult"),
('Steven Soderbergh',2010,'Cannes','nominated'::"awardresult"),
('Kornél Mundruczó',2011,'Cannes','nominated'::"awardresult"),
('Laurent Cantet',2012,'Cannes','nominated'::"awardresult"),
('Jia Zhang-Ke',2013,'Cannes','nominated'::"awardresult"),
('Matteo Garrone',2014,'Cannes','nominated'::"awardresult"),
('Paolo Sorrentino',2015,'Cannes','nominated'::"awardresult"),
('Clint Eastwood',2016,'Cannes','nominated'::"awardresult"),
('Philippe Garrel',2017,'Cannes','nominated'::"awardresult"),
('Lucrecia Martel',2018,'Cannes','nominated'::"awardresult"),
('Luc Dardenne,                                                          Jean-Pierre Dardenne',2019,'Cannes','nominated'::"awardresult"),
('Pablo Trapero',2020,'Cannes','nominated'::"awardresult"),
('Daniela Thomas,                                                          Walter Salles',2021,'Cannes','nominated'::"awardresult"),
('Eric',2022,'Cannes','nominated'::"awardresult"),
('Wim Wenders',2023,'Cannes','nominated'::"awardresult"),
('Brillante Mendoza',2024,'Cannes','nominated'::"awardresult"),
('Charlie Kaufman',2025,'Cannes','nominated'::"awardresult"),
('James Gray',2026,'Cannes','nominated'::"awardresult"),
('Nuri Bilge Ceylan',2027,'Cannes','nominated'::"awardresult"),
('Arnaud Desplechin',2028,'Cannes','nominated'::"awardresult"),
('Ari Folman',2029,'Cannes','nominated'::"awardresult"))i(director,"year",award,"result") 
 WHERE EXISTS(SELECT FROM directors d  
 WHERE (d.director)=(i.director) 
 FOR SHARE)ON CONFLICT DO NOTHING;
INSERT INTO directorawards(director,"year",award,"result")
SELECT i.*
FROM (VALUES
('Pawel Pawlikowski',2018,'Cannes','won'::"awardresult"),
('Sofia Coppola',2017,'Cannes','won'::"awardresult"),
('Olivier Assayas',2016,'Cannes','won'::"awardresult"),
('Cristian Mungiu',2016,'Cannes','won'::"awardresult"),
('Hsiao-Hsien Hou',2015,'Cannes','won'::"awardresult"),
('Bennett Miller',2014,'Cannes','won'::"awardresult"),
('Amat Escalante',2013,'Cannes','won'::"awardresult"),
('Carlos Reygadas',2012,'Cannes','won'::"awardresult"),
('Nicolas Winding Refn',2011,'Cannes','won'::"awardresult"),
('Mathieu Amalric',2010,'Cannes','won'::"awardresult"),
('Brillante Mendoza',2009,'Cannes','won'::"awardresult"),
('Nuri Bilge Ceylan',2008,'Cannes','won'::"awardresult"),
('Julian Schnabel',2007,'Cannes','won'::"awardresult"),
('Alejandro G. Iñárritu',2006,'Cannes','won'::"awardresult"),
('Michael Haneke',2005,'Cannes','won'::"awardresult"),
('Tony Gatlif',2004,'Cannes','won'::"awardresult"),
('Gus Van Sant',2003,'Cannes','won'::"awardresult"),
('Paul Thomas Anderson',2002,'Cannes','won'::"awardresult"),
('Im Kwon-taek',2002,'Cannes','won'::"awardresult"),
('David Lynch',2001,'Cannes','won'::"awardresult"),
('Joel Coen',2001,'Cannes','won'::"awardresult"),
('Edward Yang',2000,'Cannes','won'::"awardresult"),
('Pedro Almodóvar',1999,'Cannes','won'::"awardresult"),
('John Boorman',1998,'Cannes','won'::"awardresult"),
('Kar-Wai Wong',1997,'Cannes','won'::"awardresult"),
('Joel Coen, Ethan Coen',1996,'Cannes','won'::"awardresult"),
('Mathieu Kassovitz',1995,'Cannes','won'::"awardresult"),
('Nanni Moretti',1993,'Cannes','won'::"awardresult"),
('Mike Leigh',1993,'Cannes','won'::"awardresult"),
('Robert Altman',1992,'Cannes','won'::"awardresult"),
('Joel Coen, Ethan Coen',1991,'Cannes','won'::"awardresult"),
('Pavel Lungin',1990,'Cannes','won'::"awardresult"))i(director,"year",award,"result") 
 WHERE EXISTS(SELECT FROM directors d  
 WHERE (d.director)=(i.director) 
 FOR SHARE)ON CONFLICT DO NOTHING;
INSERT INTO directorawards(director,"year",award,"result")
SELECT i.*
FROM (VALUES
('Paul Thomas Anderson',1970,'Oscar','nominated'::"awardresult"),
('Kenneth Branagh',1960,'Oscar','nominated'::"awardresult"),
('Jane Campion',1954,'Oscar','nominated'::"awardresult"),
('Ryûsuke Hamaguchi',1978,'Oscar','nominated'::"awardresult"),
('Steven Spielberg',1946,'Oscar','nominated'::"awardresult"),
('Lee Isaac Chung',1978,'Oscar','nominated'::"awardresult"),
('Emerald Fennell',1985,'Oscar','nominated'::"awardresult"),
('David Fincher',1962,'Oscar','nominated'::"awardresult"),
('Thomas Vinterberg',1969,'Oscar','nominated'::"awardresult"),
('Chloé Zhao',1982,'Oscar','nominated'::"awardresult"),
('Bong Joon Ho',1969,'Oscar','nominated'::"awardresult"),
('Sam Mendes',1965,'Oscar','nominated'::"awardresult"),
('Todd Phillips',1970,'Oscar','nominated'::"awardresult"),
('Martin Scorsese',1942,'Oscar','nominated'::"awardresult"),
('Quentin Tarantino',1963,'Oscar','nominated'::"awardresult"),
('Alfonso Cuarón',1961,'Oscar','nominated'::"awardresult"),
('Yorgos Lanthimos',1973,'Oscar','nominated'::"awardresult"),
('Spike Lee',1957,'Oscar','nominated'::"awardresult"),
('Adam McKay',1968,'Oscar','nominated'::"awardresult"),
('Pawel Pawlikowski',1957,'Oscar','nominated'::"awardresult"),
('Guillermo del Toro',1964,'Oscar','nominated'::"awardresult"),
('Greta Gerwig',1983,'Oscar','nominated'::"awardresult"),
('Christopher Nolan',1970,'Oscar','nominated'::"awardresult"),
('Jordan Peele',1979,'Oscar','nominated'::"awardresult"),
('Damien Chazelle',1985,'Oscar','nominated'::"awardresult"),
('Mel Gibson',1956,'Oscar','nominated'::"awardresult"),
('Barry Jenkins',1979,'Oscar','nominated'::"awardresult"),
('Kenneth Lonergan',1962,'Oscar','nominated'::"awardresult"),
('Denis Villeneuve',1967,'Oscar','nominated'::"awardresult"),
('Lenny Abrahamson',1966,'Oscar','nominated'::"awardresult"),
('Alejandro G. Iñárritu',1963,'Oscar','nominated'::"awardresult"),
('Tom McCarthy',1966,'Oscar','nominated'::"awardresult"),
('George Miller',1945,'Oscar','nominated'::"awardresult"),
('Wes Anderson',1969,'Oscar','nominated'::"awardresult"),
('Richard Linklater',1960,'Oscar','nominated'::"awardresult"),
('Bennett Miller',1966,'Oscar','nominated'::"awardresult"),
('Morten Tyldum',1967,'Oscar','nominated'::"awardresult"),
('Steve McQueen',1969,'Oscar','nominated'::"awardresult"),
('Alexander Payne',1961,'Oscar','nominated'::"awardresult"),
('David O. Russell',1958,'Oscar','nominated'::"awardresult"),
('Michael Haneke',1942,'Oscar','nominated'::"awardresult"),
('Ang Lee',1954,'Oscar','nominated'::"awardresult"),
('Benh Zeitlin',1982,'Oscar','nominated'::"awardresult"),
('Woody Allen',1935,'Oscar','nominated'::"awardresult"),
('Michel Hazanavicius',1967,'Oscar','nominated'::"awardresult"),
('Terrence Malick',1943,'Oscar','nominated'::"awardresult"),
('Darren Aronofsky',1969,'Oscar','nominated'::"awardresult"),
('Joel Coen',1954,'Oscar','nominated'::"awardresult"),
('Tom Hooper',1972,'Oscar','nominated'::"awardresult"),
('Kathryn Bigelow',1951,'Oscar','nominated'::"awardresult"),
('James Cameron',1954,'Oscar','nominated'::"awardresult"),
('Lee Daniels',1959,'Oscar','nominated'::"awardresult"),
('Jason Reitman',1977,'Oscar','nominated'::"awardresult"),
('Danny Boyle',1956,'Oscar','nominated'::"awardresult"),
('Stephen Daldry',1960,'Oscar','nominated'::"awardresult"),
('Ron Howard',1954,'Oscar','nominated'::"awardresult"),
('Gus Van Sant',1952,'Oscar','nominated'::"awardresult"),
('Tony Gilroy',1956,'Oscar','nominated'::"awardresult"),
('Julian Schnabel',1951,'Oscar','nominated'::"awardresult"),
('Clint Eastwood',1930,'Oscar','nominated'::"awardresult"),
('Stephen Frears',1941,'Oscar','nominated'::"awardresult"),
('Paul Greengrass',1955,'Oscar','nominated'::"awardresult"),
('George Clooney',1961,'Oscar','nominated'::"awardresult"),
('Paul Haggis',1953,'Oscar','nominated'::"awardresult"),
('Taylor Hackford',1944,'Oscar','nominated'::"awardresult"),
('Mike Leigh',1943,'Oscar','nominated'::"awardresult"),
('Sofia Coppola',1971,'Oscar','nominated'::"awardresult"),
('Peter Jackson',1961,'Oscar','nominated'::"awardresult"),
('Fernando Meirelles',1955,'Oscar','nominated'::"awardresult"),
('Peter Weir',1944,'Oscar','nominated'::"awardresult"),
('Pedro Almodóvar',1949,'Oscar','nominated'::"awardresult"),
('Rob Marshall',1960,'Oscar','nominated'::"awardresult"),
('Roman Polanski',1933,'Oscar','nominated'::"awardresult"),
('Robert Altman',1925,'Oscar','nominated'::"awardresult"),
('David Lynch',1946,'Oscar','nominated'::"awardresult"),
('Ridley Scott',1937,'Oscar','nominated'::"awardresult"),
('Steven Soderbergh',1963,'Oscar','nominated'::"awardresult"),
('Lasse Hallström',1946,'Oscar','nominated'::"awardresult"),
('Spike Jonze',1969,'Oscar','nominated'::"awardresult"),
('Michael Mann',1943,'Oscar','nominated'::"awardresult"),
('M. Night Shyamalan',1970,'Oscar','nominated'::"awardresult"),
('Roberto Benigni',1952,'Oscar','nominated'::"awardresult"),
('John Madden',1949,'Oscar','nominated'::"awardresult"),
('Peter Cattaneo',1964,'Oscar','nominated'::"awardresult"),
('Atom Egoyan',1960,'Oscar','nominated'::"awardresult"),
('Curtis Hanson',1945,'Oscar','nominated'::"awardresult"),
('Milos Forman',1932,'Oscar','nominated'::"awardresult"),
('Scott Hicks',1953,'Oscar','nominated'::"awardresult"),
('Anthony Minghella',1954,'Oscar','nominated'::"awardresult"),
('Mike Figgis',1948,'Oscar','nominated'::"awardresult"),
('Chris Noonan',1952,'Oscar','nominated'::"awardresult"),
('Michael Radford',1946,'Oscar','nominated'::"awardresult"),
('Tim Robbins',1958,'Oscar','nominated'::"awardresult"),
('Krzysztof Kieslowski',1941,'Oscar','nominated'::"awardresult"),
('Robert Redford',1936,'Oscar','nominated'::"awardresult"),
('Robert Zemeckis',1951,'Oscar','nominated'::"awardresult"),
('James Ivory',1928,'Oscar','nominated'::"awardresult"),
('Jim Sheridan',1949,'Oscar','nominated'::"awardresult"),
('Martin Brest',1951,'Oscar','nominated'::"awardresult"),
('Neil Jordan',1950,'Oscar','nominated'::"awardresult"))i(director,"year",award,"result") 
 WHERE EXISTS(SELECT FROM directors d  
 WHERE (d.director)=(i.director) 
 FOR SHARE)ON CONFLICT DO NOTHING;
INSERT INTO directorawards(director,"year",award,"result")
SELECT i.*
FROM (VALUES 
('Frank Borzage',1927,'Oscar','won'::"awardresult"),
('Frank Lloyd',1928,'Oscar','won'::"awardresult"),
('Lewis Milestone',1929,'Oscar','won'::"awardresult"),
('Norman Taurog',1930,'Oscar','won'::"awardresult"),
('Frank Borzage',1931,'Oscar','won'::"awardresult"),
('Frank Lloyd',1932,'Oscar','won'::"awardresult"),
('Frank Capra',1934,'Oscar','won'::"awardresult"),
('John Ford',1935,'Oscar','won'::"awardresult"),
('Frank Capra',1936,'Oscar','won'::"awardresult"),
('Leo McCarey',1937,'Oscar','won'::"awardresult"),
('Frank Capra',1938,'Oscar','won'::"awardresult"),
('Victor Fleming',1939,'Oscar','won'::"awardresult"),
('John Ford',1940,'Oscar','won'::"awardresult"),
('John Ford',1941,'Oscar','won'::"awardresult"),
('William Wyler',1942,'Oscar','won'::"awardresult"),
('Michael Curtiz',1943,'Oscar','won'::"awardresult"),
('Leo McCarey',1944,'Oscar','won'::"awardresult"),
('Billy Wilder',1945,'Oscar','won'::"awardresult"),
('William Wyler',1946,'Oscar','won'::"awardresult"),
('Elia Kazan',1947,'Oscar','won'::"awardresult"),
('John Huston',1948,'Oscar','won'::"awardresult"),
('Joseph Mankiewicz',1949,'Oscar','won'::"awardresult"),
('Joseph Mankiewicz',1950,'Oscar','won'::"awardresult"),
('George Stevens',1951,'Oscar','won'::"awardresult"),
('John Ford',1952,'Oscar','won'::"awardresult"),
('Fred Zinnemann',1953,'Oscar','won'::"awardresult"),
('Elia Kazan',1954,'Oscar','won'::"awardresult"),
('Delbert Mann',1955,'Oscar','won'::"awardresult"),
('George Stevens',1956,'Oscar','won'::"awardresult"),
('David Lean',1957,'Oscar','won'::"awardresult"),
('Vincente Minnelli',1958,'Oscar','won'::"awardresult"),
('William Wyler',1959,'Oscar','won'::"awardresult"),
('Billy Wilder',1960,'Oscar','won'::"awardresult"),
('Jerome Robbins and Robert Wise',1961,'Oscar','won'::"awardresult"),
('David Lean',1962,'Oscar','won'::"awardresult"),
('Tony Richardson',1963,'Oscar','won'::"awardresult"),
('George Cukor',1964,'Oscar','won'::"awardresult"),
('Robert Wise',1965,'Oscar','won'::"awardresult"),
('Fred Zinnemann',1966,'Oscar','won'::"awardresult"),
('Mike Nichols',1967,'Oscar','won'::"awardresult"),
('Carol Reed',1968,'Oscar','won'::"awardresult"),
('John Schlesinger',1969,'Oscar','won'::"awardresult"),
('Franklin Schaffner',1970,'Oscar','won'::"awardresult"),
('William Friedkin',1971,'Oscar','won'::"awardresult"),
('Bob Fosse',1972,'Oscar','won'::"awardresult"),
('George Roy Hill',1973,'Oscar','won'::"awardresult"),
('Francis Ford Coppola',1974,'Oscar','won'::"awardresult"),
('Milos Forman',1975,'Oscar','won'::"awardresult"),
('John Avildsen',1976,'Oscar','won'::"awardresult"),
('Woody Allen',1977,'Oscar','won'::"awardresult"),
('Michael Cimino',1978,'Oscar','won'::"awardresult"),
('Robert Benton',1979,'Oscar','won'::"awardresult"),
('Robert Redford',1980,'Oscar','won'::"awardresult"),
('Warren Beatty',1981,'Oscar','won'::"awardresult"),
('Richard Attenborough',1982,'Oscar','won'::"awardresult"),
('James L. Brooks',1983,'Oscar','won'::"awardresult"),
('Milos Forman',1984,'Oscar','won'::"awardresult"),
('Sydney Pollack',1985,'Oscar','won'::"awardresult"),
('Oliver Stone',1986,'Oscar','won'::"awardresult"),
('Bernardo Bertolucci',1987,'Oscar','won'::"awardresult"),
('Barry Levinson',1988,'Oscar','won'::"awardresult"),
('Oliver Stone',1989,'Oscar','won'::"awardresult"),
('Kevin Costner',1990,'Oscar','won'::"awardresult"),
('Jonathan Demme',1991,'Oscar','won'::"awardresult"),
('Clint Eastwood',1992,'Oscar','won'::"awardresult"),
('Steven Spielberg',1993,'Oscar','won'::"awardresult"),
('Robert Zemeckis',1994,'Oscar','won'::"awardresult"),
('Mel Gibson',1995,'Oscar','won'::"awardresult"),
('Anthony Minghella',1996,'Oscar','won'::"awardresult"),
('James Cameron',1997,'Oscar','won'::"awardresult"),
('Steven Spielberg',1998,'Oscar','won'::"awardresult"),
('Sam Mendes',1999,'Oscar','won'::"awardresult"),
('Steven Soderbergh',2000,'Oscar','won'::"awardresult"),
('Ron Howard',2001,'Oscar','won'::"awardresult"),
('Roman Polanski',2002,'Oscar','won'::"awardresult"),
('Peter Jackson',2003,'Oscar','won'::"awardresult"),
('Clint Eastwood',2004,'Oscar','won'::"awardresult"),
('Ang Lee',2005,'Oscar','won'::"awardresult"),
('Martin Scorsese',2006,'Oscar','won'::"awardresult"),
('Joel and Ethan Coen',2007,'Oscar','won'::"awardresult"),
('Danny Boyle',2008,'Oscar','won'::"awardresult"),
('Kathryn Bigelow',2009,'Oscar','won'::"awardresult"),
('Tom Hooper',2010,'Oscar','won'::"awardresult"),
('Michel Hazanavicius',2011,'Oscar','won'::"awardresult"),
('Ang Lee',2012,'Oscar','won'::"awardresult"),
('Alfonso Cuarón',2013,'Oscar','won'::"awardresult"),
('Alejandro González Iñárritu',2014,'Oscar','won'::"awardresult"),
('Alejandro González Iñárritu',2015,'Oscar','won'::"awardresult"),
('Damien Chazelle',2016,'Oscar','won'::"awardresult"),
('Guillermo del Toro',2017,'Oscar','won'::"awardresult"),
('Alfonso Cuarón',2018,'Oscar','won'::"awardresult"),
('Bong Joon Ho',2019,'Oscar','won'::"awardresult"),
('Chloe Zhao',2020,'Oscar','won'::"awardresult"),
('Jane Campion',2021,'Oscar','won'::"awardresult"))i(director,"year",award,"result")
WHERE EXISTS(
SELECT FROM directors d 
WHERE (d.director)=(i.director)
FOR SHARE)ON CONFLICT DO NOTHING;
INSERT INTO directorawards(director,"year",award,"result")
SELECT i.*
FROM (VALUES 
('Frank Borzage',1927,'Oscar','won'::"awardresult"),
('Frank Lloyd',1928,'Oscar','won'::"awardresult"),
('Lewis Milestone',1929,'Oscar','won'::"awardresult"),
('Norman Taurog',1930,'Oscar','won'::"awardresult"),
('Frank Borzage',1931,'Oscar','won'::"awardresult"),
('Frank Lloyd',1932,'Oscar','won'::"awardresult"),
('Frank Capra',1934,'Oscar','won'::"awardresult"),
('John Ford',1935,'Oscar','won'::"awardresult"),
('Frank Capra',1936,'Oscar','won'::"awardresult"),
('Leo McCarey',1937,'Oscar','won'::"awardresult"),
('Frank Capra',1938,'Oscar','won'::"awardresult"),
('Victor Fleming',1939,'Oscar','won'::"awardresult"),
('John Ford',1940,'Oscar','won'::"awardresult"),
('John Ford',1941,'Oscar','won'::"awardresult"),
('William Wyler',1942,'Oscar','won'::"awardresult"),
('Michael Curtiz',1943,'Oscar','won'::"awardresult"),
('Leo McCarey',1944,'Oscar','won'::"awardresult"),
('Billy Wilder',1945,'Oscar','won'::"awardresult"),
('William Wyler',1946,'Oscar','won'::"awardresult"),
('Elia Kazan',1947,'Oscar','won'::"awardresult"),
('John Huston',1948,'Oscar','won'::"awardresult"),
('Joseph Mankiewicz',1949,'Oscar','won'::"awardresult"),
('Joseph Mankiewicz',1950,'Oscar','won'::"awardresult"),
('George Stevens',1951,'Oscar','won'::"awardresult"),
('John Ford',1952,'Oscar','won'::"awardresult"),
('Fred Zinnemann',1953,'Oscar','won'::"awardresult"),
('Elia Kazan',1954,'Oscar','won'::"awardresult"),
('Delbert Mann',1955,'Oscar','won'::"awardresult"),
('George Stevens',1956,'Oscar','won'::"awardresult"),
('David Lean',1957,'Oscar','won'::"awardresult"),
('Vincente Minnelli',1958,'Oscar','won'::"awardresult"),
('William Wyler',1959,'Oscar','won'::"awardresult"),
('Billy Wilder',1960,'Oscar','won'::"awardresult"),
('Jerome Robbins and Robert Wise',1961,'Oscar','won'::"awardresult"),
('David Lean',1962,'Oscar','won'::"awardresult"),
('Tony Richardson',1963,'Oscar','won'::"awardresult"),
('George Cukor',1964,'Oscar','won'::"awardresult"),
('Robert Wise',1965,'Oscar','won'::"awardresult"),
('Fred Zinnemann',1966,'Oscar','won'::"awardresult"),
('Mike Nichols',1967,'Oscar','won'::"awardresult"),
('Carol Reed',1968,'Oscar','won'::"awardresult"),
('John Schlesinger',1969,'Oscar','won'::"awardresult"),
('Franklin Schaffner',1970,'Oscar','won'::"awardresult"),
('William Friedkin',1971,'Oscar','won'::"awardresult"),
('Bob Fosse',1972,'Oscar','won'::"awardresult"),
('George Roy Hill',1973,'Oscar','won'::"awardresult"),
('Francis Ford Coppola',1974,'Oscar','won'::"awardresult"),
('Milos Forman',1975,'Oscar','won'::"awardresult"),
('John Avildsen',1976,'Oscar','won'::"awardresult"),
('Woody Allen',1977,'Oscar','won'::"awardresult"),
('Michael Cimino',1978,'Oscar','won'::"awardresult"),
('Robert Benton',1979,'Oscar','won'::"awardresult"),
('Robert Redford',1980,'Oscar','won'::"awardresult"),
('Warren Beatty',1981,'Oscar','won'::"awardresult"),
('Richard Attenborough',1982,'Oscar','won'::"awardresult"),
('James L. Brooks',1983,'Oscar','won'::"awardresult"),
('Milos Forman',1984,'Oscar','won'::"awardresult"),
('Sydney Pollack',1985,'Oscar','won'::"awardresult"),
('Oliver Stone',1986,'Oscar','won'::"awardresult"),
('Bernardo Bertolucci',1987,'Oscar','won'::"awardresult"),
('Barry Levinson',1988,'Oscar','won'::"awardresult"),
('Oliver Stone',1989,'Oscar','won'::"awardresult"),
('Kevin Costner',1990,'Oscar','won'::"awardresult"),
('Jonathan Demme',1991,'Oscar','won'::"awardresult"),
('Clint Eastwood',1992,'Oscar','won'::"awardresult"),
('Steven Spielberg',1993,'Oscar','won'::"awardresult"),
('Robert Zemeckis',1994,'Oscar','won'::"awardresult"),
('Mel Gibson',1995,'Oscar','won'::"awardresult"),
('Anthony Minghella',1996,'Oscar','won'::"awardresult"),
('James Cameron',1997,'Oscar','won'::"awardresult"),
('Steven Spielberg',1998,'Oscar','won'::"awardresult"),
('Sam Mendes',1999,'Oscar','won'::"awardresult"),
('Steven Soderbergh',2000,'Oscar','won'::"awardresult"),
('Ron Howard',2001,'Oscar','won'::"awardresult"),
('Roman Polanski',2002,'Oscar','won'::"awardresult"),
('Peter Jackson',2003,'Oscar','won'::"awardresult"),
('Clint Eastwood',2004,'Oscar','won'::"awardresult"),
('Ang Lee',2005,'Oscar','won'::"awardresult"),
('Martin Scorsese',2006,'Oscar','won'::"awardresult"),
('Joel and Ethan Coen',2007,'Oscar','won'::"awardresult"),
('Danny Boyle',2008,'Oscar','won'::"awardresult"),
('Kathryn Bigelow',2009,'Oscar','won'::"awardresult"),
('Tom Hooper',2010,'Oscar','won'::"awardresult"),
('Michel Hazanavicius',2011,'Oscar','won'::"awardresult"),
('Ang Lee',2012,'Oscar','won'::"awardresult"),
('Alfonso Cuarón',2013,'Oscar','won'::"awardresult"),
('Alejandro González Iñárritu',2014,'Oscar','won'::"awardresult"),
('Alejandro González Iñárritu',2015,'Oscar','won'::"awardresult"),
('Damien Chazelle',2016,'Oscar','won'::"awardresult"),
('Guillermo del Toro',2017,'Oscar','won'::"awardresult"),
('Alfonso Cuarón',2018,'Oscar','won'::"awardresult"),
('Bong Joon Ho',2019,'Oscar','won'::"awardresult"),
('Chloe Zhao',2020,'Oscar','won'::"awardresult"),
('Jane Campion',2021,'Oscar','won'::"awardresult"))i(director,"year",award,"result")
WHERE EXISTS(
SELECT FROM directors d 
WHERE (d.director)=(i.director)
FOR SHARE)ON CONFLICT DO NOTHING;
INSERT INTO movieawards(title,"year",award,"result")
SELECT i.*
FROM (VALUES
('The Dove',1927,'Oscar, best production','won'::"awardresult"),
('Tempest',1928,'Oscar, best production','won'::"awardresult"),
('The Bridge of San Luis Rey',1929,'Oscar, best production','won'::"awardresult"),
('King of Jazz',1930,'Oscar, best production','won'::"awardresult"),
('Cimarron',1931,'Oscar, best production','won'::"awardresult"),
('Transatlantic',1931,'Oscar, best production','won'::"awardresult"),
('Cavalcade',1933,'Oscar, best production','won'::"awardresult"),
('The Merry Widow',1934,'Oscar, best production','won'::"awardresult"),
('The Dark Angel',1935,'Oscar, best production','won'::"awardresult"),
('Dodsworth',1936,'Oscar, best production','won'::"awardresult"),
('Lost Horizon',1937,'Oscar, best production','won'::"awardresult"),
('The Adventures of Robin Hood',1938,'Oscar, best production','won'::"awardresult"),
('Gone with the Wind',1939,'Oscar, best production','won'::"awardresult"),
('Pride and Prejudice',1940,'Oscar, best production','won'::"awardresult"),
('The Thief of Bagdad',1940,'Oscar, best production','won'::"awardresult"),
('How Green Was My Valley',1941,'Oscar, best production','won'::"awardresult"),
('Blossoms in the Dust',1941,'Oscar, best production','won'::"awardresult"),
('This Above All',1942,'Oscar, best production','won'::"awardresult"),
('My Gal Sal',1942,'Oscar, best production','won'::"awardresult"),
('The Song of Bernadette',1943,'Oscar, best production','won'::"awardresult"),
('Phantom of the Opera',1943,'Oscar, best production','won'::"awardresult"),
('Gaslight',1944,'Oscar, best production','won'::"awardresult"),
('Wilson',1944,'Oscar, best production','won'::"awardresult"),
('Blood on the Sun',1945,'Oscar, best production','won'::"awardresult"),
('Frenchman''s Creek',1944,'Oscar, best production','won'::"awardresult"),
('Anna and the King of Siam',1946,'Oscar, best production','won'::"awardresult"),
('The Yearling',1946,'Oscar, best production','won'::"awardresult"),
('Great Expectations',1946,'Oscar, best production','won'::"awardresult"),
('Black Narcissus',1947,'Oscar, best production','won'::"awardresult"),
('Hamlet',1948,'Oscar, best production','won'::"awardresult"),
('The Red Shoes',1948,'Oscar, best production','won'::"awardresult"),
('The Heiress',1949,'Oscar, best production','won'::"awardresult"),
('Little Women',1949,'Oscar, best production','won'::"awardresult"),
('Sunset Blvd.',1950,'Oscar, best production','won'::"awardresult"),
('Samson and Delilah',1949,'Oscar, best production','won'::"awardresult"),
('A Streetcar Named Desire',1951,'Oscar, best production','won'::"awardresult"),
('An American in Paris',1951,'Oscar, best production','won'::"awardresult"),
('The Bad and the Beautiful',1952,'Oscar, best production','won'::"awardresult"),
('Moulin Rouge',1952,'Oscar, best production','won'::"awardresult"),
('Julius Caesar',1953,'Oscar, best production','won'::"awardresult"),
('The Robe',1953,'Oscar, best production','won'::"awardresult"),
('On the Waterfront',1954,'Oscar, best production','won'::"awardresult"),
('20,000 Leagues Under the Sea',1954,'Oscar, best production','won'::"awardresult"),
('The Rose Tattoo',1955,'Oscar, best production','won'::"awardresult"),
('Somebody Up There Likes Me',1956,'Oscar, best production','won'::"awardresult"),
('Picnic',1955,'Oscar, best production','won'::"awardresult"),
('The King and I',1956,'Oscar, best production','won'::"awardresult"),
('Sayonara',1957,'Oscar, best production','won'::"awardresult"),
('Gigi',1958,'Oscar, best production','won'::"awardresult"),
('The Diary of Anne Frank',1959,'Oscar, best production','won'::"awardresult"),
('Ben-Hur',1959,'Oscar, best production','won'::"awardresult"),
('The Apartment',1960,'Oscar, best production','won'::"awardresult"),
('Spartacus',1960,'Oscar, best production','won'::"awardresult"),
('The Hustler',1961,'Oscar, best production','won'::"awardresult"),
('West Side Story',1961,'Oscar, best production','won'::"awardresult"),
('To Kill a Mockingbird',1962,'Oscar, best production','won'::"awardresult"),
('Lawrence of Arabia',1962,'Oscar, best production','won'::"awardresult"),
('America America',1963,'Oscar, best production','won'::"awardresult"),
('Cleopatra',1963,'Oscar, best production','won'::"awardresult"),
('Alexis Zorbas',1964,'Oscar, best production','won'::"awardresult"),
('My Fair Lady',1964,'Oscar, best production','won'::"awardresult"),
('Ship of Fools',1965,'Oscar, best production','won'::"awardresult"),
('Doctor Zhivago',1965,'Oscar, best production','won'::"awardresult"),
('Who''s Afraid of Virginia Woolf?',1966,'Oscar, best production','won'::"awardresult"),
('Fantastic Voyage',1966,'Oscar, best production','won'::"awardresult"),
('Camelot',1967,'Oscar, best production','won'::"awardresult"),
('Oliver!',1968,'Oscar, best production','won'::"awardresult"),
('Hello, Dolly!',1969,'Oscar, best production','won'::"awardresult"),
('Patton',1970,'Oscar, best production','won'::"awardresult"),
('Nicholas and Alexandra',1971,'Oscar, best production','won'::"awardresult"),
('Cabaret',1972,'Oscar, best production','won'::"awardresult"),
('The Sting',1973,'Oscar, best production','won'::"awardresult"),
('The Godfather Part II',1974,'Oscar, best production','won'::"awardresult"),
('Barry Lyndon',1975,'Oscar, best production','won'::"awardresult"),
('All the President''s Men',1976,'Oscar, best production','won'::"awardresult"),
('Star Wars',1977,'Oscar, best production','won'::"awardresult"),
('Heaven Can Wait',1978,'Oscar, best production','won'::"awardresult"),
('All That Jazz',1979,'Oscar, best production','won'::"awardresult"),
('Tess',1979,'Oscar, best production','won'::"awardresult"),
('Raiders of the Lost Ark',1981,'Oscar, best production','won'::"awardresult"),
('Gandhi',1982,'Oscar, best production','won'::"awardresult"),
('Fanny och Alexander',1982,'Oscar, best production','won'::"awardresult"),
('Amadeus',1984,'Oscar, best production','won'::"awardresult"),
('Out of Africa',1985,'Oscar, best production','won'::"awardresult"),
('A Room with a View',1985,'Oscar, best production','won'::"awardresult"),
('The Last Emperor',1987,'Oscar, best production','won'::"awardresult"),
('Dangerous Liaisons',1988,'Oscar, best production','won'::"awardresult"),
('Batman',1989,'Oscar, best production','won'::"awardresult"),
('Dick Tracy',1990,'Oscar, best production','won'::"awardresult"),
('Bugsy',1991,'Oscar, best production','won'::"awardresult"),
('Howards End',1992,'Oscar, best production','won'::"awardresult"),
('Schindler''s List',1993,'Oscar, best production','won'::"awardresult"),
('The Madness of King George',1994,'Oscar, best production','won'::"awardresult"),
('Restoration',1995,'Oscar, best production','won'::"awardresult"),
('The English Patient',1996,'Oscar, best production','won'::"awardresult"),
('Titanic',1997,'Oscar, best production','won'::"awardresult"),
('Shakespeare in Love',1998,'Oscar, best production','won'::"awardresult"),
('Sleepy Hollow',1999,'Oscar, best production','won'::"awardresult"),
('Wo hu cang long',2000,'Oscar, best production','won'::"awardresult"),
('Moulin Rouge!',2001,'Oscar, best production','won'::"awardresult"),
('Chicago',2002,'Oscar, best production','won'::"awardresult"),
('The Lord of the Rings: The Return of the King',2003,'Oscar, best production','won'::"awardresult"),
('The Aviator',2004,'Oscar, best production','won'::"awardresult"),
('Memoirs of a Geisha',2005,'Oscar, best production','won'::"awardresult"),
('El laberinto del fauno',2006,'Oscar, best production','won'::"awardresult"),
('Sweeney Todd: The Demon Barber of Fleet Street',2007,'Oscar, best production','won'::"awardresult"),
('The Curious Case of Benjamin Button',2008,'Oscar, best production','won'::"awardresult"),
('Avatar',2009,'Oscar, best production','won'::"awardresult"),
('Alice in Wonderland',2010,'Oscar, best production','won'::"awardresult"),
('Hugo',2011,'Oscar, best production','won'::"awardresult"),
('Lincoln',2012,'Oscar, best production','won'::"awardresult"),
('The Great Gatsby',2013,'Oscar, best production','won'::"awardresult"),
('The Grand Budapest Hotel',2014,'Oscar, best production','won'::"awardresult"),
('Mad Max: Fury Road',2015,'Oscar, best production','won'::"awardresult"),
('La La Land',2016,'Oscar, best production','won'::"awardresult"),
('The Shape of Water',2017,'Oscar, best production','won'::"awardresult"),
('Black Panther',2018,'Oscar, best production','won'::"awardresult"),
('Once Upon a Time... in Hollywood',2019,'Oscar, best production','won'::"awardresult"),
('Mank',2020,'Oscar, best production','won'::"awardresult"),
('Dune: Part One',2021,'Oscar, best production','won'::"awardresult"))i(title,"year",award,"result") 
 WHERE EXISTS(SELECT FROM movies m  
 WHERE (m.title)=(i.title) AND (m.year)=(i.year)  
 FOR SHARE)
ON CONFLICT DO NOTHING;
INSERT INTO movieawards(title,"year",award,"result")
SELECT i.*
FROM (VALUES
('Belfast',2021,'Oscar, best screenplay','nominated'::"awardresult"),
('Don''t Look Up',2021,'Oscar, best screenplay','nominated'::"awardresult"),
('King Richard',2021,'Oscar, best screenplay','nominated'::"awardresult"),
('Licorice Pizza',2021,'Oscar, best screenplay','nominated'::"awardresult"),
('Verdens verste menneske',2021,'Oscar, best screenplay','nominated'::"awardresult"),
('Promising Young Woman',2020,'Oscar, best screenplay','nominated'::"awardresult"),
('Judas and the Black Messiah',2021,'Oscar, best screenplay','nominated'::"awardresult"),
('Minari',2020,'Oscar, best screenplay','nominated'::"awardresult"),
('Sound of Metal',2019,'Oscar, best screenplay','nominated'::"awardresult"),
('The Trial of the Chicago 7',2020,'Oscar, best screenplay','nominated'::"awardresult"),
('Gisaengchung',2019,'Oscar, best screenplay','nominated'::"awardresult"),
('1917',2019,'Oscar, best screenplay','nominated'::"awardresult"),
('Knives Out',2019,'Oscar, best screenplay','nominated'::"awardresult"),
('Marriage Story',2019,'Oscar, best screenplay','nominated'::"awardresult"),
('Once Upon a Time... in Hollywood',2019,'Oscar, best screenplay','nominated'::"awardresult"),
('Green Book',2018,'Oscar, best screenplay','nominated'::"awardresult"),
('The Favourite',2018,'Oscar, best screenplay','nominated'::"awardresult"),
('First Reformed',2017,'Oscar, best screenplay','nominated'::"awardresult"),
('Roma',2018,'Oscar, best screenplay','nominated'::"awardresult"),
('Vice',2018,'Oscar, best screenplay','nominated'::"awardresult"),
('Get Out',2017,'Oscar, best screenplay','nominated'::"awardresult"),
('The Big Sick',2017,'Oscar, best screenplay','nominated'::"awardresult"),
('Lady Bird',2017,'Oscar, best screenplay','nominated'::"awardresult"),
('The Shape of Water',2017,'Oscar, best screenplay','nominated'::"awardresult"),
('Three Billboards Outside Ebbing, Missouri',2017,'Oscar, best screenplay','nominated'::"awardresult"),
('Manchester by the Sea',2016,'Oscar, best screenplay','nominated'::"awardresult"),
('20th Century Women',2016,'Oscar, best screenplay','nominated'::"awardresult"),
('Hell or High Water',2016,'Oscar, best screenplay','nominated'::"awardresult"),
('La La Land',2016,'Oscar, best screenplay','nominated'::"awardresult"),
('The Lobster',2015,'Oscar, best screenplay','nominated'::"awardresult"),
('Spotlight',2015,'Oscar, best screenplay','nominated'::"awardresult"),
('Bridge of Spies',2015,'Oscar, best screenplay','nominated'::"awardresult"),
('Ex Machina',2014,'Oscar, best screenplay','nominated'::"awardresult"),
('Inside Out',2015,'Oscar, best screenplay','nominated'::"awardresult"),
('Straight Outta Compton',2015,'Oscar, best screenplay','nominated'::"awardresult"),
('Birdman or (The Unexpected Virtue of Ignorance)',2014,'Oscar, best screenplay','nominated'::"awardresult"),
('Boyhood',2014,'Oscar, best screenplay','nominated'::"awardresult"),
('Foxcatcher',2014,'Oscar, best screenplay','nominated'::"awardresult"),
('Nightcrawler',2014,'Oscar, best screenplay','nominated'::"awardresult"),
('The Grand Budapest Hotel',2014,'Oscar, best screenplay','nominated'::"awardresult"),
('Her',2013,'Oscar, best screenplay','nominated'::"awardresult"),
('American Hustle',2013,'Oscar, best screenplay','nominated'::"awardresult"),
('Blue Jasmine',2013,'Oscar, best screenplay','nominated'::"awardresult"),
('Dallas Buyers Club',2013,'Oscar, best screenplay','nominated'::"awardresult"),
('Nebraska',2013,'Oscar, best screenplay','nominated'::"awardresult"),
('Django Unchained',2012,'Oscar, best screenplay','nominated'::"awardresult"),
('Amour',2012,'Oscar, best screenplay','nominated'::"awardresult"),
('Flight',2012,'Oscar, best screenplay','nominated'::"awardresult"),
('Moonrise Kingdom',2012,'Oscar, best screenplay','nominated'::"awardresult"),
('Zero Dark Thirty',2012,'Oscar, best screenplay','nominated'::"awardresult"),
('Midnight in Paris',2011,'Oscar, best screenplay','nominated'::"awardresult"),
('Jodaeiye Nader az Simin',2011,'Oscar, best screenplay','nominated'::"awardresult"),
('Bridesmaids',2011,'Oscar, best screenplay','nominated'::"awardresult"),
('Margin Call',2011,'Oscar, best screenplay','nominated'::"awardresult"),
('The Artist',2011,'Oscar, best screenplay','nominated'::"awardresult"),
('The King''s Speech',2010,'Oscar, best screenplay','nominated'::"awardresult"),
('Another Year',2010,'Oscar, best screenplay','nominated'::"awardresult"),
('Inception',2010,'Oscar, best screenplay','nominated'::"awardresult"),
('The Fighter',2010,'Oscar, best screenplay','nominated'::"awardresult"),
('The Kids Are All Right',2010,'Oscar, best screenplay','nominated'::"awardresult"),
('The Hurt Locker',2008,'Oscar, best screenplay','nominated'::"awardresult"),
('A Serious Man',2009,'Oscar, best screenplay','nominated'::"awardresult"),
('Inglourious Basterds',2009,'Oscar, best screenplay','nominated'::"awardresult"),
('The Messenger',2009,'Oscar, best screenplay','nominated'::"awardresult"),
('Up',2009,'Oscar, best screenplay','nominated'::"awardresult"),
('Milk',2008,'Oscar, best screenplay','nominated'::"awardresult"),
('Frozen River',2008,'Oscar, best screenplay','nominated'::"awardresult"),
('Happy-Go-Lucky',2008,'Oscar, best screenplay','nominated'::"awardresult"),
('In Bruges',2008,'Oscar, best screenplay','nominated'::"awardresult"),
('WALL·E',2008,'Oscar, best screenplay','nominated'::"awardresult"),
('Juno',2007,'Oscar, best screenplay','nominated'::"awardresult"),
('Lars and the Real Girl',2007,'Oscar, best screenplay','nominated'::"awardresult"),
('Michael Clayton',2007,'Oscar, best screenplay','nominated'::"awardresult"),
('Ratatouille',2007,'Oscar, best screenplay','nominated'::"awardresult"),
('The Savages',2007,'Oscar, best screenplay','nominated'::"awardresult"),
('Little Miss Sunshine',2006,'Oscar, best screenplay','nominated'::"awardresult"),
('Babel',2006,'Oscar, best screenplay','nominated'::"awardresult"),
('Letters from Iwo Jima',2006,'Oscar, best screenplay','nominated'::"awardresult"),
('El laberinto del fauno',2006,'Oscar, best screenplay','nominated'::"awardresult"),
('The Queen',2006,'Oscar, best screenplay','nominated'::"awardresult"),
('Crash',2004,'Oscar, best screenplay','nominated'::"awardresult"),
('Good Night, and Good Luck.',2005,'Oscar, best screenplay','nominated'::"awardresult"),
('Match Point',2005,'Oscar, best screenplay','nominated'::"awardresult"),
('Syriana',2005,'Oscar, best screenplay','nominated'::"awardresult"),
('The Squid and the Whale',2005,'Oscar, best screenplay','nominated'::"awardresult"),
('Eternal Sunshine of the Spotless Mind',2004,'Oscar, best screenplay','nominated'::"awardresult"),
('Hotel Rwanda',2004,'Oscar, best screenplay','nominated'::"awardresult"),
('The Aviator',2004,'Oscar, best screenplay','nominated'::"awardresult"),
('The Incredibles',2004,'Oscar, best screenplay','nominated'::"awardresult"),
('Vera Drake',2004,'Oscar, best screenplay','nominated'::"awardresult"),
('Lost in Translation',2003,'Oscar, best screenplay','nominated'::"awardresult"),
('Dirty Pretty Things',2002,'Oscar, best screenplay','nominated'::"awardresult"),
('Finding Nemo',2003,'Oscar, best screenplay','nominated'::"awardresult"),
('In America',2002,'Oscar, best screenplay','nominated'::"awardresult"),
('Les invasions barbares',2003,'Oscar, best screenplay','nominated'::"awardresult"),
('Hable con ella',2002,'Oscar, best screenplay','nominated'::"awardresult"),
('Far from Heaven',2002,'Oscar, best screenplay','nominated'::"awardresult"),
('Gangs of New York',2002,'Oscar, best screenplay','nominated'::"awardresult"),
('My Big Fat Greek Wedding',2002,'Oscar, best screenplay','nominated'::"awardresult"),
('Y tu mamá también',2001,'Oscar, best screenplay','nominated'::"awardresult"),
('Gosford Park',2001,'Oscar, best screenplay','nominated'::"awardresult"),
('Le fabuleux destin d''Amélie Poulain',2001,'Oscar, best screenplay','nominated'::"awardresult"),
('Memento',2000,'Oscar, best screenplay','nominated'::"awardresult"),
('Monster''s Ball',2001,'Oscar, best screenplay','nominated'::"awardresult"),
('The Royal Tenenbaums',2001,'Oscar, best screenplay','nominated'::"awardresult"),
('Almost Famous',2000,'Oscar, best screenplay','nominated'::"awardresult"),
('Billy Elliot',2000,'Oscar, best screenplay','nominated'::"awardresult"),
('Erin Brockovich',2000,'Oscar, best screenplay','nominated'::"awardresult"),
('Gladiator',2000,'Oscar, best screenplay','nominated'::"awardresult"),
('You Can Count on Me',2000,'Oscar, best screenplay','nominated'::"awardresult"),
('American Beauty',1999,'Oscar, best screenplay','nominated'::"awardresult"),
('Being John Malkovich',1999,'Oscar, best screenplay','nominated'::"awardresult"),
('Magnolia',1999,'Oscar, best screenplay','nominated'::"awardresult"),
('The Sixth Sense',1999,'Oscar, best screenplay','nominated'::"awardresult"),
('Topsy-Turvy',1999,'Oscar, best screenplay','nominated'::"awardresult"),
('Shakespeare in Love',1998,'Oscar, best screenplay','nominated'::"awardresult"),
('Bulworth',1998,'Oscar, best screenplay','nominated'::"awardresult"),
('La vita è bella',1997,'Oscar, best screenplay','nominated'::"awardresult"),
('Saving Private Ryan',1998,'Oscar, best screenplay','nominated'::"awardresult"),
('The Truman Show',1998,'Oscar, best screenplay','nominated'::"awardresult"),
('Good Will Hunting',1997,'Oscar, best screenplay','nominated'::"awardresult"),
('As Good as It Gets',1997,'Oscar, best screenplay','nominated'::"awardresult"),
('Boogie Nights',1997,'Oscar, best screenplay','nominated'::"awardresult"),
('Deconstructing Harry',1997,'Oscar, best screenplay','nominated'::"awardresult"),
('The Full Monty',1997,'Oscar, best screenplay','nominated'::"awardresult"),
('Fargo',1996,'Oscar, best screenplay','nominated'::"awardresult"),
('Jerry Maguire',1996,'Oscar, best screenplay','nominated'::"awardresult"),
('Lone Star',1996,'Oscar, best screenplay','nominated'::"awardresult"),
('Secrets & Lies',1996,'Oscar, best screenplay','nominated'::"awardresult"),
('Shine',1996,'Oscar, best screenplay','nominated'::"awardresult"),
('The Usual Suspects',1995,'Oscar, best screenplay','nominated'::"awardresult"),
('Braveheart',1995,'Oscar, best screenplay','nominated'::"awardresult"),
('Mighty Aphrodite',1995,'Oscar, best screenplay','nominated'::"awardresult"),
('Nixon',1995,'Oscar, best screenplay','nominated'::"awardresult"),
('Toy Story',1995,'Oscar, best screenplay','nominated'::"awardresult"),
('Pulp Fiction',1994,'Oscar, best screenplay','nominated'::"awardresult"),
('Bullets Over Broadway',1994,'Oscar, best screenplay','nominated'::"awardresult"),
('Four Weddings and a Funeral',1994,'Oscar, best screenplay','nominated'::"awardresult"),
('Heavenly Creatures',1994,'Oscar, best screenplay','nominated'::"awardresult"),
('Trois couleurs: Rouge',1994,'Oscar, best screenplay','nominated'::"awardresult"),
('The Piano',1993,'Oscar, best screenplay','nominated'::"awardresult"),
('Dave',1993,'Oscar, best screenplay','nominated'::"awardresult"),
('In the Line of Fire',1993,'Oscar, best screenplay','nominated'::"awardresult"),
('Philadelphia',1993,'Oscar, best screenplay','nominated'::"awardresult"),
('Sleepless in Seattle',1993,'Oscar, best screenplay','nominated'::"awardresult"),
('The Crying Game',1992,'Oscar, best screenplay','nominated'::"awardresult"),
('Husbands and Wives',1992,'Oscar, best screenplay','nominated'::"awardresult"),
('Lorenzo''s Oil',1992,'Oscar, best screenplay','nominated'::"awardresult"),
('Passion Fish',1992,'Oscar, best screenplay','nominated'::"awardresult"),
('Unforgiven',1992,'Oscar, best screenplay','nominated'::"awardresult"),
('Thelma & Louise',1991,'Oscar, best screenplay','nominated'::"awardresult"),
('Boyz n the Hood',1991,'Oscar, best screenplay','nominated'::"awardresult"),
('Bugsy',1991,'Oscar, best screenplay','nominated'::"awardresult"),
('The Fisher King',1991,'Oscar, best screenplay','nominated'::"awardresult"),
('Grand Canyon',1991,'Oscar, best screenplay','nominated'::"awardresult"),
('Ghost',1990,'Oscar, best screenplay','nominated'::"awardresult"),
('Alice',1990,'Oscar, best screenplay','nominated'::"awardresult"),
('Avalon',1990,'Oscar, best screenplay','nominated'::"awardresult"),
('Green Card',1990,'Oscar, best screenplay','nominated'::"awardresult"),
('Metropolitan',1990,'Oscar, best screenplay','nominated'::"awardresult"),
('Dead Poets Society',1989,'Oscar, best screenplay','nominated'::"awardresult"),
('Crimes and Misdemeanors',1989,'Oscar, best screenplay','nominated'::"awardresult"),
('Do the Right Thing',1989,'Oscar, best screenplay','nominated'::"awardresult"),
('Sex, Lies, and Videotape',1989,'Oscar, best screenplay','nominated'::"awardresult"),
('When Harry Met Sally...',1989,'Oscar, best screenplay','nominated'::"awardresult"),
('Rain Man',1988,'Oscar, best screenplay','nominated'::"awardresult"),
('Big',1988,'Oscar, best screenplay','nominated'::"awardresult"),
('Bull Durham',1988,'Oscar, best screenplay','nominated'::"awardresult"),
('A Fish Called Wanda',1988,'Oscar, best screenplay','nominated'::"awardresult"),
('Running on Empty',1988,'Oscar, best screenplay','nominated'::"awardresult"),
('Moonstruck',1987,'Oscar, best screenplay','nominated'::"awardresult"),
('Au revoir les enfants',1987,'Oscar, best screenplay','nominated'::"awardresult"),
('Broadcast News',1987,'Oscar, best screenplay','nominated'::"awardresult"),
('Hope and Glory',1987,'Oscar, best screenplay','nominated'::"awardresult"),
('Radio Days',1987,'Oscar, best screenplay','nominated'::"awardresult"),
('Hannah and Her Sisters',1986,'Oscar, best screenplay','nominated'::"awardresult"),
('Crocodile Dundee',1986,'Oscar, best screenplay','nominated'::"awardresult"),
('My Beautiful Laundrette',1985,'Oscar, best screenplay','nominated'::"awardresult"),
('Platoon',1986,'Oscar, best screenplay','nominated'::"awardresult"),
('Salvador',1986,'Oscar, best screenplay','nominated'::"awardresult"),
('Witness',1985,'Oscar, best screenplay','nominated'::"awardresult"),
('Back to the Future',1985,'Oscar, best screenplay','nominated'::"awardresult"),
('Brazil',1985,'Oscar, best screenplay','nominated'::"awardresult"),
('La historia oficial',1985,'Oscar, best screenplay','nominated'::"awardresult"),
('The Purple Rose of Cairo',1985,'Oscar, best screenplay','nominated'::"awardresult"),
('Places in the Heart',1984,'Oscar, best screenplay','nominated'::"awardresult"),
('Beverly Hills Cop',1984,'Oscar, best screenplay','nominated'::"awardresult"),
('Broadway Danny Rose',1984,'Oscar, best screenplay','nominated'::"awardresult"),
('El Norte',1983,'Oscar, best screenplay','nominated'::"awardresult"),
('Splash',1983,'Oscar, best screenplay','nominated'::"awardresult"),
('Tender Mercies',1983,'Oscar, best screenplay','nominated'::"awardresult"),
('The Big Chill',1983,'Oscar, best screenplay','nominated'::"awardresult"),
('Fanny och Alexander',1982,'Oscar, best screenplay','nominated'::"awardresult"),
('Silkwood',1983,'Oscar, best screenplay','nominated'::"awardresult"),
('WarGames',1983,'Oscar, best screenplay','nominated'::"awardresult"),
('Gandhi',1982,'Oscar, best screenplay','nominated'::"awardresult"),
('Diner',1982,'Oscar, best screenplay','nominated'::"awardresult"),
('E.T. the Extra-Terrestrial',1982,'Oscar, best screenplay','nominated'::"awardresult"),
('An Officer and a Gentleman',1982,'Oscar, best screenplay','nominated'::"awardresult"),
('Tootsie',1982,'Oscar, best screenplay','nominated'::"awardresult"),
('Chariots of Fire',1981,'Oscar, best screenplay','nominated'::"awardresult"),
('Absence of Malice',1981,'Oscar, best screenplay','nominated'::"awardresult"),
('Arthur',1981,'Oscar, best screenplay','nominated'::"awardresult"),
('Atlantic City',1980,'Oscar, best screenplay','nominated'::"awardresult"),
('Reds',1981,'Oscar, best screenplay','nominated'::"awardresult"),
('Melvin and Howard',1980,'Oscar, best screenplay','nominated'::"awardresult"),
('Brubaker',1980,'Oscar, best screenplay','nominated'::"awardresult"),
('Fame',1980,'Oscar, best screenplay','nominated'::"awardresult"),
('Mon oncle d''Amérique',1980,'Oscar, best screenplay','nominated'::"awardresult"),
('Private Benjamin',1980,'Oscar, best screenplay','nominated'::"awardresult"),
('Breaking Away',1979,'Oscar, best screenplay','nominated'::"awardresult"),
('All That Jazz',1979,'Oscar, best screenplay','nominated'::"awardresult"),
('...and justice for all.',1979,'Oscar, best screenplay','nominated'::"awardresult"),
('The China Syndrome',1979,'Oscar, best screenplay','nominated'::"awardresult"),
('Manhattan',1979,'Oscar, best screenplay','nominated'::"awardresult"),
('Coming Home',1978,'Oscar, best screenplay','nominated'::"awardresult"),
('Höstsonaten',1978,'Oscar, best screenplay','nominated'::"awardresult"),
('The Deer Hunter',1978,'Oscar, best screenplay','nominated'::"awardresult"),
('Interiors',1978,'Oscar, best screenplay','nominated'::"awardresult"),
('An Unmarried Woman',1978,'Oscar, best screenplay','nominated'::"awardresult"),
('Annie Hall',1977,'Oscar, best screenplay','nominated'::"awardresult"),
('The Goodbye Girl',1977,'Oscar, best screenplay','nominated'::"awardresult"),
('The Late Show',1977,'Oscar, best screenplay','nominated'::"awardresult"),
('Star Wars',1977,'Oscar, best screenplay','nominated'::"awardresult"),
('The Turning Point',1977,'Oscar, best screenplay','nominated'::"awardresult"),
('Network',1976,'Oscar, best screenplay','nominated'::"awardresult"),
('Cousin cousine',1975,'Oscar, best screenplay','nominated'::"awardresult"),
('The Front',1976,'Oscar, best screenplay','nominated'::"awardresult"),
('Rocky',1976,'Oscar, best screenplay','nominated'::"awardresult"),
('Pasqualino Settebellezze',1975,'Oscar, best screenplay','nominated'::"awardresult"),
('Dog Day Afternoon',1975,'Oscar, best screenplay','nominated'::"awardresult"),
('Amarcord',1973,'Oscar, best screenplay','nominated'::"awardresult"),
('Toute une vie',1974,'Oscar, best screenplay','nominated'::"awardresult"),
('Lies My Father Told Me',1975,'Oscar, best screenplay','nominated'::"awardresult"),
('Shampoo',1975,'Oscar, best screenplay','nominated'::"awardresult"),
('Chinatown',1974,'Oscar, best screenplay','nominated'::"awardresult"),
('Alice Doesn''t Live Here Anymore',1974,'Oscar, best screenplay','nominated'::"awardresult"),
('The Conversation',1974,'Oscar, best screenplay','nominated'::"awardresult"),
('La nuit américaine',1973,'Oscar, best screenplay','nominated'::"awardresult"),
('Harry and Tonto',1974,'Oscar, best screenplay','nominated'::"awardresult"),
('The Sting',1973,'Oscar, best screenplay','nominated'::"awardresult"),
('American Graffiti',1973,'Oscar, best screenplay','nominated'::"awardresult"),
('Viskningar och rop',1972,'Oscar, best screenplay','nominated'::"awardresult"),
('Save the Tiger',1973,'Oscar, best screenplay','nominated'::"awardresult"),
('A Touch of Class',1973,'Oscar, best screenplay','nominated'::"awardresult"),
('The Candidate',1972,'Oscar, best screenplay','nominated'::"awardresult"),
('Le charme discret de la bourgeoisie',1972,'Oscar, best screenplay','nominated'::"awardresult"),
('Lady Sings the Blues',1972,'Oscar, best screenplay','nominated'::"awardresult"),
('Le souffle au coeur',1971,'Oscar, best screenplay','nominated'::"awardresult"),
('Young Winston',1972,'Oscar, best screenplay','nominated'::"awardresult"),
('The Hospital',1971,'Oscar, best screenplay','nominated'::"awardresult"),
('Indagine su un cittadino al di sopra di ogni sospetto',1970,'Oscar, best screenplay','nominated'::"awardresult"),
('Klute',1971,'Oscar, best screenplay','nominated'::"awardresult"),
('Summer of ''42',1971,'Oscar, best screenplay','nominated'::"awardresult"),
('Sunday Bloody Sunday',1971,'Oscar, best screenplay','nominated'::"awardresult"),
('Patton',1970,'Oscar, best screenplay','nominated'::"awardresult"),
('Five Easy Pieces',1970,'Oscar, best screenplay','nominated'::"awardresult"),
('Joe',1970,'Oscar, best screenplay','nominated'::"awardresult"),
('Love Story',1970,'Oscar, best screenplay','nominated'::"awardresult"),
('Ma nuit chez Maud',1969,'Oscar, best screenplay','nominated'::"awardresult"),
('Butch Cassidy and the Sundance Kid',1969,'Oscar, best screenplay','nominated'::"awardresult"),
('Bob & Carol & Ted & Alice',1969,'Oscar, best screenplay','nominated'::"awardresult"),
('La caduta degli dei (Götterdämmerung)',1969,'Oscar, best screenplay','nominated'::"awardresult"),
('Easy Rider',1969,'Oscar, best screenplay','nominated'::"awardresult"),
('The Wild Bunch',1969,'Oscar, best screenplay','nominated'::"awardresult"),
('The Producers',1967,'Oscar, best screenplay','nominated'::"awardresult"),
('2001: A Space Odyssey',1968,'Oscar, best screenplay','nominated'::"awardresult"),
('La battaglia di Algeri',1966,'Oscar, best screenplay','nominated'::"awardresult"),
('Faces',1968,'Oscar, best screenplay','nominated'::"awardresult"),
('Hot Millions',1968,'Oscar, best screenplay','nominated'::"awardresult"),
('Guess Who''s Coming to Dinner',1967,'Oscar, best screenplay','nominated'::"awardresult"),
('Bonnie and Clyde',1967,'Oscar, best screenplay','nominated'::"awardresult"),
('Divorce American Style',1967,'Oscar, best screenplay','nominated'::"awardresult"),
('Two for the Road',1967,'Oscar, best screenplay','nominated'::"awardresult"),
('La guerre est finie',1966,'Oscar, best screenplay','nominated'::"awardresult"),
('Un homme et une femme',1966,'Oscar, best screenplay','nominated'::"awardresult"),
('Blow-Up',1966,'Oscar, best screenplay','nominated'::"awardresult"),
('The Fortune Cookie',1966,'Oscar, best screenplay','nominated'::"awardresult"),
('Khartoum',1966,'Oscar, best screenplay','nominated'::"awardresult"),
('The Naked Prey',1965,'Oscar, best screenplay','nominated'::"awardresult"),
('Darling',1965,'Oscar, best screenplay','nominated'::"awardresult"),
('Casanova ''70',1965,'Oscar, best screenplay','nominated'::"awardresult"),
('Those Magnificent Men in Their Flying Machines or How I Flew from London to Paris in 25 Hours 11 Minutes',1965,'Oscar, best screenplay','nominated'::"awardresult"),
('The Train',1964,'Oscar, best screenplay','nominated'::"awardresult"),
('Les parapluies de Cherbourg',1964,'Oscar, best screenplay','nominated'::"awardresult"),
('Father Goose',1964,'Oscar, best screenplay','nominated'::"awardresult"),
('A Hard Day''s Night',1964,'Oscar, best screenplay','nominated'::"awardresult"),
('One Potato, Two Potato',1964,'Oscar, best screenplay','nominated'::"awardresult"),
('I compagni',1963,'Oscar, best screenplay','nominated'::"awardresult"),
('L''homme de Rio',1964,'Oscar, best screenplay','nominated'::"awardresult"),
('How the West Was Won',1962,'Oscar, best screenplay','nominated'::"awardresult"),
('8½',1963,'Oscar, best screenplay','nominated'::"awardresult"),
('America America',1963,'Oscar, best screenplay','nominated'::"awardresult"),
('Le quattro giornate di Napoli',1962,'Oscar, best screenplay','nominated'::"awardresult"),
('Love with the Proper Stranger',1963,'Oscar, best screenplay','nominated'::"awardresult"),
('Divorzio all''italiana',1961,'Oscar, best screenplay','nominated'::"awardresult"),
('Freud',1962,'Oscar, best screenplay','nominated'::"awardresult"),
('L''année dernière à Marienbad',1961,'Oscar, best screenplay','nominated'::"awardresult"),
('That Touch of Mink',1962,'Oscar, best screenplay','nominated'::"awardresult"),
('Såsom i en spegel',1961,'Oscar, best screenplay','nominated'::"awardresult"),
('Splendor in the Grass',1961,'Oscar, best screenplay','nominated'::"awardresult"),
('Ballada o soldate',1959,'Oscar, best screenplay','nominated'::"awardresult"),
('Il generale Della Rovere',1959,'Oscar, best screenplay','nominated'::"awardresult"),
('La dolce vita',1960,'Oscar, best screenplay','nominated'::"awardresult"),
('Lover Come Back',1961,'Oscar, best screenplay','nominated'::"awardresult"),
('The Apartment',1960,'Oscar, best screenplay','nominated'::"awardresult"),
('The Angry Silence',1960,'Oscar, best screenplay','nominated'::"awardresult"),
('The Facts of Life',1960,'Oscar, best screenplay','nominated'::"awardresult"),
('Hiroshima mon amour',1959,'Oscar, best screenplay','nominated'::"awardresult"),
('Pote tin Kyriaki',1960,'Oscar, best screenplay','nominated'::"awardresult"),
('Pillow Talk',1959,'Oscar, best screenplay','nominated'::"awardresult"),
('Les quatre cents coups',1959,'Oscar, best screenplay','nominated'::"awardresult"),
('North by Northwest',1959,'Oscar, best screenplay','nominated'::"awardresult"),
('Operation Petticoat',1959,'Oscar, best screenplay','nominated'::"awardresult"),
('Smultronstället',1957,'Oscar, best screenplay','nominated'::"awardresult"),
('The Defiant Ones',1958,'Oscar, best screenplay','nominated'::"awardresult"),
('The Goddess',1958,'Oscar, best screenplay','nominated'::"awardresult"),
('Houseboat',1958,'Oscar, best screenplay','nominated'::"awardresult"),
('The Sheepman',1958,'Oscar, best screenplay','nominated'::"awardresult"),
('Teacher''s Pet',1958,'Oscar, best screenplay','nominated'::"awardresult"),
('Designing Woman',1957,'Oscar, best screenplay','nominated'::"awardresult"),
('Funny Face',1957,'Oscar, best screenplay','nominated'::"awardresult"),
('I vitelloni',1953,'Oscar, best screenplay','nominated'::"awardresult"),
('Man of a Thousand Faces',1957,'Oscar, best screenplay','nominated'::"awardresult"),
('The Tin Star',1957,'Oscar, best screenplay','nominated'::"awardresult"),
('Le ballon rouge',1956,'Oscar, best screenplay','nominated'::"awardresult"),
('The Bold and the Brave',1956,'Oscar, best screenplay','nominated'::"awardresult"),
('Julie',1956,'Oscar, best screenplay','nominated'::"awardresult"),
('La strada',1954,'Oscar, best screenplay','nominated'::"awardresult"),
('The Ladykillers',1955,'Oscar, best screenplay','nominated'::"awardresult"),
('Interrupted Melody',1955,'Oscar, best screenplay','nominated'::"awardresult"),
('The Court-Martial of Billy Mitchell',1955,'Oscar, best screenplay','nominated'::"awardresult"),
('It''s Always Fair Weather',1955,'Oscar, best screenplay','nominated'::"awardresult"),
('Les vacances de Monsieur Hulot',1953,'Oscar, best screenplay','nominated'::"awardresult"),
('The Seven Little Foys',1955,'Oscar, best screenplay','nominated'::"awardresult"),
('On the Waterfront',1954,'Oscar, best screenplay','nominated'::"awardresult"),
('The Barefoot Contessa',1954,'Oscar, best screenplay','nominated'::"awardresult"),
('Genevieve',1953,'Oscar, best screenplay','nominated'::"awardresult"),
('The Glenn Miller Story',1954,'Oscar, best screenplay','nominated'::"awardresult"),
('Knock on Wood',1954,'Oscar, best screenplay','nominated'::"awardresult"),
('Titanic',1953,'Oscar, best screenplay','nominated'::"awardresult"),
('The Band Wagon',1953,'Oscar, best screenplay','nominated'::"awardresult"),
('The Desert Rats',1953,'Oscar, best screenplay','nominated'::"awardresult"),
('The Naked Spur',1953,'Oscar, best screenplay','nominated'::"awardresult"),
('Take the High Ground!',1953,'Oscar, best screenplay','nominated'::"awardresult"),
('The Lavender Hill Mob',1951,'Oscar, best screenplay','nominated'::"awardresult"),
('The Atomic City',1952,'Oscar, best screenplay','nominated'::"awardresult"),
('Pat and Mike',1952,'Oscar, best screenplay','nominated'::"awardresult"),
('The Sound Barrier',1952,'Oscar, best screenplay','nominated'::"awardresult"),
('Viva Zapata!',1952,'Oscar, best screenplay','nominated'::"awardresult"),
('An American in Paris',1951,'Oscar, best screenplay','nominated'::"awardresult"),
('Ace in the Hole',1951,'Oscar, best screenplay','nominated'::"awardresult"),
('David and Bathsheba',1951,'Oscar, best screenplay','nominated'::"awardresult"),
('Go for Broke!',1951,'Oscar, best screenplay','nominated'::"awardresult"),
('The Well',1951,'Oscar, best screenplay','nominated'::"awardresult"),
('Sunset Blvd.',1950,'Oscar, best screenplay','nominated'::"awardresult"),
('Adam''s Rib',1949,'Oscar, best screenplay','nominated'::"awardresult"),
('Caged',1950,'Oscar, best screenplay','nominated'::"awardresult"),
('The Men',1950,'Oscar, best screenplay','nominated'::"awardresult"),
('No Way Out',1950,'Oscar, best screenplay','nominated'::"awardresult"),
('Battleground',1949,'Oscar, best screenplay','nominated'::"awardresult"),
('Jolson Sings Again',1949,'Oscar, best screenplay','nominated'::"awardresult"),
('Paisà',1946,'Oscar, best screenplay','nominated'::"awardresult"),
('Passport to Pimlico',1949,'Oscar, best screenplay','nominated'::"awardresult"),
('The Quiet One',1948,'Oscar, best screenplay','nominated'::"awardresult"),
('The Treasure of the Sierra Madre',1948,'Oscar, best screenplay','nominated'::"awardresult"),
('A Foreign Affair',1948,'Oscar, best screenplay','nominated'::"awardresult"),
('Johnny Belinda',1948,'Oscar, best screenplay','nominated'::"awardresult"),
('The Search',1948,'Oscar, best screenplay','nominated'::"awardresult"),
('The Snake Pit',1948,'Oscar, best screenplay','nominated'::"awardresult"),
('The Bachelor and the Bobby-Soxer',1947,'Oscar, best screenplay','nominated'::"awardresult"),
('Body and Soul',1947,'Oscar, best screenplay','nominated'::"awardresult"),
('A Double Life',1947,'Oscar, best screenplay','nominated'::"awardresult"),
('Monsieur Verdoux',1947,'Oscar, best screenplay','nominated'::"awardresult"),
('Sciuscià',1946,'Oscar, best screenplay','nominated'::"awardresult"),
('The Seventh Veil',1945,'Oscar, best screenplay','nominated'::"awardresult"),
('The Blue Dahlia',1946,'Oscar, best screenplay','nominated'::"awardresult"),
('Les enfants du paradis',1945,'Oscar, best screenplay','nominated'::"awardresult"),
('Notorious',1946,'Oscar, best screenplay','nominated'::"awardresult"),
('Road to Utopia',1945,'Oscar, best screenplay','nominated'::"awardresult"),
('Marie-Louise',1944,'Oscar, best screenplay','nominated'::"awardresult"),
('Dillinger',1945,'Oscar, best screenplay','nominated'::"awardresult"),
('Music for Millions',1944,'Oscar, best screenplay','nominated'::"awardresult"),
('Salty O''Rourke',1945,'Oscar, best screenplay','nominated'::"awardresult"),
('What Next, Corporal Hargrove?',1945,'Oscar, best screenplay','nominated'::"awardresult"),
('Wilson',1944,'Oscar, best screenplay','nominated'::"awardresult"),
('Hail the Conquering Hero',1944,'Oscar, best screenplay','nominated'::"awardresult"),
('The Miracle of Morgan''s Creek',1944,'Oscar, best screenplay','nominated'::"awardresult"),
('Two Girls and a Sailor',1944,'Oscar, best screenplay','nominated'::"awardresult"),
('Wing and a Prayer',1944,'Oscar, best screenplay','nominated'::"awardresult"),
('Princess O''Rourke',1943,'Oscar, best screenplay','nominated'::"awardresult"),
('Air Force',1943,'Oscar, best screenplay','nominated'::"awardresult"),
('In Which We Serve',1942,'Oscar, best screenplay','nominated'::"awardresult"),
('The North Star',1943,'Oscar, best screenplay','nominated'::"awardresult"),
('So Proudly We Hail!',1943,'Oscar, best screenplay','nominated'::"awardresult"),
('Woman of the Year',1942,'Oscar, best screenplay','nominated'::"awardresult"),
('One of Our Aircraft Is Missing',1942,'Oscar, best screenplay','nominated'::"awardresult"),
('Road to Morocco',1942,'Oscar, best screenplay','nominated'::"awardresult"),
('Wake Island',1942,'Oscar, best screenplay','nominated'::"awardresult"),
('The War Against Mrs. Hadley',1942,'Oscar, best screenplay','nominated'::"awardresult"),
('Citizen Kane',1941,'Oscar, best screenplay','nominated'::"awardresult"),
('The Devil and Miss Jones',1941,'Oscar, best screenplay','nominated'::"awardresult"),
('Sergeant York',1941,'Oscar, best screenplay','nominated'::"awardresult"),
('Tall, Dark and Handsome',1941,'Oscar, best screenplay','nominated'::"awardresult"),
('Tom, Dick and Harry',1941,'Oscar, best screenplay','nominated'::"awardresult"),
('The Great McGinty',1940,'Oscar, best screenplay','nominated'::"awardresult"),
('Angels Over Broadway',1940,'Oscar, best screenplay','nominated'::"awardresult"),
('Dr. Ehrlich''s Magic Bullet',1940,'Oscar, best screenplay','nominated'::"awardresult"),
('Foreign Correspondent',1940,'Oscar, best screenplay','nominated'::"awardresult"),
('The Great Dictator',1940,'Oscar, best screenplay','nominated'::"awardresult"))i(title,"year",award,"result") 
 WHERE EXISTS(SELECT FROM movies m  
 WHERE (m.title)=(i.title) AND (m.year)=(i.year)  
 FOR SHARE)
ON CONFLICT DO NOTHING;
INSERT INTO movieawards(title,"year",award,"result")
SELECT i.*
FROM (VALUES
('Green Book',2018,'Oscar, best screenplay','won'::"awardresult"),
('BlacKkKlansman',2018,'Oscar, best screenplay','won'::"awardresult"),
('Get Out',2017,'Oscar, best screenplay','won'::"awardresult"),
('Call Me by Your Name',2017,'Oscar, best screenplay','won'::"awardresult"),
('Manchester by the Sea',2016,'Oscar, best screenplay','won'::"awardresult"),
('Moonlight',2016,'Oscar, best screenplay','won'::"awardresult"),
('Spotlight',2015,'Oscar, best screenplay','won'::"awardresult"),
('The Big Short',2015,'Oscar, best screenplay','won'::"awardresult"),
('Birdman or (The Unexpected Virtue of Ignorance)',2014,'Oscar, best screenplay','won'::"awardresult"),
('The Imitation Game',2014,'Oscar, best screenplay','won'::"awardresult"),
('Her',2013,'Oscar, best screenplay','won'::"awardresult"),
('12 Years a Slave',2013,'Oscar, best screenplay','won'::"awardresult"),
('Django Unchained',2012,'Oscar, best screenplay','won'::"awardresult"),
('Argo',2012,'Oscar, best screenplay','won'::"awardresult"),
('Midnight in Paris',2011,'Oscar, best screenplay','won'::"awardresult"),
('The Descendants',2011,'Oscar, best screenplay','won'::"awardresult"),
('The King''s Speech',2010,'Oscar, best screenplay','won'::"awardresult"),
('The Social Network',2010,'Oscar, best screenplay','won'::"awardresult"),
('The Hurt Locker',2008,'Oscar, best screenplay','won'::"awardresult"),
('Precious',2009,'Oscar, best screenplay','won'::"awardresult"),
('Milk',2008,'Oscar, best screenplay','won'::"awardresult"),
('Slumdog Millionaire',2008,'Oscar, best screenplay','won'::"awardresult"),
('Juno',2007,'Oscar, best screenplay','won'::"awardresult"),
('No Country for Old Men',2007,'Oscar, best screenplay','won'::"awardresult"),
('Little Miss Sunshine',2006,'Oscar, best screenplay','won'::"awardresult"),
('The Departed',2006,'Oscar, best screenplay','won'::"awardresult"),
('Crash',2004,'Oscar, best screenplay','won'::"awardresult"),
('Brokeback Mountain',2005,'Oscar, best screenplay','won'::"awardresult"),
('Eternal Sunshine of the Spotless Mind',2004,'Oscar, best screenplay','won'::"awardresult"),
('Sideways',2004,'Oscar, best screenplay','won'::"awardresult"),
('Lost in Translation',2003,'Oscar, best screenplay','won'::"awardresult"),
('The Lord of the Rings: The Return of the King',2003,'Oscar, best screenplay','won'::"awardresult"),
('Hable con ella',2002,'Oscar, best screenplay','won'::"awardresult"),
('The Pianist',2002,'Oscar, best screenplay','won'::"awardresult"),
('Gosford Park',2001,'Oscar, best screenplay','won'::"awardresult"),
('A Beautiful Mind',2001,'Oscar, best screenplay','won'::"awardresult"),
('Almost Famous',2000,'Oscar, best screenplay','won'::"awardresult"),
('Traffic',2000,'Oscar, best screenplay','won'::"awardresult"),
('American Beauty',1999,'Oscar, best screenplay','won'::"awardresult"),
('The Cider House Rules',1999,'Oscar, best screenplay','won'::"awardresult"),
('Shakespeare in Love',1998,'Oscar, best screenplay','won'::"awardresult"),
('Gods and Monsters',1998,'Oscar, best screenplay','won'::"awardresult"),
('Good Will Hunting',1997,'Oscar, best screenplay','won'::"awardresult"),
('L.A. Confidential',1997,'Oscar, best screenplay','won'::"awardresult"),
('Fargo',1996,'Oscar, best screenplay','won'::"awardresult"),
('Sling Blade',1996,'Oscar, best screenplay','won'::"awardresult"),
('The Usual Suspects',1995,'Oscar, best screenplay','won'::"awardresult"),
('Sense and Sensibility',1995,'Oscar, best screenplay','won'::"awardresult"),
('Pulp Fiction',1994,'Oscar, best screenplay','won'::"awardresult"),
('Forrest Gump',1994,'Oscar, best screenplay','won'::"awardresult"),
('The Piano',1993,'Oscar, best screenplay','won'::"awardresult"),
('Schindler''s List',1993,'Oscar, best screenplay','won'::"awardresult"),
('The Crying Game',1992,'Oscar, best screenplay','won'::"awardresult"),
('Howards End',1992,'Oscar, best screenplay','won'::"awardresult"),
('Thelma & Louise',1991,'Oscar, best screenplay','won'::"awardresult"),
('The Silence of the Lambs',1991,'Oscar, best screenplay','won'::"awardresult"),
('Ghost',1990,'Oscar, best screenplay','won'::"awardresult"),
('Dances with Wolves',1990,'Oscar, best screenplay','won'::"awardresult"),
('Dead Poets Society',1989,'Oscar, best screenplay','won'::"awardresult"),
('Driving Miss Daisy',1989,'Oscar, best screenplay','won'::"awardresult"),
('Rain Man',1988,'Oscar, best screenplay','won'::"awardresult"),
('Dangerous Liaisons',1988,'Oscar, best screenplay','won'::"awardresult"),
('Moonstruck',1987,'Oscar, best screenplay','won'::"awardresult"),
('The Last Emperor',1987,'Oscar, best screenplay','won'::"awardresult"),
('Hannah and Her Sisters',1986,'Oscar, best screenplay','won'::"awardresult"),
('A Room with a View',1985,'Oscar, best screenplay','won'::"awardresult"),
('Witness',1985,'Oscar, best screenplay','won'::"awardresult"),
('Out of Africa',1985,'Oscar, best screenplay','won'::"awardresult"),
('Places in the Heart',1984,'Oscar, best screenplay','won'::"awardresult"),
('Amadeus',1984,'Oscar, best screenplay','won'::"awardresult"),
('Tender Mercies',1983,'Oscar, best screenplay','won'::"awardresult"),
('Terms of Endearment',1983,'Oscar, best screenplay','won'::"awardresult"),
('Gandhi',1982,'Oscar, best screenplay','won'::"awardresult"),
('Missing',1982,'Oscar, best screenplay','won'::"awardresult"),
('Chariots of Fire',1981,'Oscar, best screenplay','won'::"awardresult"),
('On Golden Pond',1981,'Oscar, best screenplay','won'::"awardresult"),
('Melvin and Howard',1980,'Oscar, best screenplay','won'::"awardresult"),
('Ordinary People',1980,'Oscar, best screenplay','won'::"awardresult"),
('Breaking Away',1979,'Oscar, best screenplay','won'::"awardresult"),
('Kramer vs. Kramer',1979,'Oscar, best screenplay','won'::"awardresult"),
('Coming Home',1978,'Oscar, best screenplay','won'::"awardresult"),
('Midnight Express',1978,'Oscar, best screenplay','won'::"awardresult"),
('Annie Hall',1977,'Oscar, best screenplay','won'::"awardresult"),
('Julia',1977,'Oscar, best screenplay','won'::"awardresult"),
('Network',1976,'Oscar, best screenplay','won'::"awardresult"),
('All the President''s Men',1976,'Oscar, best screenplay','won'::"awardresult"),
('Dog Day Afternoon',1975,'Oscar, best screenplay','won'::"awardresult"),
('One Flew Over the Cuckoo''s Nest',1975,'Oscar, best screenplay','won'::"awardresult"),
('Chinatown',1974,'Oscar, best screenplay','won'::"awardresult"),
('The Godfather Part II',1974,'Oscar, best screenplay','won'::"awardresult"),
('The Exorcist',1973,'Oscar, best screenplay','won'::"awardresult"),
('The Sting',1973,'Oscar, best screenplay','won'::"awardresult"),
('The Godfather',1972,'Oscar, best screenplay','won'::"awardresult"),
('The Candidate',1972,'Oscar, best screenplay','won'::"awardresult"),
('The French Connection',1971,'Oscar, best screenplay','won'::"awardresult"),
('The Hospital',1971,'Oscar, best screenplay','won'::"awardresult"),
('M*A*S*H',1970,'Oscar, best screenplay','won'::"awardresult"),
('Patton',1970,'Oscar, best screenplay','won'::"awardresult"),
('Butch Cassidy and the Sundance Kid',1969,'Oscar, best screenplay','won'::"awardresult"),
('Midnight Cowboy',1969,'Oscar, best screenplay','won'::"awardresult"),
('The Producers',1967,'Oscar, best screenplay','won'::"awardresult"),
('The Lion in Winter',1968,'Oscar, best screenplay','won'::"awardresult"),
('Guess Who''s Coming to Dinner',1967,'Oscar, best screenplay','won'::"awardresult"),
('In the Heat of the Night',1967,'Oscar, best screenplay','won'::"awardresult"),
('Un homme et une femme',1966,'Oscar, best screenplay','won'::"awardresult"),
('A Man for All Seasons',1966,'Oscar, best screenplay','won'::"awardresult"),
('Darling',1965,'Oscar, best screenplay','won'::"awardresult"),
('Doctor Zhivago',1965,'Oscar, best screenplay','won'::"awardresult"),
('Father Goose',1964,'Oscar, best screenplay','won'::"awardresult"),
('Becket',1964,'Oscar, best screenplay','won'::"awardresult"),
('How the West Was Won',1962,'Oscar, best screenplay','won'::"awardresult"),
('Tom Jones',1963,'Oscar, best screenplay','won'::"awardresult"),
('Divorzio all''italiana',1961,'Oscar, best screenplay','won'::"awardresult"),
('To Kill a Mockingbird',1962,'Oscar, best screenplay','won'::"awardresult"),
('Splendor in the Grass',1961,'Oscar, best screenplay','won'::"awardresult"),
('Judgment at Nuremberg',1961,'Oscar, best screenplay','won'::"awardresult"),
('The Apartment',1960,'Oscar, best screenplay','won'::"awardresult"),
('Elmer Gantry',1960,'Oscar, best screenplay','won'::"awardresult"),
('Pillow Talk',1959,'Oscar, best screenplay','won'::"awardresult"),
('Room at the Top',1958,'Oscar, best screenplay','won'::"awardresult"),
('The Defiant Ones',1958,'Oscar, best screenplay','won'::"awardresult"),
('Gigi',1958,'Oscar, best screenplay','won'::"awardresult"),
('Designing Woman',1957,'Oscar, best screenplay','won'::"awardresult"),
('The Bridge on the River Kwai',1957,'Oscar, best screenplay','won'::"awardresult"),
('Le ballon rouge',1956,'Oscar, best screenplay','won'::"awardresult"),
('The Brave One',1956,'Oscar, best screenplay','won'::"awardresult"),
('Around the World in 80 Days',1956,'Oscar, best screenplay','won'::"awardresult"),
('Marty',1955,'Oscar, best screenplay','won'::"awardresult"),
('Love Me or Leave Me',1955,'Oscar, best screenplay','won'::"awardresult"),
('Interrupted Melody',1955,'Oscar, best screenplay','won'::"awardresult"),
('The Country Girl',1954,'Oscar, best screenplay','won'::"awardresult"),
('Broken Lance',1954,'Oscar, best screenplay','won'::"awardresult"),
('On the Waterfront',1954,'Oscar, best screenplay','won'::"awardresult"),
('From Here to Eternity',1953,'Oscar, best screenplay','won'::"awardresult"),
('Roman Holiday',1953,'Oscar, best screenplay','won'::"awardresult"),
('Titanic',1953,'Oscar, best screenplay','won'::"awardresult"),
('The Bad and the Beautiful',1952,'Oscar, best screenplay','won'::"awardresult"),
('The Greatest Show on Earth',1952,'Oscar, best screenplay','won'::"awardresult"),
('The Lavender Hill Mob',1951,'Oscar, best screenplay','won'::"awardresult"),
('A Place in the Sun',1951,'Oscar, best screenplay','won'::"awardresult"),
('Seven Days to Noon',1950,'Oscar, best screenplay','won'::"awardresult"),
('An American in Paris',1951,'Oscar, best screenplay','won'::"awardresult"),
('All About Eve',1950,'Oscar, best screenplay','won'::"awardresult"),
('Panic in the Streets',1950,'Oscar, best screenplay','won'::"awardresult"),
('Sunset Blvd.',1950,'Oscar, best screenplay','won'::"awardresult"),
('A Letter to Three Wives',1949,'Oscar, best screenplay','won'::"awardresult"),
('The Stratton Story',1949,'Oscar, best screenplay','won'::"awardresult"),
('Battleground',1949,'Oscar, best screenplay','won'::"awardresult"),
('The Treasure of the Sierra Madre',1948,'Oscar, best screenplay','won'::"awardresult"),
('The Search',1948,'Oscar, best screenplay','won'::"awardresult"),
('The Bachelor and the Bobby-Soxer',1947,'Oscar, best screenplay','won'::"awardresult"),
('Miracle on 34th Street',1947,'Oscar, best screenplay','won'::"awardresult"),
('Miracle on 34th Street',1947,'Oscar, best screenplay','won'::"awardresult"),
('The Seventh Veil',1945,'Oscar, best screenplay','won'::"awardresult"),
('Perfect Strangers',1945,'Oscar, best screenplay','won'::"awardresult"),
('The Best Years of Our Lives',1946,'Oscar, best screenplay','won'::"awardresult"),
('Marie-Louise',1944,'Oscar, best screenplay','won'::"awardresult"),
('The House on 92nd Street',1945,'Oscar, best screenplay','won'::"awardresult"),
('The Lost Weekend',1945,'Oscar, best screenplay','won'::"awardresult"),
('Wilson',1944,'Oscar, best screenplay','won'::"awardresult"),
('Going My Way',1944,'Oscar, best screenplay','won'::"awardresult"),
('Going My Way',1944,'Oscar, best screenplay','won'::"awardresult"),
('Princess O''Rourke',1943,'Oscar, best screenplay','won'::"awardresult"),
('The Human Comedy',1943,'Oscar, best screenplay','won'::"awardresult"),
('Casablanca',1942,'Oscar, best screenplay','won'::"awardresult"),
('Woman of the Year',1942,'Oscar, best screenplay','won'::"awardresult"),
('49th Parallel',1941,'Oscar, best screenplay','won'::"awardresult"),
('Mrs. Miniver',1942,'Oscar, best screenplay','won'::"awardresult"),
('Citizen Kane',1941,'Oscar, best screenplay','won'::"awardresult"),
('Here Comes Mr. Jordan',1941,'Oscar, best screenplay','won'::"awardresult"),
('Here Comes Mr. Jordan',1941,'Oscar, best screenplay','won'::"awardresult"),
('The Great McGinty',1940,'Oscar, best screenplay','won'::"awardresult"),
('Arise, My Love',1940,'Oscar, best screenplay','won'::"awardresult"),
('The Philadelphia Story',1940,'Oscar, best screenplay','won'::"awardresult"),
('Mr. Smith Goes to Washington',1939,'Oscar, best screenplay','won'::"awardresult"),
('Gone with the Wind',1939,'Oscar, best screenplay','won'::"awardresult"),
('Boys Town',1938,'Oscar, best screenplay','won'::"awardresult"),
('Pygmalion',1938,'Oscar, best screenplay','won'::"awardresult"),
('A Star Is Born',1937,'Oscar, best screenplay','won'::"awardresult"),
('The Life of Emile Zola',1937,'Oscar, best screenplay','won'::"awardresult"),
('The Story of Louis Pasteur',1936,'Oscar, best screenplay','won'::"awardresult"),
('The Story of Louis Pasteur',1936,'Oscar, best screenplay','won'::"awardresult"),
('The Scoundrel',1935,'Oscar, best screenplay','won'::"awardresult"),
('The Informer',1935,'Oscar, best screenplay','won'::"awardresult"),
('Manhattan Melodrama',1934,'Oscar, best screenplay','won'::"awardresult"),
('It Happened One Night',1934,'Oscar, best screenplay','won'::"awardresult"),
('One Way Passage',1932,'Oscar, best screenplay','won'::"awardresult"),
('Little Women',1933,'Oscar, best screenplay','won'::"awardresult"),
('The Champ',1931,'Oscar, best screenplay','won'::"awardresult"),
('Bad Girl',1931,'Oscar, best screenplay','won'::"awardresult"),
('The Dawn Patrol',1930,'Oscar, best screenplay','won'::"awardresult"),
('Cimarron',1931,'Oscar, best screenplay','won'::"awardresult"),
('The Big House',1930,'Oscar, best screenplay','won'::"awardresult"),
('The Patriot',1928,'Oscar, best screenplay','won'::"awardresult"),
('Underworld',1927,'Oscar, best screenplay','won'::"awardresult"),
('7th Heaven',1927,'Oscar, best screenplay','won'::"awardresult"))i(title,"year",award,"result") 
 WHERE EXISTS(SELECT FROM movies m  
 WHERE (m.title)=(i.title) AND (m.year)=(i.year)  
 FOR SHARE)
ON CONFLICT DO NOTHING;
INSERT INTO movieawards(title,"year",award,"result")
SELECT i.*
FROM (VALUES
('It''s a Mad Mad Mad Mad World',1963,'Oscar, best sound','won'::"awardresult"),
('Goldfinger',1964,'Oscar, best sound','won'::"awardresult"),
('The Great Race',1965,'Oscar, best sound','won'::"awardresult"),
('Grand Prix',1966,'Oscar, best sound','won'::"awardresult"),
('The Dirty Dozen',1967,'Oscar, best sound','won'::"awardresult"),
('The Hindenburg',1975,'Oscar, best sound','won'::"awardresult"),
('Close Encounters of the Third Kind',1977,'Oscar, best sound','won'::"awardresult"),
('The Black Stallion',1979,'Oscar, best sound','won'::"awardresult"),
('Raiders of the Lost Ark',1981,'Oscar, best sound','won'::"awardresult"),
('E.T. the Extra-Terrestrial',1982,'Oscar, best sound','won'::"awardresult"),
('The Right Stuff',1983,'Oscar, best sound','won'::"awardresult"),
('The River',1984,'Oscar, best sound','won'::"awardresult"),
('Back to the Future',1985,'Oscar, best sound','won'::"awardresult"),
('Aliens',1986,'Oscar, best sound','won'::"awardresult"),
('RoboCop',1987,'Oscar, best sound','won'::"awardresult"),
('Indiana Jones and the Last Crusade',1989,'Oscar, best sound','won'::"awardresult"),
('The Hunt for Red October',1990,'Oscar, best sound','won'::"awardresult"),
('Terminator 2: Judgment Day',1991,'Oscar, best sound','won'::"awardresult"),
('Dracula',1992,'Oscar, best sound','won'::"awardresult"),
('Jurassic Park',1993,'Oscar, best sound','won'::"awardresult"),
('Speed',1994,'Oscar, best sound','won'::"awardresult"),
('Braveheart',1995,'Oscar, best sound','won'::"awardresult"),
('The Ghost and the Darkness',1996,'Oscar, best sound','won'::"awardresult"),
('Titanic',1997,'Oscar, best sound','won'::"awardresult"),
('Saving Private Ryan',1998,'Oscar, best sound','won'::"awardresult"),
('The Matrix',1999,'Oscar, best sound','won'::"awardresult"),
('U-571',2000,'Oscar, best sound','won'::"awardresult"),
('Pearl Harbor',2001,'Oscar, best sound','won'::"awardresult"),
('The Lord of the Rings: The Two Towers',2002,'Oscar, best sound','won'::"awardresult"),
('Master and Commander: The Far Side of the World',2003,'Oscar, best sound','won'::"awardresult"),
('The Incredibles',2004,'Oscar, best sound','won'::"awardresult"),
('King Kong',2005,'Oscar, best sound','won'::"awardresult"),
('Letters from Iwo Jima',2006,'Oscar, best sound','won'::"awardresult"),
('The Bourne Ultimatum',2007,'Oscar, best sound','won'::"awardresult"),
('The Dark Knight',2008,'Oscar, best sound','won'::"awardresult"),
('The Hurt Locker',2008,'Oscar, best sound','won'::"awardresult"),
('Inception',2010,'Oscar, best sound','won'::"awardresult"),
('Hugo',2011,'Oscar, best sound','won'::"awardresult"),
('Skyfall',2012,'Oscar, best sound','won'::"awardresult"),
('Zero Dark Thirty',2012,'Oscar, best sound','won'::"awardresult"),
('Gravity',2013,'Oscar, best sound','won'::"awardresult"),
('American Sniper',2014,'Oscar, best sound','won'::"awardresult"),
('Mad Max: Fury Road',2015,'Oscar, best sound','won'::"awardresult"),
('Arrival',2016,'Oscar, best sound','won'::"awardresult"),
('Dunkirk',2017,'Oscar, best sound','won'::"awardresult"),
('Bohemian Rhapsody',2018,'Oscar, best sound','won'::"awardresult"),
('Ford v Ferrari',2019,'Oscar, best sound','won'::"awardresult"))i(title,"year",award,"result") 
 WHERE EXISTS(SELECT FROM movies m  
 WHERE (m.title)=(i.title) AND (m.year)=(i.year)  
 FOR SHARE)
ON CONFLICT DO NOTHING;
INSERT INTO movieawards(title,"year",award,"result")
SELECT i.*
FROM (VALUES
('The Rains Came',1939,'Oscar, best visual effect','won'::"awardresult"),
('The Thief of Bagdad',1940,'Oscar, best visual effect','won'::"awardresult"),
('I Wanted Wings',1941,'Oscar, best visual effect','won'::"awardresult"),
('Reap the Wild Wind',1942,'Oscar, best visual effect','won'::"awardresult"),
('Crash Dive',1943,'Oscar, best visual effect','won'::"awardresult"),
('Thirty Seconds Over Tokyo',1944,'Oscar, best visual effect','won'::"awardresult"),
('Wonder Man',1945,'Oscar, best visual effect','won'::"awardresult"),
('Blithe Spirit',1945,'Oscar, best visual effect','won'::"awardresult"),
('Green Dolphin Street',1947,'Oscar, best visual effect','won'::"awardresult"),
('Portrait of Jennie',1948,'Oscar, best visual effect','won'::"awardresult"),
('Mighty Joe Young',1949,'Oscar, best visual effect','won'::"awardresult"),
('Destination Moon',1950,'Oscar, best visual effect','won'::"awardresult"),
('When Worlds Collide',1951,'Oscar, best visual effect','won'::"awardresult"),
('Plymouth Adventure',1952,'Oscar, best visual effect','won'::"awardresult"),
('The War of the Worlds',1953,'Oscar, best visual effect','won'::"awardresult"),
('20,000 Leagues Under the Sea',1954,'Oscar, best visual effect','won'::"awardresult"),
('The Bridges at Toko-Ri',1954,'Oscar, best visual effect','won'::"awardresult"),
('The Ten Commandments',1956,'Oscar, best visual effect','won'::"awardresult"),
('The Enemy Below',1957,'Oscar, best visual effect','won'::"awardresult"),
('Tom Thumb',1958,'Oscar, best visual effect','won'::"awardresult"),
('Ben-Hur',1959,'Oscar, best visual effect','won'::"awardresult"),
('The Time Machine',1960,'Oscar, best visual effect','won'::"awardresult"),
('The Guns of Navarone',1961,'Oscar, best visual effect','won'::"awardresult"),
('The Longest Day',1962,'Oscar, best visual effect','won'::"awardresult"),
('Cleopatra',1963,'Oscar, best visual effect','won'::"awardresult"),
('Mary Poppins',1964,'Oscar, best visual effect','won'::"awardresult"),
('Thunderball',1965,'Oscar, best visual effect','won'::"awardresult"),
('Fantastic Voyage',1966,'Oscar, best visual effect','won'::"awardresult"),
('Doctor Dolittle',1967,'Oscar, best visual effect','won'::"awardresult"),
('2001: A Space Odyssey',1968,'Oscar, best visual effect','won'::"awardresult"),
('Marooned',1969,'Oscar, best visual effect','won'::"awardresult"),
('Tora! Tora! Tora!',1970,'Oscar, best visual effect','won'::"awardresult"),
('Bedknobs and Broomsticks',1971,'Oscar, best visual effect','won'::"awardresult"),
('The Poseidon Adventure',1972,'Oscar, best visual effect','won'::"awardresult"),
('Earthquake',1974,'Oscar, best visual effect','won'::"awardresult"),
('The Hindenburg',1975,'Oscar, best visual effect','won'::"awardresult"),
('King Kong',1976,'Oscar, best visual effect','won'::"awardresult"),
('Star Wars',1977,'Oscar, best visual effect','won'::"awardresult"),
('Superman',1978,'Oscar, best visual effect','won'::"awardresult"),
('Alien',1979,'Oscar, best visual effect','won'::"awardresult"),
('The Empire Strikes Back',1980,'Oscar, best visual effect','won'::"awardresult"),
('Raiders of the Lost Ark',1981,'Oscar, best visual effect','won'::"awardresult"),
('E.T. the Extra-Terrestrial',1982,'Oscar, best visual effect','won'::"awardresult"),
('Star Wars: Episode VI - Return of the Jedi',1983,'Oscar, best visual effect','won'::"awardresult"),
('Indiana Jones and the Temple of Doom',1984,'Oscar, best visual effect','won'::"awardresult"),
('Cocoon',1985,'Oscar, best visual effect','won'::"awardresult"),
('Aliens',1986,'Oscar, best visual effect','won'::"awardresult"),
('Innerspace',1987,'Oscar, best visual effect','won'::"awardresult"),
('Who Framed Roger Rabbit',1988,'Oscar, best visual effect','won'::"awardresult"),
('The Abyss',1989,'Oscar, best visual effect','won'::"awardresult"),
('Total Recall',1990,'Oscar, best visual effect','won'::"awardresult"),
('Terminator 2: Judgment Day',1991,'Oscar, best visual effect','won'::"awardresult"),
('Death Becomes Her',1992,'Oscar, best visual effect','won'::"awardresult"),
('Jurassic Park',1993,'Oscar, best visual effect','won'::"awardresult"),
('Forrest Gump',1994,'Oscar, best visual effect','won'::"awardresult"),
('Babe',1995,'Oscar, best visual effect','won'::"awardresult"),
('Independence Day',1996,'Oscar, best visual effect','won'::"awardresult"),
('Titanic',1997,'Oscar, best visual effect','won'::"awardresult"),
('What Dreams May Come',1998,'Oscar, best visual effect','won'::"awardresult"),
('The Matrix',1999,'Oscar, best visual effect','won'::"awardresult"),
('Gladiator',2000,'Oscar, best visual effect','won'::"awardresult"),
('The Lord of the Rings: The Fellowship of the Ring',2001,'Oscar, best visual effect','won'::"awardresult"),
('The Lord of the Rings: The Two Towers',2002,'Oscar, best visual effect','won'::"awardresult"),
('The Lord of the Rings: The Return of the King',2003,'Oscar, best visual effect','won'::"awardresult"),
('Spider-Man 2',2004,'Oscar, best visual effect','won'::"awardresult"),
('King Kong',2005,'Oscar, best visual effect','won'::"awardresult"),
('Pirates of the Caribbean: Dead Man''s Chest',2006,'Oscar, best visual effect','won'::"awardresult"),
('The Golden Compass',2007,'Oscar, best visual effect','won'::"awardresult"),
('The Curious Case of Benjamin Button',2008,'Oscar, best visual effect','won'::"awardresult"),
('Avatar',2009,'Oscar, best visual effect','won'::"awardresult"),
('Inception',2010,'Oscar, best visual effect','won'::"awardresult"),
('Hugo',2011,'Oscar, best visual effect','won'::"awardresult"),
('Life of Pi',2012,'Oscar, best visual effect','won'::"awardresult"),
('Gravity',2013,'Oscar, best visual effect','won'::"awardresult"),
('Interstellar',2014,'Oscar, best visual effect','won'::"awardresult"),
('Ex Machina',2014,'Oscar, best visual effect','won'::"awardresult"),
('The Jungle Book',2016,'Oscar, best visual effect','won'::"awardresult"),
('Blade Runner 2049',2017,'Oscar, best visual effect','won'::"awardresult"),
('First Man',2018,'Oscar, best visual effect','won'::"awardresult"),
('1917',2019,'Oscar, best visual effect','won'::"awardresult"),
('Tenet',2020,'Oscar, best visual effect','won'::"awardresult"))i(title,"year",award,"result") 
 WHERE EXISTS(SELECT FROM movies m  
 WHERE (m.title)=(i.title) AND (m.year)=(i.year)  
 FOR SHARE)
ON CONFLICT DO NOTHING;
INSERT INTO movieawards(title,"year",award,"result")
SELECT i.*
FROM (VALUES
('Dune: Part One',2021,'Oscar, best cinematography','nominated'::"awardresult"),
('Nightmare Alley',2021,'Oscar, best cinematography','nominated'::"awardresult"),
('The Power of the Dog',2021,'Oscar, best cinematography','nominated'::"awardresult"),
('The Tragedy of Macbeth',2021,'Oscar, best cinematography','nominated'::"awardresult"),
('West Side Story',2021,'Oscar, best cinematography','nominated'::"awardresult"),
('Mank',2020,'Oscar, best cinematography','nominated'::"awardresult"),
('Judas and the Black Messiah',2021,'Oscar, best cinematography','nominated'::"awardresult"),
('News of the World',2020,'Oscar, best cinematography','nominated'::"awardresult"),
('Nomadland',2020,'Oscar, best cinematography','nominated'::"awardresult"),
('The Trial of the Chicago 7',2020,'Oscar, best cinematography','nominated'::"awardresult"),
('1917',2019,'Oscar, best cinematography','nominated'::"awardresult"),
('The Irishman',2019,'Oscar, best cinematography','nominated'::"awardresult"),
('Joker',2019,'Oscar, best cinematography','nominated'::"awardresult"),
('The Lighthouse',2019,'Oscar, best cinematography','nominated'::"awardresult"),
('Once Upon a Time... in Hollywood',2019,'Oscar, best cinematography','nominated'::"awardresult"),
('Roma',2018,'Oscar, best cinematography','nominated'::"awardresult"),
('Zimna wojna',2018,'Oscar, best cinematography','nominated'::"awardresult"),
('The Favourite',2018,'Oscar, best cinematography','nominated'::"awardresult"),
('Werk ohne Autor',2018,'Oscar, best cinematography','nominated'::"awardresult"),
('A Star Is Born',2018,'Oscar, best cinematography','nominated'::"awardresult"),
('Blade Runner 2049',2017,'Oscar, best cinematography','nominated'::"awardresult"),
('Darkest Hour',2017,'Oscar, best cinematography','nominated'::"awardresult"),
('Dunkirk',2017,'Oscar, best cinematography','nominated'::"awardresult"),
('Mudbound',2017,'Oscar, best cinematography','nominated'::"awardresult"),
('The Shape of Water',2017,'Oscar, best cinematography','nominated'::"awardresult"),
('La La Land',2016,'Oscar, best cinematography','nominated'::"awardresult"),
('Arrival',2016,'Oscar, best cinematography','nominated'::"awardresult"),
('Lion',2016,'Oscar, best cinematography','nominated'::"awardresult"),
('Moonlight',2016,'Oscar, best cinematography','nominated'::"awardresult"),
('Silence',2016,'Oscar, best cinematography','nominated'::"awardresult"),
('The Revenant',2015,'Oscar, best cinematography','nominated'::"awardresult"),
('Carol',2015,'Oscar, best cinematography','nominated'::"awardresult"),
('The Hateful Eight',2015,'Oscar, best cinematography','nominated'::"awardresult"),
('Mad Max: Fury Road',2015,'Oscar, best cinematography','nominated'::"awardresult"),
('Sicario',2015,'Oscar, best cinematography','nominated'::"awardresult"),
('Birdman or (The Unexpected Virtue of Ignorance)',2014,'Oscar, best cinematography','nominated'::"awardresult"),
('The Grand Budapest Hotel',2014,'Oscar, best cinematography','nominated'::"awardresult"),
('Ida',2013,'Oscar, best cinematography','nominated'::"awardresult"),
('Mr. Turner',2014,'Oscar, best cinematography','nominated'::"awardresult"),
('Unbroken',2014,'Oscar, best cinematography','nominated'::"awardresult"),
('Gravity',2013,'Oscar, best cinematography','nominated'::"awardresult"),
('Yi dai zong shi',2013,'Oscar, best cinematography','nominated'::"awardresult"),
('Inside Llewyn Davis',2013,'Oscar, best cinematography','nominated'::"awardresult"),
('Nebraska',2013,'Oscar, best cinematography','nominated'::"awardresult"),
('Prisoners',2013,'Oscar, best cinematography','nominated'::"awardresult"),
('Life of Pi',2012,'Oscar, best cinematography','nominated'::"awardresult"),
('Anna Karenina',2012,'Oscar, best cinematography','nominated'::"awardresult"),
('Django Unchained',2012,'Oscar, best cinematography','nominated'::"awardresult"),
('Lincoln',2012,'Oscar, best cinematography','nominated'::"awardresult"),
('Skyfall',2012,'Oscar, best cinematography','nominated'::"awardresult"),
('Hugo',2011,'Oscar, best cinematography','nominated'::"awardresult"),
('The Artist',2011,'Oscar, best cinematography','nominated'::"awardresult"),
('The Girl with the Dragon Tattoo',2011,'Oscar, best cinematography','nominated'::"awardresult"),
('The Tree of Life',2011,'Oscar, best cinematography','nominated'::"awardresult"),
('War Horse',2011,'Oscar, best cinematography','nominated'::"awardresult"),
('Inception',2010,'Oscar, best cinematography','nominated'::"awardresult"),
('Black Swan',2010,'Oscar, best cinematography','nominated'::"awardresult"),
('The King''s Speech',2010,'Oscar, best cinematography','nominated'::"awardresult"),
('The Social Network',2010,'Oscar, best cinematography','nominated'::"awardresult"),
('True Grit',2010,'Oscar, best cinematography','nominated'::"awardresult"),
('Avatar',2009,'Oscar, best cinematography','nominated'::"awardresult"),
('Harry Potter and the Half-Blood Prince',2009,'Oscar, best cinematography','nominated'::"awardresult"),
('The Hurt Locker',2008,'Oscar, best cinematography','nominated'::"awardresult"),
('Inglourious Basterds',2009,'Oscar, best cinematography','nominated'::"awardresult"),
('Das weiße Band - Eine deutsche Kindergeschichte',2009,'Oscar, best cinematography','nominated'::"awardresult"),
('Slumdog Millionaire',2008,'Oscar, best cinematography','nominated'::"awardresult"),
('Changeling',2008,'Oscar, best cinematography','nominated'::"awardresult"),
('The Curious Case of Benjamin Button',2008,'Oscar, best cinematography','nominated'::"awardresult"),
('The Dark Knight',2008,'Oscar, best cinematography','nominated'::"awardresult"),
('The Reader',2008,'Oscar, best cinematography','nominated'::"awardresult"),
('There Will Be Blood',2007,'Oscar, best cinematography','nominated'::"awardresult"),
('The Assassination of Jesse James by the Coward Robert Ford',2007,'Oscar, best cinematography','nominated'::"awardresult"),
('Atonement',2007,'Oscar, best cinematography','nominated'::"awardresult"),
('Le scaphandre et le papillon',2007,'Oscar, best cinematography','nominated'::"awardresult"),
('No Country for Old Men',2007,'Oscar, best cinematography','nominated'::"awardresult"),
('El laberinto del fauno',2006,'Oscar, best cinematography','nominated'::"awardresult"),
('The Black Dahlia',2006,'Oscar, best cinematography','nominated'::"awardresult"),
('Children of Men',2006,'Oscar, best cinematography','nominated'::"awardresult"),
('The Illusionist',2006,'Oscar, best cinematography','nominated'::"awardresult"),
('The Prestige',2006,'Oscar, best cinematography','nominated'::"awardresult"),
('Memoirs of a Geisha',2005,'Oscar, best cinematography','nominated'::"awardresult"),
('Batman Begins',2005,'Oscar, best cinematography','nominated'::"awardresult"),
('Brokeback Mountain',2005,'Oscar, best cinematography','nominated'::"awardresult"),
('Good Night, and Good Luck.',2005,'Oscar, best cinematography','nominated'::"awardresult"),
('The New World',2005,'Oscar, best cinematography','nominated'::"awardresult"),
('The Aviator',2004,'Oscar, best cinematography','nominated'::"awardresult"),
('Shi mian mai fu',2004,'Oscar, best cinematography','nominated'::"awardresult"),
('The Passion of the Christ',2004,'Oscar, best cinematography','nominated'::"awardresult"),
('The Phantom of the Opera',2004,'Oscar, best cinematography','nominated'::"awardresult"),
('Un long dimanche de fiançailles',2004,'Oscar, best cinematography','nominated'::"awardresult"),
('Master and Commander: The Far Side of the World',2003,'Oscar, best cinematography','nominated'::"awardresult"),
('Cidade de Deus',2002,'Oscar, best cinematography','nominated'::"awardresult"),
('Cold Mountain',2003,'Oscar, best cinematography','nominated'::"awardresult"),
('Girl with a Pearl Earring',2003,'Oscar, best cinematography','nominated'::"awardresult"),
('Seabiscuit',2003,'Oscar, best cinematography','nominated'::"awardresult"),
('Road to Perdition',2002,'Oscar, best cinematography','nominated'::"awardresult"),
('Chicago',2002,'Oscar, best cinematography','nominated'::"awardresult"),
('Far from Heaven',2002,'Oscar, best cinematography','nominated'::"awardresult"),
('Gangs of New York',2002,'Oscar, best cinematography','nominated'::"awardresult"),
('The Pianist',2002,'Oscar, best cinematography','nominated'::"awardresult"),
('The Lord of the Rings: The Fellowship of the Ring',2001,'Oscar, best cinematography','nominated'::"awardresult"),
('Le fabuleux destin d''Amélie Poulain',2001,'Oscar, best cinematography','nominated'::"awardresult"),
('Black Hawk Down',2001,'Oscar, best cinematography','nominated'::"awardresult"),
('The Man Who Wasn''t There',2001,'Oscar, best cinematography','nominated'::"awardresult"),
('Moulin Rouge!',2001,'Oscar, best cinematography','nominated'::"awardresult"),
('Wo hu cang long',2000,'Oscar, best cinematography','nominated'::"awardresult"),
('Gladiator',2000,'Oscar, best cinematography','nominated'::"awardresult"),
('Malèna',2000,'Oscar, best cinematography','nominated'::"awardresult"),
('O Brother, Where Art Thou?',2000,'Oscar, best cinematography','nominated'::"awardresult"),
('The Patriot',2000,'Oscar, best cinematography','nominated'::"awardresult"),
('American Beauty',1999,'Oscar, best cinematography','nominated'::"awardresult"),
('The End of the Affair',1999,'Oscar, best cinematography','nominated'::"awardresult"),
('The Insider',1999,'Oscar, best cinematography','nominated'::"awardresult"),
('Sleepy Hollow',1999,'Oscar, best cinematography','nominated'::"awardresult"),
('Snow Falling on Cedars',1999,'Oscar, best cinematography','nominated'::"awardresult"),
('Saving Private Ryan',1998,'Oscar, best cinematography','nominated'::"awardresult"),
('A Civil Action',1998,'Oscar, best cinematography','nominated'::"awardresult"),
('Elizabeth',1998,'Oscar, best cinematography','nominated'::"awardresult"),
('Shakespeare in Love',1998,'Oscar, best cinematography','nominated'::"awardresult"),
('The Thin Red Line',1998,'Oscar, best cinematography','nominated'::"awardresult"),
('Titanic',1997,'Oscar, best cinematography','nominated'::"awardresult"),
('Amistad',1997,'Oscar, best cinematography','nominated'::"awardresult"),
('Kundun',1997,'Oscar, best cinematography','nominated'::"awardresult"),
('L.A. Confidential',1997,'Oscar, best cinematography','nominated'::"awardresult"),
('The Wings of the Dove',1997,'Oscar, best cinematography','nominated'::"awardresult"),
('The English Patient',1996,'Oscar, best cinematography','nominated'::"awardresult"),
('Evita',1996,'Oscar, best cinematography','nominated'::"awardresult"),
('Fargo',1996,'Oscar, best cinematography','nominated'::"awardresult"),
('Fly Away Home',1996,'Oscar, best cinematography','nominated'::"awardresult"),
('Michael Collins',1996,'Oscar, best cinematography','nominated'::"awardresult"),
('Braveheart',1995,'Oscar, best cinematography','nominated'::"awardresult"),
('Batman Forever',1995,'Oscar, best cinematography','nominated'::"awardresult"),
('A Little Princess',1995,'Oscar, best cinematography','nominated'::"awardresult"),
('Sense and Sensibility',1995,'Oscar, best cinematography','nominated'::"awardresult"),
('Yao a yao, yao dao wai po qiao',1995,'Oscar, best cinematography','nominated'::"awardresult"),
('Legends of the Fall',1994,'Oscar, best cinematography','nominated'::"awardresult"),
('Forrest Gump',1994,'Oscar, best cinematography','nominated'::"awardresult"),
('The Shawshank Redemption',1994,'Oscar, best cinematography','nominated'::"awardresult"),
('Trois couleurs: Rouge',1994,'Oscar, best cinematography','nominated'::"awardresult"),
('Wyatt Earp',1994,'Oscar, best cinematography','nominated'::"awardresult"),
('Schindler''s List',1993,'Oscar, best cinematography','nominated'::"awardresult"),
('Ba wang bie ji',1993,'Oscar, best cinematography','nominated'::"awardresult"),
('The Fugitive',1993,'Oscar, best cinematography','nominated'::"awardresult"),
('The Piano',1993,'Oscar, best cinematography','nominated'::"awardresult"),
('Searching for Bobby Fischer',1993,'Oscar, best cinematography','nominated'::"awardresult"),
('A River Runs Through It',1992,'Oscar, best cinematography','nominated'::"awardresult"),
('Hoffa',1992,'Oscar, best cinematography','nominated'::"awardresult"),
('Howards End',1992,'Oscar, best cinematography','nominated'::"awardresult"),
('L''amant',1992,'Oscar, best cinematography','nominated'::"awardresult"),
('Unforgiven',1992,'Oscar, best cinematography','nominated'::"awardresult"),
('JFK',1991,'Oscar, best cinematography','nominated'::"awardresult"),
('Bugsy',1991,'Oscar, best cinematography','nominated'::"awardresult"),
('The Prince of Tides',1991,'Oscar, best cinematography','nominated'::"awardresult"),
('Terminator 2: Judgment Day',1991,'Oscar, best cinematography','nominated'::"awardresult"),
('Thelma & Louise',1991,'Oscar, best cinematography','nominated'::"awardresult"),
('Dances with Wolves',1990,'Oscar, best cinematography','nominated'::"awardresult"),
('Avalon',1990,'Oscar, best cinematography','nominated'::"awardresult"),
('Dick Tracy',1990,'Oscar, best cinematography','nominated'::"awardresult"),
('The Godfather Part III',1990,'Oscar, best cinematography','nominated'::"awardresult"),
('Henry & June',1990,'Oscar, best cinematography','nominated'::"awardresult"),
('Glory',1989,'Oscar, best cinematography','nominated'::"awardresult"),
('The Abyss',1989,'Oscar, best cinematography','nominated'::"awardresult"),
('Blaze',1989,'Oscar, best cinematography','nominated'::"awardresult"),
('Born on the Fourth of July',1989,'Oscar, best cinematography','nominated'::"awardresult"),
('The Fabulous Baker Boys',1989,'Oscar, best cinematography','nominated'::"awardresult"),
('Mississippi Burning',1988,'Oscar, best cinematography','nominated'::"awardresult"),
('Rain Man',1988,'Oscar, best cinematography','nominated'::"awardresult"),
('Tequila Sunrise',1988,'Oscar, best cinematography','nominated'::"awardresult"),
('The Unbearable Lightness of Being',1988,'Oscar, best cinematography','nominated'::"awardresult"),
('Who Framed Roger Rabbit',1988,'Oscar, best cinematography','nominated'::"awardresult"),
('The Last Emperor',1987,'Oscar, best cinematography','nominated'::"awardresult"),
('Broadcast News',1987,'Oscar, best cinematography','nominated'::"awardresult"),
('Empire of the Sun',1987,'Oscar, best cinematography','nominated'::"awardresult"),
('Hope and Glory',1987,'Oscar, best cinematography','nominated'::"awardresult"),
('Matewan',1987,'Oscar, best cinematography','nominated'::"awardresult"),
('The Mission',1986,'Oscar, best cinematography','nominated'::"awardresult"),
('Peggy Sue Got Married',1986,'Oscar, best cinematography','nominated'::"awardresult"),
('Platoon',1986,'Oscar, best cinematography','nominated'::"awardresult"),
('A Room with a View',1985,'Oscar, best cinematography','nominated'::"awardresult"),
('Star Trek IV: The Voyage Home',1986,'Oscar, best cinematography','nominated'::"awardresult"),
('Out of Africa',1985,'Oscar, best cinematography','nominated'::"awardresult"),
('The Color Purple',1985,'Oscar, best cinematography','nominated'::"awardresult"),
('Murphy''s Romance',1985,'Oscar, best cinematography','nominated'::"awardresult"),
('Ran',1985,'Oscar, best cinematography','nominated'::"awardresult"),
('Witness',1985,'Oscar, best cinematography','nominated'::"awardresult"),
('The Killing Fields',1984,'Oscar, best cinematography','nominated'::"awardresult"),
('Amadeus',1984,'Oscar, best cinematography','nominated'::"awardresult"),
('The Natural',1984,'Oscar, best cinematography','nominated'::"awardresult"),
('A Passage to India',1984,'Oscar, best cinematography','nominated'::"awardresult"),
('The River',1984,'Oscar, best cinematography','nominated'::"awardresult"),
('Fanny och Alexander',1982,'Oscar, best cinematography','nominated'::"awardresult"),
('Flashdance',1983,'Oscar, best cinematography','nominated'::"awardresult"),
('The Right Stuff',1983,'Oscar, best cinematography','nominated'::"awardresult"),
('WarGames',1983,'Oscar, best cinematography','nominated'::"awardresult"),
('Zelig',1983,'Oscar, best cinematography','nominated'::"awardresult"),
('Gandhi',1982,'Oscar, best cinematography','nominated'::"awardresult"),
('Das Boot',1981,'Oscar, best cinematography','nominated'::"awardresult"),
('E.T. the Extra-Terrestrial',1982,'Oscar, best cinematography','nominated'::"awardresult"),
('Sophie''s Choice',1982,'Oscar, best cinematography','nominated'::"awardresult"),
('Tootsie',1982,'Oscar, best cinematography','nominated'::"awardresult"),
('Reds',1981,'Oscar, best cinematography','nominated'::"awardresult"),
('Excalibur',1981,'Oscar, best cinematography','nominated'::"awardresult"),
('On Golden Pond',1981,'Oscar, best cinematography','nominated'::"awardresult"),
('Ragtime',1981,'Oscar, best cinematography','nominated'::"awardresult"),
('Raiders of the Lost Ark',1981,'Oscar, best cinematography','nominated'::"awardresult"),
('Tess',1979,'Oscar, best cinematography','nominated'::"awardresult"),
('The Blue Lagoon',1980,'Oscar, best cinematography','nominated'::"awardresult"),
('Coal Miner''s Daughter',1980,'Oscar, best cinematography','nominated'::"awardresult"),
('The Formula',1980,'Oscar, best cinematography','nominated'::"awardresult"),
('Raging Bull',1980,'Oscar, best cinematography','nominated'::"awardresult"),
('Apocalypse Now',1979,'Oscar, best cinematography','nominated'::"awardresult"),
('1941',1979,'Oscar, best cinematography','nominated'::"awardresult"),
('All That Jazz',1979,'Oscar, best cinematography','nominated'::"awardresult"),
('The Black Hole',1979,'Oscar, best cinematography','nominated'::"awardresult"),
('Kramer vs. Kramer',1979,'Oscar, best cinematography','nominated'::"awardresult"),
('Days of Heaven',1978,'Oscar, best cinematography','nominated'::"awardresult"),
('The Deer Hunter',1978,'Oscar, best cinematography','nominated'::"awardresult"),
('Heaven Can Wait',1978,'Oscar, best cinematography','nominated'::"awardresult"),
('Same Time, Next Year',1978,'Oscar, best cinematography','nominated'::"awardresult"),
('The Wiz',1978,'Oscar, best cinematography','nominated'::"awardresult"),
('Close Encounters of the Third Kind',1977,'Oscar, best cinematography','nominated'::"awardresult"),
('Islands in the Stream',1977,'Oscar, best cinematography','nominated'::"awardresult"),
('Julia',1977,'Oscar, best cinematography','nominated'::"awardresult"),
('Looking for Mr. Goodbar',1977,'Oscar, best cinematography','nominated'::"awardresult"),
('The Turning Point',1977,'Oscar, best cinematography','nominated'::"awardresult"),
('Bound for Glory',1976,'Oscar, best cinematography','nominated'::"awardresult"),
('King Kong',1976,'Oscar, best cinematography','nominated'::"awardresult"),
('Logan''s Run',1976,'Oscar, best cinematography','nominated'::"awardresult"),
('Network',1976,'Oscar, best cinematography','nominated'::"awardresult"),
('A Star Is Born',1976,'Oscar, best cinematography','nominated'::"awardresult"),
('Barry Lyndon',1975,'Oscar, best cinematography','nominated'::"awardresult"),
('The Day of the Locust',1975,'Oscar, best cinematography','nominated'::"awardresult"),
('Funny Lady',1975,'Oscar, best cinematography','nominated'::"awardresult"),
('The Hindenburg',1975,'Oscar, best cinematography','nominated'::"awardresult"),
('One Flew Over the Cuckoo''s Nest',1975,'Oscar, best cinematography','nominated'::"awardresult"),
('The Towering Inferno',1974,'Oscar, best cinematography','nominated'::"awardresult"),
('Chinatown',1974,'Oscar, best cinematography','nominated'::"awardresult"),
('Earthquake',1974,'Oscar, best cinematography','nominated'::"awardresult"),
('Lenny',1974,'Oscar, best cinematography','nominated'::"awardresult"),
('Murder on the Orient Express',1974,'Oscar, best cinematography','nominated'::"awardresult"),
('Viskningar och rop',1972,'Oscar, best cinematography','nominated'::"awardresult"),
('The Exorcist',1973,'Oscar, best cinematography','nominated'::"awardresult"),
('Jonathan Livingston Seagull',1973,'Oscar, best cinematography','nominated'::"awardresult"),
('The Sting',1973,'Oscar, best cinematography','nominated'::"awardresult"),
('The Way We Were',1973,'Oscar, best cinematography','nominated'::"awardresult"),
('Cabaret',1972,'Oscar, best cinematography','nominated'::"awardresult"),
('1776',1972,'Oscar, best cinematography','nominated'::"awardresult"),
('Butterflies Are Free',1972,'Oscar, best cinematography','nominated'::"awardresult"),
('The Poseidon Adventure',1972,'Oscar, best cinematography','nominated'::"awardresult"),
('Travels with My Aunt',1972,'Oscar, best cinematography','nominated'::"awardresult"),
('Fiddler on the Roof',1971,'Oscar, best cinematography','nominated'::"awardresult"),
('The French Connection',1971,'Oscar, best cinematography','nominated'::"awardresult"),
('The Last Picture Show',1971,'Oscar, best cinematography','nominated'::"awardresult"),
('Nicholas and Alexandra',1971,'Oscar, best cinematography','nominated'::"awardresult"),
('Summer of ''42',1971,'Oscar, best cinematography','nominated'::"awardresult"),
('Ryan''s Daughter',1970,'Oscar, best cinematography','nominated'::"awardresult"),
('Airport',1970,'Oscar, best cinematography','nominated'::"awardresult"),
('Patton',1970,'Oscar, best cinematography','nominated'::"awardresult"),
('Tora! Tora! Tora!',1970,'Oscar, best cinematography','nominated'::"awardresult"),
('Women in Love',1969,'Oscar, best cinematography','nominated'::"awardresult"),
('Butch Cassidy and the Sundance Kid',1969,'Oscar, best cinematography','nominated'::"awardresult"),
('Anne of the Thousand Days',1969,'Oscar, best cinematography','nominated'::"awardresult"),
('Bob & Carol & Ted & Alice',1969,'Oscar, best cinematography','nominated'::"awardresult"),
('Hello, Dolly!',1969,'Oscar, best cinematography','nominated'::"awardresult"),
('Marooned',1969,'Oscar, best cinematography','nominated'::"awardresult"),
('Romeo and Juliet',1968,'Oscar, best cinematography','nominated'::"awardresult"),
('Funny Girl',1968,'Oscar, best cinematography','nominated'::"awardresult"),
('Ice Station Zebra',1968,'Oscar, best cinematography','nominated'::"awardresult"),
('Oliver!',1968,'Oscar, best cinematography','nominated'::"awardresult"),
('Star!',1968,'Oscar, best cinematography','nominated'::"awardresult"),
('Bonnie and Clyde',1967,'Oscar, best cinematography','nominated'::"awardresult"),
('Camelot',1967,'Oscar, best cinematography','nominated'::"awardresult"),
('Doctor Dolittle',1967,'Oscar, best cinematography','nominated'::"awardresult"),
('The Graduate',1967,'Oscar, best cinematography','nominated'::"awardresult"),
('In Cold Blood',1967,'Oscar, best cinematography','nominated'::"awardresult"),
('Who''s Afraid of Virginia Woolf?',1966,'Oscar, best cinematography','nominated'::"awardresult"),
('The Fortune Cookie',1966,'Oscar, best cinematography','nominated'::"awardresult"),
('Georgy Girl',1966,'Oscar, best cinematography','nominated'::"awardresult"),
('Paris brûle-t-il?',1966,'Oscar, best cinematography','nominated'::"awardresult"),
('Seconds',1966,'Oscar, best cinematography','nominated'::"awardresult"),
('A Man for All Seasons',1966,'Oscar, best cinematography','nominated'::"awardresult"),
('Fantastic Voyage',1966,'Oscar, best cinematography','nominated'::"awardresult"),
('Hawaii',1966,'Oscar, best cinematography','nominated'::"awardresult"),
('The Professionals',1966,'Oscar, best cinematography','nominated'::"awardresult"),
('The Sand Pebbles',1966,'Oscar, best cinematography','nominated'::"awardresult"),
('Ship of Fools',1965,'Oscar, best cinematography','nominated'::"awardresult"),
('In Harm''s Way',1965,'Oscar, best cinematography','nominated'::"awardresult"),
('King Rat',1965,'Oscar, best cinematography','nominated'::"awardresult"),
('Morituri',1965,'Oscar, best cinematography','nominated'::"awardresult"),
('A Patch of Blue',1965,'Oscar, best cinematography','nominated'::"awardresult"),
('Doctor Zhivago',1965,'Oscar, best cinematography','nominated'::"awardresult"),
('The Agony and the Ecstasy',1965,'Oscar, best cinematography','nominated'::"awardresult"),
('The Great Race',1965,'Oscar, best cinematography','nominated'::"awardresult"),
('The Greatest Story Ever Told',1965,'Oscar, best cinematography','nominated'::"awardresult"),
('The Sound of Music',1965,'Oscar, best cinematography','nominated'::"awardresult"),
('Alexis Zorbas',1964,'Oscar, best cinematography','nominated'::"awardresult"),
('The Americanization of Emily',1964,'Oscar, best cinematography','nominated'::"awardresult"),
('Fate Is the Hunter',1964,'Oscar, best cinematography','nominated'::"awardresult"),
('Hush...Hush, Sweet Charlotte',1964,'Oscar, best cinematography','nominated'::"awardresult"),
('The Night of the Iguana',1964,'Oscar, best cinematography','nominated'::"awardresult"),
('My Fair Lady',1964,'Oscar, best cinematography','nominated'::"awardresult"),
('Becket',1964,'Oscar, best cinematography','nominated'::"awardresult"),
('Cheyenne Autumn',1964,'Oscar, best cinematography','nominated'::"awardresult"),
('Mary Poppins',1964,'Oscar, best cinematography','nominated'::"awardresult"),
('The Unsinkable Molly Brown',1964,'Oscar, best cinematography','nominated'::"awardresult"),
('Hud',1963,'Oscar, best cinematography','nominated'::"awardresult"),
('The Balcony',1963,'Oscar, best cinematography','nominated'::"awardresult"),
('The Caretakers',1963,'Oscar, best cinematography','nominated'::"awardresult"),
('Lilies of the Field',1963,'Oscar, best cinematography','nominated'::"awardresult"),
('Love with the Proper Stranger',1963,'Oscar, best cinematography','nominated'::"awardresult"),
('Cleopatra',1963,'Oscar, best cinematography','nominated'::"awardresult"),
('The Cardinal',1963,'Oscar, best cinematography','nominated'::"awardresult"),
('How the West Was Won',1962,'Oscar, best cinematography','nominated'::"awardresult"),
('Irma la Douce',1963,'Oscar, best cinematography','nominated'::"awardresult"),
('It''s a Mad Mad Mad Mad World',1963,'Oscar, best cinematography','nominated'::"awardresult"),
('The Longest Day',1962,'Oscar, best cinematography','nominated'::"awardresult"),
('Birdman of Alcatraz',1962,'Oscar, best cinematography','nominated'::"awardresult"),
('To Kill a Mockingbird',1962,'Oscar, best cinematography','nominated'::"awardresult"),
('Two for the Seesaw',1962,'Oscar, best cinematography','nominated'::"awardresult"),
('What Ever Happened to Baby Jane?',1962,'Oscar, best cinematography','nominated'::"awardresult"),
('Lawrence of Arabia',1962,'Oscar, best cinematography','nominated'::"awardresult"),
('Gypsy',1962,'Oscar, best cinematography','nominated'::"awardresult"),
('Hatari!',1962,'Oscar, best cinematography','nominated'::"awardresult"),
('Mutiny on the Bounty',1962,'Oscar, best cinematography','nominated'::"awardresult"),
('The Wonderful World of the Brothers Grimm',1962,'Oscar, best cinematography','nominated'::"awardresult"),
('The Hustler',1961,'Oscar, best cinematography','nominated'::"awardresult"),
('The Absent Minded Professor',1961,'Oscar, best cinematography','nominated'::"awardresult"),
('The Children''s Hour',1961,'Oscar, best cinematography','nominated'::"awardresult"),
('Judgment at Nuremberg',1961,'Oscar, best cinematography','nominated'::"awardresult"),
('One, Two, Three',1961,'Oscar, best cinematography','nominated'::"awardresult"),
('West Side Story',1961,'Oscar, best cinematography','nominated'::"awardresult"),
('Fanny',1961,'Oscar, best cinematography','nominated'::"awardresult"),
('Flower Drum Song',1961,'Oscar, best cinematography','nominated'::"awardresult"),
('A Majority of One',1961,'Oscar, best cinematography','nominated'::"awardresult"),
('One-Eyed Jacks',1961,'Oscar, best cinematography','nominated'::"awardresult"),
('Sons and Lovers',1960,'Oscar, best cinematography','nominated'::"awardresult"),
('The Apartment',1960,'Oscar, best cinematography','nominated'::"awardresult"),
('The Facts of Life',1960,'Oscar, best cinematography','nominated'::"awardresult"),
('Inherit the Wind',1960,'Oscar, best cinematography','nominated'::"awardresult"),
('Psycho',1960,'Oscar, best cinematography','nominated'::"awardresult"),
('Spartacus',1960,'Oscar, best cinematography','nominated'::"awardresult"),
('The Alamo',1960,'Oscar, best cinematography','nominated'::"awardresult"),
('BUtterfield 8',1960,'Oscar, best cinematography','nominated'::"awardresult"),
('Exodus',1960,'Oscar, best cinematography','nominated'::"awardresult"),
('Pepe',1960,'Oscar, best cinematography','nominated'::"awardresult"),
('The Diary of Anne Frank',1959,'Oscar, best cinematography','nominated'::"awardresult"),
('Anatomy of a Murder',1959,'Oscar, best cinematography','nominated'::"awardresult"),
('Career',1959,'Oscar, best cinematography','nominated'::"awardresult"),
('Some Like It Hot',1959,'Oscar, best cinematography','nominated'::"awardresult"),
('The Young Philadelphians',1959,'Oscar, best cinematography','nominated'::"awardresult"),
('Ben-Hur',1959,'Oscar, best cinematography','nominated'::"awardresult"),
('The Big Fisherman',1959,'Oscar, best cinematography','nominated'::"awardresult"),
('The Five Pennies',1959,'Oscar, best cinematography','nominated'::"awardresult"),
('The Nun''s Story',1959,'Oscar, best cinematography','nominated'::"awardresult"),
('Porgy and Bess',1959,'Oscar, best cinematography','nominated'::"awardresult"),
('The Defiant Ones',1958,'Oscar, best cinematography','nominated'::"awardresult"),
('Desire Under the Elms',1958,'Oscar, best cinematography','nominated'::"awardresult"),
('I Want to Live!',1958,'Oscar, best cinematography','nominated'::"awardresult"),
('Separate Tables',1958,'Oscar, best cinematography','nominated'::"awardresult"),
('The Young Lions',1958,'Oscar, best cinematography','nominated'::"awardresult"),
('Gigi',1958,'Oscar, best cinematography','nominated'::"awardresult"),
('Auntie Mame',1958,'Oscar, best cinematography','nominated'::"awardresult"),
('Cat on a Hot Tin Roof',1958,'Oscar, best cinematography','nominated'::"awardresult"),
('The Old Man and the Sea',1958,'Oscar, best cinematography','nominated'::"awardresult"),
('South Pacific',1958,'Oscar, best cinematography','nominated'::"awardresult"),
('The Bridge on the River Kwai',1957,'Oscar, best cinematography','nominated'::"awardresult"),
('An Affair to Remember',1957,'Oscar, best cinematography','nominated'::"awardresult"),
('Funny Face',1957,'Oscar, best cinematography','nominated'::"awardresult"),
('Peyton Place',1957,'Oscar, best cinematography','nominated'::"awardresult"),
('Sayonara',1957,'Oscar, best cinematography','nominated'::"awardresult"),
('Somebody Up There Likes Me',1956,'Oscar, best cinematography','nominated'::"awardresult"),
('Baby Doll',1956,'Oscar, best cinematography','nominated'::"awardresult"),
('The Bad Seed',1956,'Oscar, best cinematography','nominated'::"awardresult"),
('The Harder They Fall',1956,'Oscar, best cinematography','nominated'::"awardresult"),
('Stagecoach to Fury',1956,'Oscar, best cinematography','nominated'::"awardresult"),
('Around the World in 80 Days',1956,'Oscar, best cinematography','nominated'::"awardresult"),
('The Eddy Duchin Story',1956,'Oscar, best cinematography','nominated'::"awardresult"),
('The King and I',1956,'Oscar, best cinematography','nominated'::"awardresult"),
('The Ten Commandments',1956,'Oscar, best cinematography','nominated'::"awardresult"),
('War and Peace',1956,'Oscar, best cinematography','nominated'::"awardresult"),
('The Rose Tattoo',1955,'Oscar, best cinematography','nominated'::"awardresult"),
('Blackboard Jungle',1955,'Oscar, best cinematography','nominated'::"awardresult"),
('I''ll Cry Tomorrow',1955,'Oscar, best cinematography','nominated'::"awardresult"),
('Marty',1955,'Oscar, best cinematography','nominated'::"awardresult"),
('Queen Bee',1955,'Oscar, best cinematography','nominated'::"awardresult"),
('To Catch a Thief',1955,'Oscar, best cinematography','nominated'::"awardresult"),
('Guys and Dolls',1955,'Oscar, best cinematography','nominated'::"awardresult"),
('Love Is a Many-Splendored Thing',1955,'Oscar, best cinematography','nominated'::"awardresult"),
('A Man Called Peter',1955,'Oscar, best cinematography','nominated'::"awardresult"),
('Oklahoma!',1955,'Oscar, best cinematography','nominated'::"awardresult"),
('On the Waterfront',1954,'Oscar, best cinematography','nominated'::"awardresult"),
('The Country Girl',1954,'Oscar, best cinematography','nominated'::"awardresult"),
('Executive Suite',1954,'Oscar, best cinematography','nominated'::"awardresult"),
('Rogue Cop',1954,'Oscar, best cinematography','nominated'::"awardresult"),
('Sabrina',1954,'Oscar, best cinematography','nominated'::"awardresult"),
('Three Coins in the Fountain',1954,'Oscar, best cinematography','nominated'::"awardresult"),
('The Egyptian',1954,'Oscar, best cinematography','nominated'::"awardresult"),
('Rear Window',1954,'Oscar, best cinematography','nominated'::"awardresult"),
('Seven Brides for Seven Brothers',1954,'Oscar, best cinematography','nominated'::"awardresult"),
('The Silver Chalice',1954,'Oscar, best cinematography','nominated'::"awardresult"),
('From Here to Eternity',1953,'Oscar, best cinematography','nominated'::"awardresult"),
('The Four Poster',1952,'Oscar, best cinematography','nominated'::"awardresult"),
('Julius Caesar',1953,'Oscar, best cinematography','nominated'::"awardresult"),
('Martin Luther',1953,'Oscar, best cinematography','nominated'::"awardresult"),
('Roman Holiday',1953,'Oscar, best cinematography','nominated'::"awardresult"),
('Shane',1953,'Oscar, best cinematography','nominated'::"awardresult"),
('All the Brothers Were Valiant',1953,'Oscar, best cinematography','nominated'::"awardresult"),
('Beneath the 12-Mile Reef',1953,'Oscar, best cinematography','nominated'::"awardresult"),
('Lili',1953,'Oscar, best cinematography','nominated'::"awardresult"),
('The Robe',1953,'Oscar, best cinematography','nominated'::"awardresult"),
('The Bad and the Beautiful',1952,'Oscar, best cinematography','nominated'::"awardresult"),
('The Big Sky',1952,'Oscar, best cinematography','nominated'::"awardresult"),
('My Cousin Rachel',1952,'Oscar, best cinematography','nominated'::"awardresult"),
('Navajo',1952,'Oscar, best cinematography','nominated'::"awardresult"),
('Sudden Fear',1952,'Oscar, best cinematography','nominated'::"awardresult"),
('The Quiet Man',1952,'Oscar, best cinematography','nominated'::"awardresult"),
('Hans Christian Andersen',1952,'Oscar, best cinematography','nominated'::"awardresult"),
('Ivanhoe',1952,'Oscar, best cinematography','nominated'::"awardresult"),
('Million Dollar Mermaid',1952,'Oscar, best cinematography','nominated'::"awardresult"),
('The Snows of Kilimanjaro',1952,'Oscar, best cinematography','nominated'::"awardresult"),
('A Place in the Sun',1951,'Oscar, best cinematography','nominated'::"awardresult"),
('Death of a Salesman',1951,'Oscar, best cinematography','nominated'::"awardresult"),
('The Frogmen',1951,'Oscar, best cinematography','nominated'::"awardresult"),
('Strangers on a Train',1951,'Oscar, best cinematography','nominated'::"awardresult"),
('A Streetcar Named Desire',1951,'Oscar, best cinematography','nominated'::"awardresult"),
('An American in Paris',1951,'Oscar, best cinematography','nominated'::"awardresult"),
('David and Bathsheba',1951,'Oscar, best cinematography','nominated'::"awardresult"),
('Quo Vadis',1951,'Oscar, best cinematography','nominated'::"awardresult"),
('Show Boat',1951,'Oscar, best cinematography','nominated'::"awardresult"),
('When Worlds Collide',1951,'Oscar, best cinematography','nominated'::"awardresult"),
('The Third Man',1949,'Oscar, best cinematography','nominated'::"awardresult"),
('All About Eve',1950,'Oscar, best cinematography','nominated'::"awardresult"),
('The Asphalt Jungle',1950,'Oscar, best cinematography','nominated'::"awardresult"),
('The Furies',1950,'Oscar, best cinematography','nominated'::"awardresult"),
('Sunset Blvd.',1950,'Oscar, best cinematography','nominated'::"awardresult"),
('King Solomon''s Mines',1950,'Oscar, best cinematography','nominated'::"awardresult"),
('Annie Get Your Gun',1950,'Oscar, best cinematography','nominated'::"awardresult"),
('Broken Arrow',1950,'Oscar, best cinematography','nominated'::"awardresult"),
('The Flame and the Arrow',1950,'Oscar, best cinematography','nominated'::"awardresult"),
('Samson and Delilah',1949,'Oscar, best cinematography','nominated'::"awardresult"),
('Battleground',1949,'Oscar, best cinematography','nominated'::"awardresult"),
('Champion',1949,'Oscar, best cinematography','nominated'::"awardresult"),
('Come to the Stable',1949,'Oscar, best cinematography','nominated'::"awardresult"),
('The Heiress',1949,'Oscar, best cinematography','nominated'::"awardresult"),
('Prince of Foxes',1949,'Oscar, best cinematography','nominated'::"awardresult"),
('She Wore a Yellow Ribbon',1949,'Oscar, best cinematography','nominated'::"awardresult"),
('The Barkleys of Broadway',1949,'Oscar, best cinematography','nominated'::"awardresult"),
('Little Women',1949,'Oscar, best cinematography','nominated'::"awardresult"),
('Jolson Sings Again',1949,'Oscar, best cinematography','nominated'::"awardresult"),
('Sand',1949,'Oscar, best cinematography','nominated'::"awardresult"),
('The Naked City',1948,'Oscar, best cinematography','nominated'::"awardresult"),
('A Foreign Affair',1948,'Oscar, best cinematography','nominated'::"awardresult"),
('I Remember Mama',1948,'Oscar, best cinematography','nominated'::"awardresult"),
('Johnny Belinda',1948,'Oscar, best cinematography','nominated'::"awardresult"),
('Portrait of Jennie',1948,'Oscar, best cinematography','nominated'::"awardresult"),
('Joan of Arc',1948,'Oscar, best cinematography','nominated'::"awardresult"),
('Green Grass of Wyoming',1948,'Oscar, best cinematography','nominated'::"awardresult"),
('The Loves of Carmen',1948,'Oscar, best cinematography','nominated'::"awardresult"),
('The Three Musketeers',1948,'Oscar, best cinematography','nominated'::"awardresult"),
('Great Expectations',1946,'Oscar, best cinematography','nominated'::"awardresult"),
('The Ghost and Mrs. Muir',1947,'Oscar, best cinematography','nominated'::"awardresult"),
('Green Dolphin Street',1947,'Oscar, best cinematography','nominated'::"awardresult"),
('Black Narcissus',1947,'Oscar, best cinematography','nominated'::"awardresult"),
('Life with Father',1947,'Oscar, best cinematography','nominated'::"awardresult"),
('Mother Wore Tights',1947,'Oscar, best cinematography','nominated'::"awardresult"),
('Anna and the King of Siam',1946,'Oscar, best cinematography','nominated'::"awardresult"),
('The Green Years',1946,'Oscar, best cinematography','nominated'::"awardresult"),
('The Yearling',1946,'Oscar, best cinematography','nominated'::"awardresult"),
('The Jolson Story',1946,'Oscar, best cinematography','nominated'::"awardresult"),
('The Picture of Dorian Gray',1945,'Oscar, best cinematography','nominated'::"awardresult"),
('The Keys of the Kingdom',1944,'Oscar, best cinematography','nominated'::"awardresult"),
('The Lost Weekend',1945,'Oscar, best cinematography','nominated'::"awardresult"),
('Mildred Pierce',1945,'Oscar, best cinematography','nominated'::"awardresult"),
('Spellbound',1945,'Oscar, best cinematography','nominated'::"awardresult"),
('Leave Her to Heaven',1945,'Oscar, best cinematography','nominated'::"awardresult"),
('Anchors Aweigh',1945,'Oscar, best cinematography','nominated'::"awardresult"),
('National Velvet',1944,'Oscar, best cinematography','nominated'::"awardresult"),
('A Song to Remember',1945,'Oscar, best cinematography','nominated'::"awardresult"),
('The Spanish Main',1945,'Oscar, best cinematography','nominated'::"awardresult"),
('Laura',1944,'Oscar, best cinematography','nominated'::"awardresult"),
('Double Indemnity',1944,'Oscar, best cinematography','nominated'::"awardresult"),
('Dragon Seed',1944,'Oscar, best cinematography','nominated'::"awardresult"),
('Gaslight',1944,'Oscar, best cinematography','nominated'::"awardresult"),
('Going My Way',1944,'Oscar, best cinematography','nominated'::"awardresult"),
('Lifeboat',1944,'Oscar, best cinematography','nominated'::"awardresult"),
('Since You Went Away',1944,'Oscar, best cinematography','nominated'::"awardresult"),
('Thirty Seconds Over Tokyo',1944,'Oscar, best cinematography','nominated'::"awardresult"),
('The Uninvited',1944,'Oscar, best cinematography','nominated'::"awardresult"),
('The White Cliffs of Dover',1944,'Oscar, best cinematography','nominated'::"awardresult"),
('Wilson',1944,'Oscar, best cinematography','nominated'::"awardresult"),
('Cover Girl',1944,'Oscar, best cinematography','nominated'::"awardresult"),
('Home in Indiana',1944,'Oscar, best cinematography','nominated'::"awardresult"),
('Kismet',1944,'Oscar, best cinematography','nominated'::"awardresult"),
('Lady in the Dark',1944,'Oscar, best cinematography','nominated'::"awardresult"),
('Meet Me in St. Louis',1944,'Oscar, best cinematography','nominated'::"awardresult"),
('The Song of Bernadette',1943,'Oscar, best cinematography','nominated'::"awardresult"),
('Air Force',1943,'Oscar, best cinematography','nominated'::"awardresult"),
('Casablanca',1942,'Oscar, best cinematography','nominated'::"awardresult"),
('Corvette K-225',1943,'Oscar, best cinematography','nominated'::"awardresult"),
('Five Graves to Cairo',1943,'Oscar, best cinematography','nominated'::"awardresult"),
('The Human Comedy',1943,'Oscar, best cinematography','nominated'::"awardresult"),
('Madame Curie',1943,'Oscar, best cinematography','nominated'::"awardresult"),
('The North Star',1943,'Oscar, best cinematography','nominated'::"awardresult"),
('Sahara',1943,'Oscar, best cinematography','nominated'::"awardresult"),
('So Proudly We Hail!',1943,'Oscar, best cinematography','nominated'::"awardresult"),
('Phantom of the Opera',1943,'Oscar, best cinematography','nominated'::"awardresult"),
('For Whom the Bell Tolls',1943,'Oscar, best cinematography','nominated'::"awardresult"),
('Heaven Can Wait',1943,'Oscar, best cinematography','nominated'::"awardresult"),
('Hello Frisco, Hello',1943,'Oscar, best cinematography','nominated'::"awardresult"),
('Lassie Come Home',1943,'Oscar, best cinematography','nominated'::"awardresult"),
('Thousands Cheer',1943,'Oscar, best cinematography','nominated'::"awardresult"),
('Mrs. Miniver',1942,'Oscar, best cinematography','nominated'::"awardresult"),
('Kings Row',1942,'Oscar, best cinematography','nominated'::"awardresult"),
('The Magnificent Ambersons',1942,'Oscar, best cinematography','nominated'::"awardresult"),
('Moontide',1942,'Oscar, best cinematography','nominated'::"awardresult"),
('The Pied Piper',1942,'Oscar, best cinematography','nominated'::"awardresult"),
('The Pride of the Yankees',1942,'Oscar, best cinematography','nominated'::"awardresult"),
('Take a Letter, Darling',1942,'Oscar, best cinematography','nominated'::"awardresult"),
('The Talk of the Town',1942,'Oscar, best cinematography','nominated'::"awardresult"),
('Ten Gentlemen from West Point',1942,'Oscar, best cinematography','nominated'::"awardresult"),
('This Above All',1942,'Oscar, best cinematography','nominated'::"awardresult"),
('The Black Swan',1942,'Oscar, best cinematography','nominated'::"awardresult"),
('Arabian Nights',1942,'Oscar, best cinematography','nominated'::"awardresult"),
('Captains of the Clouds',1942,'Oscar, best cinematography','nominated'::"awardresult"),
('Jungle Book',1942,'Oscar, best cinematography','nominated'::"awardresult"),
('Reap the Wild Wind',1942,'Oscar, best cinematography','nominated'::"awardresult"),
('To the Shores of Tripoli',1942,'Oscar, best cinematography','nominated'::"awardresult"),
('How Green Was My Valley',1941,'Oscar, best cinematography','nominated'::"awardresult"),
('The Chocolate Soldier',1941,'Oscar, best cinematography','nominated'::"awardresult"),
('Citizen Kane',1941,'Oscar, best cinematography','nominated'::"awardresult"),
('Dr. Jekyll and Mr. Hyde',1941,'Oscar, best cinematography','nominated'::"awardresult"),
('Here Comes Mr. Jordan',1941,'Oscar, best cinematography','nominated'::"awardresult"),
('Hold Back the Dawn',1941,'Oscar, best cinematography','nominated'::"awardresult"),
('Sergeant York',1941,'Oscar, best cinematography','nominated'::"awardresult"),
('Sun Valley Serenade',1941,'Oscar, best cinematography','nominated'::"awardresult"),
('Sundown',1941,'Oscar, best cinematography','nominated'::"awardresult"),
('That Hamilton Woman',1941,'Oscar, best cinematography','nominated'::"awardresult"),
('Blood and Sand',1941,'Oscar, best cinematography','nominated'::"awardresult"),
('Aloma of the South Seas',1941,'Oscar, best cinematography','nominated'::"awardresult"),
('Billy the Kid',1941,'Oscar, best cinematography','nominated'::"awardresult"),
('Blossoms in the Dust',1941,'Oscar, best cinematography','nominated'::"awardresult"),
('Dive Bomber',1941,'Oscar, best cinematography','nominated'::"awardresult"),
('Louisiana Purchase',1941,'Oscar, best cinematography','nominated'::"awardresult"),
('Rebecca',1940,'Oscar, best cinematography','nominated'::"awardresult"),
('Abe Lincoln in Illinois',1940,'Oscar, best cinematography','nominated'::"awardresult"),
('All This, and Heaven Too',1940,'Oscar, best cinematography','nominated'::"awardresult"),
('Arise, My Love',1940,'Oscar, best cinematography','nominated'::"awardresult"),
('Boom Town',1940,'Oscar, best cinematography','nominated'::"awardresult"),
('Foreign Correspondent',1940,'Oscar, best cinematography','nominated'::"awardresult"),
('The Letter',1940,'Oscar, best cinematography','nominated'::"awardresult"),
('The Long Voyage Home',1940,'Oscar, best cinematography','nominated'::"awardresult"),
('Spring Parade',1940,'Oscar, best cinematography','nominated'::"awardresult"),
('Waterloo Bridge',1940,'Oscar, best cinematography','nominated'::"awardresult"),
('The Thief of Bagdad',1940,'Oscar, best cinematography','nominated'::"awardresult"),
('Bitter Sweet',1940,'Oscar, best cinematography','nominated'::"awardresult"),
('The Blue Bird',1940,'Oscar, best cinematography','nominated'::"awardresult"),
('Down Argentine Way',1940,'Oscar, best cinematography','nominated'::"awardresult"),
('North West Mounted Police',1940,'Oscar, best cinematography','nominated'::"awardresult"),
('''Northwest Passage'' (Book I -- Rogers'' Rangers)',1940,'Oscar, best cinematography','nominated'::"awardresult"),
('Wuthering Heights',1939,'Oscar, best cinematography','nominated'::"awardresult"),
('First Love',1939,'Oscar, best cinematography','nominated'::"awardresult"),
('The Great Victor Herbert',1939,'Oscar, best cinematography','nominated'::"awardresult"),
('Gunga Din',1939,'Oscar, best cinematography','nominated'::"awardresult"),
('Intermezzo: A Love Story',1939,'Oscar, best cinematography','nominated'::"awardresult"),
('Juarez',1939,'Oscar, best cinematography','nominated'::"awardresult"),
('Lady of the Tropics',1939,'Oscar, best cinematography','nominated'::"awardresult"),
('Only Angels Have Wings',1939,'Oscar, best cinematography','nominated'::"awardresult"),
('The Rains Came',1939,'Oscar, best cinematography','nominated'::"awardresult"),
('Stagecoach',1939,'Oscar, best cinematography','nominated'::"awardresult"),
('Gone with the Wind',1939,'Oscar, best cinematography','nominated'::"awardresult"),
('Drums Along the Mohawk',1939,'Oscar, best cinematography','nominated'::"awardresult"),
('The Four Feathers',1939,'Oscar, best cinematography','nominated'::"awardresult"),
('The Mikado',1939,'Oscar, best cinematography','nominated'::"awardresult"),
('The Private Lives of Elizabeth and Essex',1939,'Oscar, best cinematography','nominated'::"awardresult"),
('The Wizard of Oz',1939,'Oscar, best cinematography','nominated'::"awardresult"),
('The Great Waltz',1938,'Oscar, best cinematography','nominated'::"awardresult"),
('Algiers',1938,'Oscar, best cinematography','nominated'::"awardresult"),
('Army Girl',1938,'Oscar, best cinematography','nominated'::"awardresult"),
('The Buccaneer',1938,'Oscar, best cinematography','nominated'::"awardresult"),
('Jezebel',1938,'Oscar, best cinematography','nominated'::"awardresult"),
('Mad About Music',1938,'Oscar, best cinematography','nominated'::"awardresult"),
('Merrily We Live',1938,'Oscar, best cinematography','nominated'::"awardresult"),
('Suez',1938,'Oscar, best cinematography','nominated'::"awardresult"),
('Vivacious Lady',1938,'Oscar, best cinematography','nominated'::"awardresult"),
('You Can''t Take It with You',1938,'Oscar, best cinematography','nominated'::"awardresult"),
('The Young in Heart',1938,'Oscar, best cinematography','nominated'::"awardresult"),
('The Good Earth',1937,'Oscar, best cinematography','nominated'::"awardresult"),
('Dead End',1937,'Oscar, best cinematography','nominated'::"awardresult"),
('Wings Over Honolulu',1937,'Oscar, best cinematography','nominated'::"awardresult"),
('Anthony Adverse',1936,'Oscar, best cinematography','nominated'::"awardresult"),
('The General Died at Dawn',1936,'Oscar, best cinematography','nominated'::"awardresult"),
('The Gorgeous Hussy',1936,'Oscar, best cinematography','nominated'::"awardresult"),
('A Midsummer Night''s Dream',1935,'Oscar, best cinematography','nominated'::"awardresult"),
('Barbary Coast',1935,'Oscar, best cinematography','nominated'::"awardresult"),
('The Crusades',1935,'Oscar, best cinematography','nominated'::"awardresult"),
('Les Misérables',1935,'Oscar, best cinematography','nominated'::"awardresult"),
('Cleopatra',1934,'Oscar, best cinematography','nominated'::"awardresult"),
('The Affairs of Cellini',1934,'Oscar, best cinematography','nominated'::"awardresult"),
('Operator 13',1934,'Oscar, best cinematography','nominated'::"awardresult"),
('A Farewell to Arms',1932,'Oscar, best cinematography','nominated'::"awardresult"),
('Reunion in Vienna',1933,'Oscar, best cinematography','nominated'::"awardresult"),
('The Sign of the Cross',1932,'Oscar, best cinematography','nominated'::"awardresult"),
('Shanghai Express',1932,'Oscar, best cinematography','nominated'::"awardresult"),
('Arrowsmith',1931,'Oscar, best cinematography','nominated'::"awardresult"),
('Dr. Jekyll and Mr. Hyde',1931,'Oscar, best cinematography','nominated'::"awardresult"),
('Tabu: A Story of the South Seas',1931,'Oscar, best cinematography','nominated'::"awardresult"),
('Cimarron',1931,'Oscar, best cinematography','nominated'::"awardresult"),
('Morocco',1930,'Oscar, best cinematography','nominated'::"awardresult"),
('The Right to Love',1930,'Oscar, best cinematography','nominated'::"awardresult"),
('Svengali',1931,'Oscar, best cinematography','nominated'::"awardresult"),
('With Byrd at the South Pole',1930,'Oscar, best cinematography','nominated'::"awardresult"),
('All Quiet on the Western Front',1930,'Oscar, best cinematography','nominated'::"awardresult"),
('Anna Christie',1930,'Oscar, best cinematography','nominated'::"awardresult"),
('Hell''s Angels',1930,'Oscar, best cinematography','nominated'::"awardresult"),
('The Love Parade',1929,'Oscar, best cinematography','nominated'::"awardresult"),
('White Shadows in the South Seas',1928,'Oscar, best cinematography','nominated'::"awardresult"),
('4 Devils',1928,'Oscar, best cinematography','nominated'::"awardresult"),
('The Divine Lady',1928,'Oscar, best cinematography','nominated'::"awardresult"),
('In Old Arizona',1928,'Oscar, best cinematography','nominated'::"awardresult"),
('Our Dancing Daughters',1928,'Oscar, best cinematography','nominated'::"awardresult"),
('Street Angel',1928,'Oscar, best cinematography','nominated'::"awardresult"),
('Sunrise: A Song of Two Humans',1927,'Oscar, best cinematography','nominated'::"awardresult"),
('The Devil Dancer',1927,'Oscar, best cinematography','nominated'::"awardresult"),
('The Magic Flame',1927,'Oscar, best cinematography','nominated'::"awardresult"),
('Sadie Thompson',1928,'Oscar, best cinematography','nominated'::"awardresult"))i(title,"year",award,"result") 
 WHERE EXISTS(SELECT FROM movies m  
 WHERE (m.title)=(i.title) AND (m.year)=(i.year)  
 FOR SHARE)
 ON CONFLICT DO NOTHING;
INSERT INTO movieawards(title,"year",award,"result")
SELECT i.*
FROM (VALUES
('Life of Pi',2012,'Oscar, best cinematography','won'::"awardresult"),
('Hugo',2011,'Oscar, best cinematography','won'::"awardresult"),
('Inception',2010,'Oscar, best cinematography','won'::"awardresult"),
('Avatar',2009,'Oscar, best cinematography','won'::"awardresult"),
('Slumdog Millionaire',2008,'Oscar, best cinematography','won'::"awardresult"),
('There Will Be Blood',2007,'Oscar, best cinematography','won'::"awardresult"),
('El laberinto del fauno',2006,'Oscar, best cinematography','won'::"awardresult"),
('Memoirs of a Geisha',2005,'Oscar, best cinematography','won'::"awardresult"),
('The Aviator',2004,'Oscar, best cinematography','won'::"awardresult"),
('Master and Commander: The Far Side of the World',2003,'Oscar, best cinematography','won'::"awardresult"),
('Road to Perdition',2002,'Oscar, best cinematography','won'::"awardresult"),
('The Lord of the Rings: The Fellowship of the Ring',2001,'Oscar, best cinematography','won'::"awardresult"),
('Wo hu cang long',2000,'Oscar, best cinematography','won'::"awardresult"),
('American Beauty',1999,'Oscar, best cinematography','won'::"awardresult"),
('Saving Private Ryan',1998,'Oscar, best cinematography','won'::"awardresult"),
('Titanic',1997,'Oscar, best cinematography','won'::"awardresult"),
('The English Patient',1996,'Oscar, best cinematography','won'::"awardresult"),
('Braveheart',1995,'Oscar, best cinematography','won'::"awardresult"),
('Legends of the Fall',1994,'Oscar, best cinematography','won'::"awardresult"),
('Schindler''s List',1993,'Oscar, best cinematography','won'::"awardresult"),
('A River Runs Through It',1992,'Oscar, best cinematography','won'::"awardresult"),
('JFK',1991,'Oscar, best cinematography','won'::"awardresult"),
('Dances with Wolves',1990,'Oscar, best cinematography','won'::"awardresult"),
('Glory',1989,'Oscar, best cinematography','won'::"awardresult"),
('Mississippi Burning',1988,'Oscar, best cinematography','won'::"awardresult"),
('The Last Emperor',1987,'Oscar, best cinematography','won'::"awardresult"),
('The Mission',1986,'Oscar, best cinematography','won'::"awardresult"),
('Out of Africa',1985,'Oscar, best cinematography','won'::"awardresult"),
('The Killing Fields',1984,'Oscar, best cinematography','won'::"awardresult"),
('Fanny och Alexander',1982,'Oscar, best cinematography','won'::"awardresult"),
('Gandhi',1982,'Oscar, best cinematography','won'::"awardresult"),
('Reds',1981,'Oscar, best cinematography','won'::"awardresult"),
('Tess',1979,'Oscar, best cinematography','won'::"awardresult"),
('Apocalypse Now',1979,'Oscar, best cinematography','won'::"awardresult"),
('Days of Heaven',1978,'Oscar, best cinematography','won'::"awardresult"),
('Close Encounters of the Third Kind',1977,'Oscar, best cinematography','won'::"awardresult"),
('Bound for Glory',1976,'Oscar, best cinematography','won'::"awardresult"),
('Barry Lyndon',1975,'Oscar, best cinematography','won'::"awardresult"),
('The Towering Inferno',1974,'Oscar, best cinematography','won'::"awardresult"),
('Viskningar och rop',1972,'Oscar, best cinematography','won'::"awardresult"),
('Cabaret',1972,'Oscar, best cinematography','won'::"awardresult"),
('Fiddler on the Roof',1971,'Oscar, best cinematography','won'::"awardresult"),
('Ryan''s Daughter',1970,'Oscar, best cinematography','won'::"awardresult"),
('Butch Cassidy and the Sundance Kid',1969,'Oscar, best cinematography','won'::"awardresult"),
('Romeo and Juliet',1968,'Oscar, best cinematography','won'::"awardresult"),
('Bonnie and Clyde',1967,'Oscar, best cinematography','won'::"awardresult"),
('Who''s Afraid of Virginia Woolf?',1966,'Oscar, best cinematography','won'::"awardresult"),
('A Man for All Seasons',1966,'Oscar, best cinematography','won'::"awardresult"),
('Ship of Fools',1965,'Oscar, best cinematography','won'::"awardresult"),
('Doctor Zhivago',1965,'Oscar, best cinematography','won'::"awardresult"),
('Alexis Zorbas',1964,'Oscar, best cinematography','won'::"awardresult"),
('My Fair Lady',1964,'Oscar, best cinematography','won'::"awardresult"),
('Hud',1963,'Oscar, best cinematography','won'::"awardresult"),
('Cleopatra',1963,'Oscar, best cinematography','won'::"awardresult"),
('The Longest Day',1962,'Oscar, best cinematography','won'::"awardresult"),
('Lawrence of Arabia',1962,'Oscar, best cinematography','won'::"awardresult"),
('The Hustler',1961,'Oscar, best cinematography','won'::"awardresult"),
('West Side Story',1961,'Oscar, best cinematography','won'::"awardresult"),
('Sons and Lovers',1960,'Oscar, best cinematography','won'::"awardresult"),
('Spartacus',1960,'Oscar, best cinematography','won'::"awardresult"),
('The Diary of Anne Frank',1959,'Oscar, best cinematography','won'::"awardresult"),
('Ben-Hur',1959,'Oscar, best cinematography','won'::"awardresult"),
('The Defiant Ones',1958,'Oscar, best cinematography','won'::"awardresult"),
('Gigi',1958,'Oscar, best cinematography','won'::"awardresult"),
('The Bridge on the River Kwai',1957,'Oscar, best cinematography','won'::"awardresult"),
('Somebody Up There Likes Me',1956,'Oscar, best cinematography','won'::"awardresult"),
('Around the World in 80 Days',1956,'Oscar, best cinematography','won'::"awardresult"),
('The Rose Tattoo',1955,'Oscar, best cinematography','won'::"awardresult"),
('To Catch a Thief',1955,'Oscar, best cinematography','won'::"awardresult"),
('On the Waterfront',1954,'Oscar, best cinematography','won'::"awardresult"),
('Three Coins in the Fountain',1954,'Oscar, best cinematography','won'::"awardresult"),
('From Here to Eternity',1953,'Oscar, best cinematography','won'::"awardresult"),
('Shane',1953,'Oscar, best cinematography','won'::"awardresult"),
('The Bad and the Beautiful',1952,'Oscar, best cinematography','won'::"awardresult"),
('The Quiet Man',1952,'Oscar, best cinematography','won'::"awardresult"),
('A Place in the Sun',1951,'Oscar, best cinematography','won'::"awardresult"),
('An American in Paris',1951,'Oscar, best cinematography','won'::"awardresult"),
('The Third Man',1949,'Oscar, best cinematography','won'::"awardresult"),
('King Solomon''s Mines',1950,'Oscar, best cinematography','won'::"awardresult"),
('Battleground',1949,'Oscar, best cinematography','won'::"awardresult"),
('She Wore a Yellow Ribbon',1949,'Oscar, best cinematography','won'::"awardresult"),
('The Naked City',1948,'Oscar, best cinematography','won'::"awardresult"),
('Joan of Arc',1948,'Oscar, best cinematography','won'::"awardresult"),
('Great Expectations',1946,'Oscar, best cinematography','won'::"awardresult"),
('Black Narcissus',1947,'Oscar, best cinematography','won'::"awardresult"),
('Anna and the King of Siam',1946,'Oscar, best cinematography','won'::"awardresult"),
('The Yearling',1946,'Oscar, best cinematography','won'::"awardresult"),
('The Picture of Dorian Gray',1945,'Oscar, best cinematography','won'::"awardresult"),
('Leave Her to Heaven',1945,'Oscar, best cinematography','won'::"awardresult"),
('Laura',1944,'Oscar, best cinematography','won'::"awardresult"),
('Wilson',1944,'Oscar, best cinematography','won'::"awardresult"),
('The Song of Bernadette',1943,'Oscar, best cinematography','won'::"awardresult"),
('Phantom of the Opera',1943,'Oscar, best cinematography','won'::"awardresult"),
('Mrs. Miniver',1942,'Oscar, best cinematography','won'::"awardresult"),
('The Black Swan',1942,'Oscar, best cinematography','won'::"awardresult"),
('How Green Was My Valley',1941,'Oscar, best cinematography','won'::"awardresult"),
('Blood and Sand',1941,'Oscar, best cinematography','won'::"awardresult"),
('Rebecca',1940,'Oscar, best cinematography','won'::"awardresult"),
('The Thief of Bagdad',1940,'Oscar, best cinematography','won'::"awardresult"),
('Wuthering Heights',1939,'Oscar, best cinematography','won'::"awardresult"),
('Gone with the Wind',1939,'Oscar, best cinematography','won'::"awardresult"),
('The Great Waltz',1938,'Oscar, best cinematography','won'::"awardresult"),
('Sweethearts',1938,'Oscar, best cinematography','won'::"awardresult"),
('The Good Earth',1937,'Oscar, best cinematography','won'::"awardresult"),
('A Star Is Born',1937,'Oscar, best cinematography','won'::"awardresult"),
('Anthony Adverse',1936,'Oscar, best cinematography','won'::"awardresult"),
('The Garden of Allah',1936,'Oscar, best cinematography','won'::"awardresult"),
('A Midsummer Night''s Dream',1935,'Oscar, best cinematography','won'::"awardresult"),
('Cleopatra',1934,'Oscar, best cinematography','won'::"awardresult"),
('A Farewell to Arms',1932,'Oscar, best cinematography','won'::"awardresult"),
('Shanghai Express',1932,'Oscar, best cinematography','won'::"awardresult"),
('Tabu: A Story of the South Seas',1931,'Oscar, best cinematography','won'::"awardresult"),
('With Byrd at the South Pole',1930,'Oscar, best cinematography','won'::"awardresult"),
('White Shadows in the South Seas',1928,'Oscar, best cinematography','won'::"awardresult"),
('Sunrise: A Song of Two Humans',1927,'Oscar, best cinematography','won'::"awardresult"),
('Gravity',2013,'Oscar, best cinematography','won'::"awardresult"),
('Birdman or (The Unexpected Virtue of Ignorance)',2014,'Oscar, best cinematography','won'::"awardresult"),
('The Revenant',2015,'Oscar, best cinematography','won'::"awardresult"),
('La La Land',2016,'Oscar, best cinematography','won'::"awardresult"),
('Blade Runner 2049',2017,'Oscar, best cinematography','won'::"awardresult"),
('Roma',2018,'Oscar, best cinematography','won'::"awardresult"),
('1917',2019,'Oscar, best cinematography','won'::"awardresult"),
('Mank',2020,'Oscar, best cinematography','won'::"awardresult"),
('Dune: Part One',2021,'Oscar, best cinematography','won'::"awardresult"))i(title,"year",award,"result") 
 WHERE EXISTS(SELECT FROM movies m  
 WHERE (m.title)=(i.title) AND (m.year)=(i.year)  
 FOR SHARE)ON CONFLICT DO NOTHING;
INSERT INTO movieawards(title,"year",award,"result")
SELECT i.*
FROM (VALUES
('Nomadland',2020,'Oscar, best picture','nominated'::"awardresult"),
('The Father',2020,'Oscar, best picture','nominated'::"awardresult"),
('Judas and the Black Messiah',2021,'Oscar, best picture','nominated'::"awardresult"),
('Mank',2020,'Oscar, best picture','nominated'::"awardresult"),
('Minari',2020,'Oscar, best picture','nominated'::"awardresult"),
('Promising Young Woman',2020,'Oscar, best picture','nominated'::"awardresult"),
('Sound of Metal',2019,'Oscar, best picture','nominated'::"awardresult"),
('The Trial of the Chicago 7',2020,'Oscar, best picture','nominated'::"awardresult"),
('Gisaengchung',2019,'Oscar, best picture','nominated'::"awardresult"),
('Ford v Ferrari',2019,'Oscar, best picture','nominated'::"awardresult"),
('Joker',2019,'Oscar, best picture','nominated'::"awardresult"),
('Marriage Story',2019,'Oscar, best picture','nominated'::"awardresult"),
('The Irishman',2019,'Oscar, best picture','nominated'::"awardresult"),
('1917',2019,'Oscar, best picture','nominated'::"awardresult"),
('Jojo Rabbit',2019,'Oscar, best picture','nominated'::"awardresult"),
('Little Women',2019,'Oscar, best picture','nominated'::"awardresult"),
('Once Upon a Time... in Hollywood',2019,'Oscar, best picture','nominated'::"awardresult"),
('Green Book',2018,'Oscar, best picture','nominated'::"awardresult"),
('Black Panther',2018,'Oscar, best picture','nominated'::"awardresult"),
('BlacKkKlansman',2018,'Oscar, best picture','nominated'::"awardresult"),
('Bohemian Rhapsody',2018,'Oscar, best picture','nominated'::"awardresult"),
('The Favourite',2018,'Oscar, best picture','nominated'::"awardresult"),
('Roma',2018,'Oscar, best picture','nominated'::"awardresult"),
('A Star Is Born',2018,'Oscar, best picture','nominated'::"awardresult"),
('Vice',2018,'Oscar, best picture','nominated'::"awardresult"),
('The Shape of Water',2017,'Oscar, best picture','nominated'::"awardresult"),
('Dunkirk',2017,'Oscar, best picture','nominated'::"awardresult"),
('Three Billboards Outside Ebbing, Missouri',2017,'Oscar, best picture','nominated'::"awardresult"),
('Lady Bird',2017,'Oscar, best picture','nominated'::"awardresult"),
('The Post',2017,'Oscar, best picture','nominated'::"awardresult"),
('Get Out',2017,'Oscar, best picture','nominated'::"awardresult"),
('Call Me by Your Name',2017,'Oscar, best picture','nominated'::"awardresult"),
('Darkest Hour',2017,'Oscar, best picture','nominated'::"awardresult"),
('All the Money in the World',2017,'Oscar, best picture','nominated'::"awardresult"),
('Arrival',2016,'Oscar, best picture','nominated'::"awardresult"),
('Fences',2016,'Oscar, best picture','nominated'::"awardresult"),
('Hacksaw Ridge',2016,'Oscar, best picture','nominated'::"awardresult"),
('Hell or High Water',2016,'Oscar, best picture','nominated'::"awardresult"),
('Hidden Figures',2016,'Oscar, best picture','nominated'::"awardresult"),
('La La Land',2016,'Oscar, best picture','nominated'::"awardresult"),
('Lion',2016,'Oscar, best picture','nominated'::"awardresult"),
('Manchester by the Sea',2016,'Oscar, best picture','nominated'::"awardresult"),
('The Big Short',2015,'Oscar, best picture','nominated'::"awardresult"),
('Bridge of Spies',2015,'Oscar, best picture','nominated'::"awardresult"),
('Brooklyn',2015,'Oscar, best picture','nominated'::"awardresult"),
('Mad Max: Fury Road',2015,'Oscar, best picture','nominated'::"awardresult"),
('The Martian',2015,'Oscar, best picture','nominated'::"awardresult"),
('The Revenant',2015,'Oscar, best picture','nominated'::"awardresult"),
('Room',2015,'Oscar, best picture','nominated'::"awardresult"),
('Birdman or (The Unexpected Virtue of Ignorance)',2014,'Oscar, best picture','nominated'::"awardresult"),
('American Sniper',2014,'Oscar, best picture','nominated'::"awardresult"),
('Boyhood',2014,'Oscar, best picture','nominated'::"awardresult"),
('The Imitation Game',2014,'Oscar, best picture','nominated'::"awardresult"),
('The Grand Budapest Hotel',2014,'Oscar, best picture','nominated'::"awardresult"),
('Selma',2014,'Oscar, best picture','nominated'::"awardresult"),
('The Theory of Everything',2014,'Oscar, best picture','nominated'::"awardresult"),
('Whiplash',2014,'Oscar, best picture','nominated'::"awardresult"),
('American Hustle',2013,'Oscar, best picture','nominated'::"awardresult"),
('Captain Phillips',2013,'Oscar, best picture','nominated'::"awardresult"),
('Dallas Buyers Club',2013,'Oscar, best picture','nominated'::"awardresult"),
('Gravity',2013,'Oscar, best picture','nominated'::"awardresult"),
('Her',2013,'Oscar, best picture','nominated'::"awardresult"),
('Nebraska',2013,'Oscar, best picture','nominated'::"awardresult"),
('Philomena',2013,'Oscar, best picture','nominated'::"awardresult"),
('The Wolf of Wall Street',2013,'Oscar, best picture','nominated'::"awardresult"),
('Beasts of the Southern Wild',2012,'Oscar, best picture','nominated'::"awardresult"),
('Zero Dark Thirty',2012,'Oscar, best picture','nominated'::"awardresult"),
('Amour',2012,'Oscar, best picture','nominated'::"awardresult"),
('Silver Linings Playbook',2012,'Oscar, best picture','nominated'::"awardresult"),
('Lincoln',2012,'Oscar, best picture','nominated'::"awardresult"),
('Life of Pi',2012,'Oscar, best picture','nominated'::"awardresult"),
('Les Misérables',2012,'Oscar, best picture','nominated'::"awardresult"),
('Django Unchained',2012,'Oscar, best picture','nominated'::"awardresult"),
('The Artist',2011,'Oscar, best picture','nominated'::"awardresult"),
('The Tree of Life',2011,'Oscar, best picture','nominated'::"awardresult"),
('The Descendants',2011,'Oscar, best picture','nominated'::"awardresult"),
('Extremely Loud & Incredibly Close',2011,'Oscar, best picture','nominated'::"awardresult"),
('The Help',2011,'Oscar, best picture','nominated'::"awardresult"),
('Hugo',2011,'Oscar, best picture','nominated'::"awardresult"),
('Midnight in Paris',2011,'Oscar, best picture','nominated'::"awardresult"),
('Moneyball',2011,'Oscar, best picture','nominated'::"awardresult"),
('War Horse',2011,'Oscar, best picture','nominated'::"awardresult"),
('127 Hours',2010,'Oscar, best picture','nominated'::"awardresult"),
('Black Swan',2010,'Oscar, best picture','nominated'::"awardresult"),
('The Fighter',2010,'Oscar, best picture','nominated'::"awardresult"),
('Inception',2010,'Oscar, best picture','nominated'::"awardresult"),
('The Kids Are All Right',2010,'Oscar, best picture','nominated'::"awardresult"),
('The Social Network',2010,'Oscar, best picture','nominated'::"awardresult"),
('Toy Story 3',2010,'Oscar, best picture','nominated'::"awardresult"),
('True Grit',2010,'Oscar, best picture','nominated'::"awardresult"),
('A Serious Man',2009,'Oscar, best picture','nominated'::"awardresult"),
('An Education',2009,'Oscar, best picture','nominated'::"awardresult"),
('Avatar',2009,'Oscar, best picture','nominated'::"awardresult"),
('District 9',2009,'Oscar, best picture','nominated'::"awardresult"),
('Inglourious Basterds',2009,'Oscar, best picture','nominated'::"awardresult"),
('Precious',2009,'Oscar, best picture','nominated'::"awardresult"),
('The Blind Side',2009,'Oscar, best picture','nominated'::"awardresult"),
('Up',2009,'Oscar, best picture','nominated'::"awardresult"),
('Up in the Air',2009,'Oscar, best picture','nominated'::"awardresult"),
('The Curious Case of Benjamin Button',2008,'Oscar, best picture','nominated'::"awardresult"),
('Frost/Nixon',2008,'Oscar, best picture','nominated'::"awardresult"),
('Milk',2008,'Oscar, best picture','nominated'::"awardresult"),
('The Reader',2008,'Oscar, best picture','nominated'::"awardresult"),
('No Country for Old Men',2007,'Oscar, best picture','nominated'::"awardresult"),
('Atonement',2007,'Oscar, best picture','nominated'::"awardresult"),
('Juno',2007,'Oscar, best picture','nominated'::"awardresult"),
('Michael Clayton',2007,'Oscar, best picture','nominated'::"awardresult"),
('There Will Be Blood',2007,'Oscar, best picture','nominated'::"awardresult"),
('Babel',2006,'Oscar, best picture','nominated'::"awardresult"),
('Letters from Iwo Jima',2006,'Oscar, best picture','nominated'::"awardresult"),
('Little Miss Sunshine',2006,'Oscar, best picture','nominated'::"awardresult"),
('The Queen',2006,'Oscar, best picture','nominated'::"awardresult"),
('Crash',2004,'Oscar, best picture','nominated'::"awardresult"),
('Brokeback Mountain',2005,'Oscar, best picture','nominated'::"awardresult"),
('Capote',2005,'Oscar, best picture','nominated'::"awardresult"),
('Good Night, and Good Luck.',2005,'Oscar, best picture','nominated'::"awardresult"),
('Munich',2005,'Oscar, best picture','nominated'::"awardresult"),
('Million Dollar Baby',2004,'Oscar, best picture','nominated'::"awardresult"),
('The Aviator',2004,'Oscar, best picture','nominated'::"awardresult"),
('Finding Neverland',2004,'Oscar, best picture','nominated'::"awardresult"),
('Ray',2004,'Oscar, best picture','nominated'::"awardresult"),
('Sideways',2004,'Oscar, best picture','nominated'::"awardresult"),
('The Lord of the Rings: The Return of the King',2003,'Oscar, best picture','nominated'::"awardresult"),
('Lost in Translation',2003,'Oscar, best picture','nominated'::"awardresult"),
('Master and Commander: The Far Side of the World',2003,'Oscar, best picture','nominated'::"awardresult"),
('Mystic River',2003,'Oscar, best picture','nominated'::"awardresult"),
('Seabiscuit',2003,'Oscar, best picture','nominated'::"awardresult"),
('Chicago',2002,'Oscar, best picture','nominated'::"awardresult"),
('Gangs of New York',2002,'Oscar, best picture','nominated'::"awardresult"),
('The Hours',2002,'Oscar, best picture','nominated'::"awardresult"),
('The Lord of the Rings: The Two Towers',2002,'Oscar, best picture','nominated'::"awardresult"),
('The Pianist',2002,'Oscar, best picture','nominated'::"awardresult"),
('A Beautiful Mind',2001,'Oscar, best picture','nominated'::"awardresult"),
('Gosford Park',2001,'Oscar, best picture','nominated'::"awardresult"),
('In the Bedroom',2001,'Oscar, best picture','nominated'::"awardresult"),
('The Lord of the Rings: The Fellowship of the Ring',2001,'Oscar, best picture','nominated'::"awardresult"),
('Moulin Rouge!',2001,'Oscar, best picture','nominated'::"awardresult"),
('Gladiator',2000,'Oscar, best picture','nominated'::"awardresult"),
('Chocolat',2000,'Oscar, best picture','nominated'::"awardresult"),
('Wo hu cang long',2000,'Oscar, best picture','nominated'::"awardresult"),
('Erin Brockovich',2000,'Oscar, best picture','nominated'::"awardresult"),
('Traffic',2000,'Oscar, best picture','nominated'::"awardresult"),
('American Beauty',1999,'Oscar, best picture','nominated'::"awardresult"),
('The Cider House Rules',1999,'Oscar, best picture','nominated'::"awardresult"),
('The Green Mile',1999,'Oscar, best picture','nominated'::"awardresult"),
('The Insider',1999,'Oscar, best picture','nominated'::"awardresult"),
('The Sixth Sense',1999,'Oscar, best picture','nominated'::"awardresult"),
('Shakespeare in Love',1998,'Oscar, best picture','nominated'::"awardresult"),
('Elizabeth',1998,'Oscar, best picture','nominated'::"awardresult"),
('La vita è bella',1997,'Oscar, best picture','nominated'::"awardresult"),
('Saving Private Ryan',1998,'Oscar, best picture','nominated'::"awardresult"),
('The Thin Red Line',1998,'Oscar, best picture','nominated'::"awardresult"),
('Titanic',1997,'Oscar, best picture','nominated'::"awardresult"),
('As Good as It Gets',1997,'Oscar, best picture','nominated'::"awardresult"),
('The Full Monty',1997,'Oscar, best picture','nominated'::"awardresult"),
('Good Will Hunting',1997,'Oscar, best picture','nominated'::"awardresult"),
('L.A. Confidential',1997,'Oscar, best picture','nominated'::"awardresult"),
('The English Patient',1996,'Oscar, best picture','nominated'::"awardresult"),
('Fargo',1996,'Oscar, best picture','nominated'::"awardresult"),
('Jerry Maguire',1996,'Oscar, best picture','nominated'::"awardresult"),
('Secrets & Lies',1996,'Oscar, best picture','nominated'::"awardresult"),
('Shine',1996,'Oscar, best picture','nominated'::"awardresult"),
('Braveheart',1995,'Oscar, best picture','nominated'::"awardresult"),
('Apollo 13',1995,'Oscar, best picture','nominated'::"awardresult"),
('Babe',1995,'Oscar, best picture','nominated'::"awardresult"),
('Il postino',1994,'Oscar, best picture','nominated'::"awardresult"),
('Sense and Sensibility',1995,'Oscar, best picture','nominated'::"awardresult"),
('Forrest Gump',1994,'Oscar, best picture','nominated'::"awardresult"),
('Four Weddings and a Funeral',1994,'Oscar, best picture','nominated'::"awardresult"),
('Pulp Fiction',1994,'Oscar, best picture','nominated'::"awardresult"),
('Quiz Show',1994,'Oscar, best picture','nominated'::"awardresult"),
('The Shawshank Redemption',1994,'Oscar, best picture','nominated'::"awardresult"),
('Schindler''s List',1993,'Oscar, best picture','nominated'::"awardresult"),
('The Fugitive',1993,'Oscar, best picture','nominated'::"awardresult"),
('In the Name of the Father',1993,'Oscar, best picture','nominated'::"awardresult"),
('The Piano',1993,'Oscar, best picture','nominated'::"awardresult"),
('The Remains of the Day',1993,'Oscar, best picture','nominated'::"awardresult"),
('Unforgiven',1992,'Oscar, best picture','nominated'::"awardresult"),
('The Crying Game',1992,'Oscar, best picture','nominated'::"awardresult"),
('A Few Good Men',1992,'Oscar, best picture','nominated'::"awardresult"),
('Howards End',1992,'Oscar, best picture','nominated'::"awardresult"),
('Scent of a Woman',1992,'Oscar, best picture','nominated'::"awardresult"),
('The Silence of the Lambs',1991,'Oscar, best picture','nominated'::"awardresult"),
('Beauty and the Beast',1991,'Oscar, best picture','nominated'::"awardresult"),
('Bugsy',1991,'Oscar, best picture','nominated'::"awardresult"),
('JFK',1991,'Oscar, best picture','nominated'::"awardresult"),
('The Prince of Tides',1991,'Oscar, best picture','nominated'::"awardresult"),
('Dances with Wolves',1990,'Oscar, best picture','nominated'::"awardresult"),
('Awakenings',1990,'Oscar, best picture','nominated'::"awardresult"),
('Ghost',1990,'Oscar, best picture','nominated'::"awardresult"),
('The Godfather Part III',1990,'Oscar, best picture','nominated'::"awardresult"),
('Goodfellas',1990,'Oscar, best picture','nominated'::"awardresult"),
('Driving Miss Daisy',1989,'Oscar, best picture','nominated'::"awardresult"),
('Born on the Fourth of July',1989,'Oscar, best picture','nominated'::"awardresult"),
('Dead Poets Society',1989,'Oscar, best picture','nominated'::"awardresult"),
('Field of Dreams',1989,'Oscar, best picture','nominated'::"awardresult"),
('My Left Foot: The Story of Christy Brown',1989,'Oscar, best picture','nominated'::"awardresult"),
('Rain Man',1988,'Oscar, best picture','nominated'::"awardresult"),
('The Accidental Tourist',1988,'Oscar, best picture','nominated'::"awardresult"),
('Dangerous Liaisons',1988,'Oscar, best picture','nominated'::"awardresult"),
('Mississippi Burning',1988,'Oscar, best picture','nominated'::"awardresult"),
('Working Girl',1988,'Oscar, best picture','nominated'::"awardresult"),
('The Last Emperor',1987,'Oscar, best picture','nominated'::"awardresult"),
('Broadcast News',1987,'Oscar, best picture','nominated'::"awardresult"),
('Fatal Attraction',1987,'Oscar, best picture','nominated'::"awardresult"),
('Hope and Glory',1987,'Oscar, best picture','nominated'::"awardresult"),
('Moonstruck',1987,'Oscar, best picture','nominated'::"awardresult"),
('Platoon',1986,'Oscar, best picture','nominated'::"awardresult"),
('Children of a Lesser God',1986,'Oscar, best picture','nominated'::"awardresult"),
('Hannah and Her Sisters',1986,'Oscar, best picture','nominated'::"awardresult"),
('The Mission',1986,'Oscar, best picture','nominated'::"awardresult"),
('A Room with a View',1985,'Oscar, best picture','nominated'::"awardresult"),
('Out of Africa',1985,'Oscar, best picture','nominated'::"awardresult"),
('The Color Purple',1985,'Oscar, best picture','nominated'::"awardresult"),
('Kiss of the Spider Woman',1985,'Oscar, best picture','nominated'::"awardresult"),
('Prizzi''s Honor',1985,'Oscar, best picture','nominated'::"awardresult"),
('Witness',1985,'Oscar, best picture','nominated'::"awardresult"),
('Amadeus',1984,'Oscar, best picture','nominated'::"awardresult"),
('The Killing Fields',1984,'Oscar, best picture','nominated'::"awardresult"),
('A Passage to India',1984,'Oscar, best picture','nominated'::"awardresult"),
('Places in the Heart',1984,'Oscar, best picture','nominated'::"awardresult"),
('A Soldier''s Story',1984,'Oscar, best picture','nominated'::"awardresult"),
('Terms of Endearment',1983,'Oscar, best picture','nominated'::"awardresult"),
('The Big Chill',1983,'Oscar, best picture','nominated'::"awardresult"),
('The Dresser',1983,'Oscar, best picture','nominated'::"awardresult"),
('The Right Stuff',1983,'Oscar, best picture','nominated'::"awardresult"),
('Tender Mercies',1983,'Oscar, best picture','nominated'::"awardresult"),
('Gandhi',1982,'Oscar, best picture','nominated'::"awardresult"),
('E.T. the Extra-Terrestrial',1982,'Oscar, best picture','nominated'::"awardresult"),
('Missing',1982,'Oscar, best picture','nominated'::"awardresult"),
('Tootsie',1982,'Oscar, best picture','nominated'::"awardresult"),
('The Verdict',1982,'Oscar, best picture','nominated'::"awardresult"),
('Chariots of Fire',1981,'Oscar, best picture','nominated'::"awardresult"),
('Atlantic City',1980,'Oscar, best picture','nominated'::"awardresult"),
('On Golden Pond',1981,'Oscar, best picture','nominated'::"awardresult"),
('Raiders of the Lost Ark',1981,'Oscar, best picture','nominated'::"awardresult"),
('Reds',1981,'Oscar, best picture','nominated'::"awardresult"),
('Ordinary People',1980,'Oscar, best picture','nominated'::"awardresult"),
('Coal Miner''s Daughter',1980,'Oscar, best picture','nominated'::"awardresult"),
('The Elephant Man',1980,'Oscar, best picture','nominated'::"awardresult"),
('Raging Bull',1980,'Oscar, best picture','nominated'::"awardresult"),
('Tess',1979,'Oscar, best picture','nominated'::"awardresult"),
('Kramer vs. Kramer',1979,'Oscar, best picture','nominated'::"awardresult"),
('All That Jazz',1979,'Oscar, best picture','nominated'::"awardresult"),
('Apocalypse Now',1979,'Oscar, best picture','nominated'::"awardresult"),
('Breaking Away',1979,'Oscar, best picture','nominated'::"awardresult"),
('Norma Rae',1979,'Oscar, best picture','nominated'::"awardresult"),
('The Deer Hunter',1978,'Oscar, best picture','nominated'::"awardresult"),
('Coming Home',1978,'Oscar, best picture','nominated'::"awardresult"),
('Heaven Can Wait',1978,'Oscar, best picture','nominated'::"awardresult"),
('Midnight Express',1978,'Oscar, best picture','nominated'::"awardresult"),
('An Unmarried Woman',1978,'Oscar, best picture','nominated'::"awardresult"),
('Annie Hall',1977,'Oscar, best picture','nominated'::"awardresult"),
('The Goodbye Girl',1977,'Oscar, best picture','nominated'::"awardresult"),
('Julia',1977,'Oscar, best picture','nominated'::"awardresult"),
('Star Wars',1977,'Oscar, best picture','nominated'::"awardresult"),
('The Turning Point',1977,'Oscar, best picture','nominated'::"awardresult"),
('Rocky',1976,'Oscar, best picture','nominated'::"awardresult"),
('All the President''s Men',1976,'Oscar, best picture','nominated'::"awardresult"),
('Bound for Glory',1976,'Oscar, best picture','nominated'::"awardresult"),
('Network',1976,'Oscar, best picture','nominated'::"awardresult"),
('Taxi Driver',1976,'Oscar, best picture','nominated'::"awardresult"),
('One Flew Over the Cuckoo''s Nest',1975,'Oscar, best picture','nominated'::"awardresult"),
('Barry Lyndon',1975,'Oscar, best picture','nominated'::"awardresult"),
('Dog Day Afternoon',1975,'Oscar, best picture','nominated'::"awardresult"),
('Jaws',1975,'Oscar, best picture','nominated'::"awardresult"),
('Nashville',1975,'Oscar, best picture','nominated'::"awardresult"),
('The Godfather Part II',1974,'Oscar, best picture','nominated'::"awardresult"),
('Chinatown',1974,'Oscar, best picture','nominated'::"awardresult"),
('The Conversation',1974,'Oscar, best picture','nominated'::"awardresult"),
('Lenny',1974,'Oscar, best picture','nominated'::"awardresult"),
('The Towering Inferno',1974,'Oscar, best picture','nominated'::"awardresult"),
('The Sting',1973,'Oscar, best picture','nominated'::"awardresult"),
('American Graffiti',1973,'Oscar, best picture','nominated'::"awardresult"),
('Viskningar och rop',1972,'Oscar, best picture','nominated'::"awardresult"),
('The Exorcist',1973,'Oscar, best picture','nominated'::"awardresult"),
('A Touch of Class',1973,'Oscar, best picture','nominated'::"awardresult"),
('The Godfather',1972,'Oscar, best picture','nominated'::"awardresult"),
('Cabaret',1972,'Oscar, best picture','nominated'::"awardresult"),
('Deliverance',1972,'Oscar, best picture','nominated'::"awardresult"),
('Utvandrarna',1971,'Oscar, best picture','nominated'::"awardresult"),
('Sounder',1972,'Oscar, best picture','nominated'::"awardresult"),
('The French Connection',1971,'Oscar, best picture','nominated'::"awardresult"),
('A Clockwork Orange',1971,'Oscar, best picture','nominated'::"awardresult"),
('Fiddler on the Roof',1971,'Oscar, best picture','nominated'::"awardresult"),
('The Last Picture Show',1971,'Oscar, best picture','nominated'::"awardresult"),
('Nicholas and Alexandra',1971,'Oscar, best picture','nominated'::"awardresult"),
('Patton',1970,'Oscar, best picture','nominated'::"awardresult"),
('Airport',1970,'Oscar, best picture','nominated'::"awardresult"),
('Five Easy Pieces',1970,'Oscar, best picture','nominated'::"awardresult"),
('Love Story',1970,'Oscar, best picture','nominated'::"awardresult"),
('M*A*S*H',1970,'Oscar, best picture','nominated'::"awardresult"),
('Midnight Cowboy',1969,'Oscar, best picture','nominated'::"awardresult"),
('Anne of the Thousand Days',1969,'Oscar, best picture','nominated'::"awardresult"),
('Butch Cassidy and the Sundance Kid',1969,'Oscar, best picture','nominated'::"awardresult"),
('Hello, Dolly!',1969,'Oscar, best picture','nominated'::"awardresult"),
('Z',1969,'Oscar, best picture','nominated'::"awardresult"),
('Oliver!',1968,'Oscar, best picture','nominated'::"awardresult"),
('Funny Girl',1968,'Oscar, best picture','nominated'::"awardresult"),
('The Lion in Winter',1968,'Oscar, best picture','nominated'::"awardresult"),
('Rachel, Rachel',1968,'Oscar, best picture','nominated'::"awardresult"),
('Romeo and Juliet',1968,'Oscar, best picture','nominated'::"awardresult"),
('In the Heat of the Night',1967,'Oscar, best picture','nominated'::"awardresult"),
('Bonnie and Clyde',1967,'Oscar, best picture','nominated'::"awardresult"),
('Doctor Dolittle',1967,'Oscar, best picture','nominated'::"awardresult"),
('The Graduate',1967,'Oscar, best picture','nominated'::"awardresult"),
('Guess Who''s Coming to Dinner',1967,'Oscar, best picture','nominated'::"awardresult"),
('A Man for All Seasons',1966,'Oscar, best picture','nominated'::"awardresult"),
('Alfie',1966,'Oscar, best picture','nominated'::"awardresult"),
('The Russians Are Coming the Russians Are Coming',1966,'Oscar, best picture','nominated'::"awardresult"),
('The Sand Pebbles',1966,'Oscar, best picture','nominated'::"awardresult"),
('Who''s Afraid of Virginia Woolf?',1966,'Oscar, best picture','nominated'::"awardresult"),
('The Sound of Music',1965,'Oscar, best picture','nominated'::"awardresult"),
('Darling',1965,'Oscar, best picture','nominated'::"awardresult"),
('Doctor Zhivago',1965,'Oscar, best picture','nominated'::"awardresult"),
('Ship of Fools',1965,'Oscar, best picture','nominated'::"awardresult"),
('A Thousand Clowns',1965,'Oscar, best picture','nominated'::"awardresult"),
('My Fair Lady',1964,'Oscar, best picture','nominated'::"awardresult"),
('Becket',1964,'Oscar, best picture','nominated'::"awardresult"),
('Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb',1964,'Oscar, best picture','nominated'::"awardresult"),
('Mary Poppins',1964,'Oscar, best picture','nominated'::"awardresult"),
('Alexis Zorbas',1964,'Oscar, best picture','nominated'::"awardresult"),
('Tom Jones',1963,'Oscar, best picture','nominated'::"awardresult"),
('America America',1963,'Oscar, best picture','nominated'::"awardresult"),
('Cleopatra',1963,'Oscar, best picture','nominated'::"awardresult"),
('How the West Was Won',1962,'Oscar, best picture','nominated'::"awardresult"),
('Lilies of the Field',1963,'Oscar, best picture','nominated'::"awardresult"),
('Lawrence of Arabia',1962,'Oscar, best picture','nominated'::"awardresult"),
('The Longest Day',1962,'Oscar, best picture','nominated'::"awardresult"),
('The Music Man',1962,'Oscar, best picture','nominated'::"awardresult"),
('Mutiny on the Bounty',1962,'Oscar, best picture','nominated'::"awardresult"),
('To Kill a Mockingbird',1962,'Oscar, best picture','nominated'::"awardresult"),
('West Side Story',1961,'Oscar, best picture','nominated'::"awardresult"),
('Fanny',1961,'Oscar, best picture','nominated'::"awardresult"),
('The Guns of Navarone',1961,'Oscar, best picture','nominated'::"awardresult"),
('The Hustler',1961,'Oscar, best picture','nominated'::"awardresult"),
('Judgment at Nuremberg',1961,'Oscar, best picture','nominated'::"awardresult"),
('The Apartment',1960,'Oscar, best picture','nominated'::"awardresult"),
('The Alamo',1960,'Oscar, best picture','nominated'::"awardresult"),
('Elmer Gantry',1960,'Oscar, best picture','nominated'::"awardresult"),
('Sons and Lovers',1960,'Oscar, best picture','nominated'::"awardresult"),
('The Sundowners',1960,'Oscar, best picture','nominated'::"awardresult"),
('Ben-Hur',1959,'Oscar, best picture','nominated'::"awardresult"),
('Anatomy of a Murder',1959,'Oscar, best picture','nominated'::"awardresult"),
('The Diary of Anne Frank',1959,'Oscar, best picture','nominated'::"awardresult"),
('The Nun''s Story',1959,'Oscar, best picture','nominated'::"awardresult"),
('Room at the Top',1958,'Oscar, best picture','nominated'::"awardresult"),
('Gigi',1958,'Oscar, best picture','nominated'::"awardresult"),
('Auntie Mame',1958,'Oscar, best picture','nominated'::"awardresult"),
('Cat on a Hot Tin Roof',1958,'Oscar, best picture','nominated'::"awardresult"),
('The Defiant Ones',1958,'Oscar, best picture','nominated'::"awardresult"),
('Separate Tables',1958,'Oscar, best picture','nominated'::"awardresult"),
('The Bridge on the River Kwai',1957,'Oscar, best picture','nominated'::"awardresult"),
('Peyton Place',1957,'Oscar, best picture','nominated'::"awardresult"),
('Sayonara',1957,'Oscar, best picture','nominated'::"awardresult"),
('12 Angry Men',1957,'Oscar, best picture','nominated'::"awardresult"),
('Witness for the Prosecution',1957,'Oscar, best picture','nominated'::"awardresult"),
('Around the World in 80 Days',1956,'Oscar, best picture','nominated'::"awardresult"),
('Friendly Persuasion',1956,'Oscar, best picture','nominated'::"awardresult"),
('Giant',1956,'Oscar, best picture','nominated'::"awardresult"),
('The King and I',1956,'Oscar, best picture','nominated'::"awardresult"),
('The Ten Commandments',1956,'Oscar, best picture','nominated'::"awardresult"),
('Marty',1955,'Oscar, best picture','nominated'::"awardresult"),
('Love Is a Many-Splendored Thing',1955,'Oscar, best picture','nominated'::"awardresult"),
('Mister Roberts',1955,'Oscar, best picture','nominated'::"awardresult"),
('Picnic',1955,'Oscar, best picture','nominated'::"awardresult"),
('The Rose Tattoo',1955,'Oscar, best picture','nominated'::"awardresult"),
('On the Waterfront',1954,'Oscar, best picture','nominated'::"awardresult"),
('The Caine Mutiny',1954,'Oscar, best picture','nominated'::"awardresult"),
('The Country Girl',1954,'Oscar, best picture','nominated'::"awardresult"),
('Seven Brides for Seven Brothers',1954,'Oscar, best picture','nominated'::"awardresult"),
('Three Coins in the Fountain',1954,'Oscar, best picture','nominated'::"awardresult"),
('From Here to Eternity',1953,'Oscar, best picture','nominated'::"awardresult"),
('Julius Caesar',1953,'Oscar, best picture','nominated'::"awardresult"),
('The Robe',1953,'Oscar, best picture','nominated'::"awardresult"),
('Roman Holiday',1953,'Oscar, best picture','nominated'::"awardresult"),
('Shane',1953,'Oscar, best picture','nominated'::"awardresult"),
('The Greatest Show on Earth',1952,'Oscar, best picture','nominated'::"awardresult"),
('High Noon',1952,'Oscar, best picture','nominated'::"awardresult"),
('Ivanhoe',1952,'Oscar, best picture','nominated'::"awardresult"),
('Moulin Rouge',1952,'Oscar, best picture','nominated'::"awardresult"),
('The Quiet Man',1952,'Oscar, best picture','nominated'::"awardresult"),
('An American in Paris',1951,'Oscar, best picture','nominated'::"awardresult"),
('Decision Before Dawn',1951,'Oscar, best picture','nominated'::"awardresult"),
('A Place in the Sun',1951,'Oscar, best picture','nominated'::"awardresult"),
('Quo Vadis',1951,'Oscar, best picture','nominated'::"awardresult"),
('A Streetcar Named Desire',1951,'Oscar, best picture','nominated'::"awardresult"),
('All About Eve',1950,'Oscar, best picture','nominated'::"awardresult"),
('Born Yesterday',1950,'Oscar, best picture','nominated'::"awardresult"),
('Father of the Bride',1950,'Oscar, best picture','nominated'::"awardresult"),
('King Solomon''s Mines',1950,'Oscar, best picture','nominated'::"awardresult"),
('Sunset Blvd.',1950,'Oscar, best picture','nominated'::"awardresult"),
('All the King''s Men',1949,'Oscar, best picture','nominated'::"awardresult"),
('Battleground',1949,'Oscar, best picture','nominated'::"awardresult"),
('The Heiress',1949,'Oscar, best picture','nominated'::"awardresult"),
('A Letter to Three Wives',1949,'Oscar, best picture','nominated'::"awardresult"),
('Twelve O''Clock High',1949,'Oscar, best picture','nominated'::"awardresult"),
('Hamlet',1948,'Oscar, best picture','nominated'::"awardresult"),
('Johnny Belinda',1948,'Oscar, best picture','nominated'::"awardresult"),
('The Red Shoes',1948,'Oscar, best picture','nominated'::"awardresult"),
('The Snake Pit',1948,'Oscar, best picture','nominated'::"awardresult"),
('The Treasure of the Sierra Madre',1948,'Oscar, best picture','nominated'::"awardresult"),
('Gentleman''s Agreement',1947,'Oscar, best picture','nominated'::"awardresult"),
('The Bishop''s Wife',1947,'Oscar, best picture','nominated'::"awardresult"),
('Crossfire',1947,'Oscar, best picture','nominated'::"awardresult"),
('Great Expectations',1946,'Oscar, best picture','nominated'::"awardresult"),
('Miracle on 34th Street',1947,'Oscar, best picture','nominated'::"awardresult"),
('The Best Years of Our Lives',1946,'Oscar, best picture','nominated'::"awardresult"),
('The Chronicle History of King Henry the Fifth with His Battell Fought at Agincourt in France',1944,'Oscar, best picture','nominated'::"awardresult"),
('It''s a Wonderful Life',1946,'Oscar, best picture','nominated'::"awardresult"),
('The Razor''s Edge',1946,'Oscar, best picture','nominated'::"awardresult"),
('The Yearling',1946,'Oscar, best picture','nominated'::"awardresult"),
('The Lost Weekend',1945,'Oscar, best picture','nominated'::"awardresult"),
('Anchors Aweigh',1945,'Oscar, best picture','nominated'::"awardresult"),
('The Bells of St. Mary''s',1945,'Oscar, best picture','nominated'::"awardresult"),
('Mildred Pierce',1945,'Oscar, best picture','nominated'::"awardresult"),
('Spellbound',1945,'Oscar, best picture','nominated'::"awardresult"),
('Going My Way',1944,'Oscar, best picture','nominated'::"awardresult"),
('Double Indemnity',1944,'Oscar, best picture','nominated'::"awardresult"),
('Gaslight',1944,'Oscar, best picture','nominated'::"awardresult"),
('Since You Went Away',1944,'Oscar, best picture','nominated'::"awardresult"),
('Wilson',1944,'Oscar, best picture','nominated'::"awardresult"),
('Casablanca',1942,'Oscar, best picture','nominated'::"awardresult"),
('For Whom the Bell Tolls',1943,'Oscar, best picture','nominated'::"awardresult"),
('Heaven Can Wait',1943,'Oscar, best picture','nominated'::"awardresult"),
('The Human Comedy',1943,'Oscar, best picture','nominated'::"awardresult"),
('In Which We Serve',1942,'Oscar, best picture','nominated'::"awardresult"),
('Madame Curie',1943,'Oscar, best picture','nominated'::"awardresult"),
('The More the Merrier',1943,'Oscar, best picture','nominated'::"awardresult"),
('The Ox-Bow Incident',1942,'Oscar, best picture','nominated'::"awardresult"),
('The Song of Bernadette',1943,'Oscar, best picture','nominated'::"awardresult"),
('Watch on the Rhine',1943,'Oscar, best picture','nominated'::"awardresult"),
('Mrs. Miniver',1942,'Oscar, best picture','nominated'::"awardresult"),
('49th Parallel',1941,'Oscar, best picture','nominated'::"awardresult"),
('Kings Row',1942,'Oscar, best picture','nominated'::"awardresult"),
('The Magnificent Ambersons',1942,'Oscar, best picture','nominated'::"awardresult"),
('The Pied Piper',1942,'Oscar, best picture','nominated'::"awardresult"),
('The Pride of the Yankees',1942,'Oscar, best picture','nominated'::"awardresult"),
('Random Harvest',1942,'Oscar, best picture','nominated'::"awardresult"),
('The Talk of the Town',1942,'Oscar, best picture','nominated'::"awardresult"),
('Wake Island',1942,'Oscar, best picture','nominated'::"awardresult"),
('Yankee Doodle Dandy',1942,'Oscar, best picture','nominated'::"awardresult"),
('How Green Was My Valley',1941,'Oscar, best picture','nominated'::"awardresult"),
('Blossoms in the Dust',1941,'Oscar, best picture','nominated'::"awardresult"),
('Citizen Kane',1941,'Oscar, best picture','nominated'::"awardresult"),
('Here Comes Mr. Jordan',1941,'Oscar, best picture','nominated'::"awardresult"),
('Hold Back the Dawn',1941,'Oscar, best picture','nominated'::"awardresult"),
('The Little Foxes',1941,'Oscar, best picture','nominated'::"awardresult"),
('The Maltese Falcon',1941,'Oscar, best picture','nominated'::"awardresult"),
('One Foot in Heaven',1941,'Oscar, best picture','nominated'::"awardresult"),
('Sergeant York',1941,'Oscar, best picture','nominated'::"awardresult"),
('Suspicion',1941,'Oscar, best picture','nominated'::"awardresult"),
('Rebecca',1940,'Oscar, best picture','nominated'::"awardresult"),
('All This, and Heaven Too',1940,'Oscar, best picture','nominated'::"awardresult"),
('Foreign Correspondent',1940,'Oscar, best picture','nominated'::"awardresult"),
('The Grapes of Wrath',1940,'Oscar, best picture','nominated'::"awardresult"),
('The Great Dictator',1940,'Oscar, best picture','nominated'::"awardresult"),
('Kitty Foyle',1940,'Oscar, best picture','nominated'::"awardresult"),
('The Letter',1940,'Oscar, best picture','nominated'::"awardresult"),
('The Long Voyage Home',1940,'Oscar, best picture','nominated'::"awardresult"),
('Our Town',1940,'Oscar, best picture','nominated'::"awardresult"),
('The Philadelphia Story',1940,'Oscar, best picture','nominated'::"awardresult"),
('Gone with the Wind',1939,'Oscar, best picture','nominated'::"awardresult"),
('Dark Victory',1939,'Oscar, best picture','nominated'::"awardresult"),
('Goodbye, Mr. Chips',1939,'Oscar, best picture','nominated'::"awardresult"),
('Love Affair',1939,'Oscar, best picture','nominated'::"awardresult"),
('Mr. Smith Goes to Washington',1939,'Oscar, best picture','nominated'::"awardresult"),
('Ninotchka',1939,'Oscar, best picture','nominated'::"awardresult"),
('Of Mice and Men',1939,'Oscar, best picture','nominated'::"awardresult"),
('Stagecoach',1939,'Oscar, best picture','nominated'::"awardresult"),
('The Wizard of Oz',1939,'Oscar, best picture','nominated'::"awardresult"),
('Wuthering Heights',1939,'Oscar, best picture','nominated'::"awardresult"))i(title,"year",award,"result") 
 WHERE EXISTS(SELECT FROM movies m  
 WHERE (m.title)=(i.title) AND (m.year)=(i.year)  
 FOR SHARE)ON CONFLICT DO NOTHING;
INSERT INTO movieawards(title,"year",award,"result")
SELECT i.*
FROM (VALUES
('Nomadland',2020,'Oscar, best picture','won'::"awardresult"),
('Gisaengchung',2019,'Oscar, best picture','won'::"awardresult"),
('Green Book',2018,'Oscar, best picture','won'::"awardresult"),
('The Shape of Water',2017,'Oscar, best picture','won'::"awardresult"),
('Moonlight',2016,'Oscar, best picture','won'::"awardresult"),
('Spotlight',2015,'Oscar, best picture','won'::"awardresult"),
('Birdman or (The Unexpected Virtue of Ignorance)',2014,'Oscar, best picture','won'::"awardresult"),
('12 Years a Slave',2013,'Oscar, best picture','won'::"awardresult"),
('Argo',2012,'Oscar, best picture','won'::"awardresult"),
('The Artist',2011,'Oscar, best picture','won'::"awardresult"),
('The King''s Speech',2010,'Oscar, best picture','won'::"awardresult"),
('The Hurt Locker',2008,'Oscar, best picture','won'::"awardresult"),
('Slumdog Millionaire',2008,'Oscar, best picture','won'::"awardresult"),
('No Country for Old Men',2007,'Oscar, best picture','won'::"awardresult"),
('The Departed',2006,'Oscar, best picture','won'::"awardresult"),
('Crash',2004,'Oscar, best picture','won'::"awardresult"),
('Million Dollar Baby',2004,'Oscar, best picture','won'::"awardresult"),
('The Lord of the Rings: The Return of the King',2003,'Oscar, best picture','won'::"awardresult"),
('Chicago',2002,'Oscar, best picture','won'::"awardresult"),
('A Beautiful Mind',2001,'Oscar, best picture','won'::"awardresult"),
('Gladiator',2000,'Oscar, best picture','won'::"awardresult"),
('American Beauty',1999,'Oscar, best picture','won'::"awardresult"),
('Shakespeare in Love',1998,'Oscar, best picture','won'::"awardresult"),
('Titanic',1997,'Oscar, best picture','won'::"awardresult"),
('The English Patient',1996,'Oscar, best picture','won'::"awardresult"),
('Braveheart',1995,'Oscar, best picture','won'::"awardresult"),
('Forrest Gump',1994,'Oscar, best picture','won'::"awardresult"),
('Schindler''s List',1993,'Oscar, best picture','won'::"awardresult"),
('Unforgiven',1992,'Oscar, best picture','won'::"awardresult"),
('The Silence of the Lambs',1991,'Oscar, best picture','won'::"awardresult"),
('Dances with Wolves',1990,'Oscar, best picture','won'::"awardresult"),
('Driving Miss Daisy',1989,'Oscar, best picture','won'::"awardresult"),
('Rain Man',1988,'Oscar, best picture','won'::"awardresult"),
('The Last Emperor',1987,'Oscar, best picture','won'::"awardresult"),
('Platoon',1986,'Oscar, best picture','won'::"awardresult"),
('Out of Africa',1985,'Oscar, best picture','won'::"awardresult"),
('Amadeus',1984,'Oscar, best picture','won'::"awardresult"),
('Terms of Endearment',1983,'Oscar, best picture','won'::"awardresult"),
('Gandhi',1982,'Oscar, best picture','won'::"awardresult"),
('Chariots of Fire',1981,'Oscar, best picture','won'::"awardresult"),
('Ordinary People',1980,'Oscar, best picture','won'::"awardresult"),
('Kramer vs. Kramer',1979,'Oscar, best picture','won'::"awardresult"),
('The Deer Hunter',1978,'Oscar, best picture','won'::"awardresult"),
('Annie Hall',1977,'Oscar, best picture','won'::"awardresult"),
('Rocky',1976,'Oscar, best picture','won'::"awardresult"),
('One Flew Over the Cuckoo''s Nest',1975,'Oscar, best picture','won'::"awardresult"),
('The Godfather Part II',1974,'Oscar, best picture','won'::"awardresult"),
('The Sting',1973,'Oscar, best picture','won'::"awardresult"),
('The Godfather',1972,'Oscar, best picture','won'::"awardresult"),
('The French Connection',1971,'Oscar, best picture','won'::"awardresult"),
('Patton',1970,'Oscar, best picture','won'::"awardresult"),
('Midnight Cowboy',1969,'Oscar, best picture','won'::"awardresult"),
('Oliver!',1968,'Oscar, best picture','won'::"awardresult"),
('In the Heat of the Night',1967,'Oscar, best picture','won'::"awardresult"),
('A Man for All Seasons',1966,'Oscar, best picture','won'::"awardresult"),
('The Sound of Music',1965,'Oscar, best picture','won'::"awardresult"),
('My Fair Lady',1964,'Oscar, best picture','won'::"awardresult"),
('Tom Jones',1963,'Oscar, best picture','won'::"awardresult"),
('Lawrence of Arabia',1962,'Oscar, best picture','won'::"awardresult"),
('West Side Story',1961,'Oscar, best picture','won'::"awardresult"),
('The Apartment',1960,'Oscar, best picture','won'::"awardresult"),
('Ben-Hur',1959,'Oscar, best picture','won'::"awardresult"),
('Gigi',1958,'Oscar, best picture','won'::"awardresult"),
('The Bridge on the River Kwai',1957,'Oscar, best picture','won'::"awardresult"),
('Around the World in 80 Days',1956,'Oscar, best picture','won'::"awardresult"),
('Marty',1955,'Oscar, best picture','won'::"awardresult"),
('On the Waterfront',1954,'Oscar, best picture','won'::"awardresult"),
('From Here to Eternity',1953,'Oscar, best picture','won'::"awardresult"),
('The Greatest Show on Earth',1952,'Oscar, best picture','won'::"awardresult"),
('An American in Paris',1951,'Oscar, best picture','won'::"awardresult"),
('All About Eve',1950,'Oscar, best picture','won'::"awardresult"),
('All the King''s Men',1949,'Oscar, best picture','won'::"awardresult"),
('Hamlet',1948,'Oscar, best picture','won'::"awardresult"),
('Gentleman''s Agreement',1947,'Oscar, best picture','won'::"awardresult"),
('The Best Years of Our Lives',1946,'Oscar, best picture','won'::"awardresult"),
('The Lost Weekend',1945,'Oscar, best picture','won'::"awardresult"),
('Going My Way',1944,'Oscar, best picture','won'::"awardresult"),
('Casablanca',1942,'Oscar, best picture','won'::"awardresult"),
('Mrs. Miniver',1942,'Oscar, best picture','won'::"awardresult"),
('How Green Was My Valley',1941,'Oscar, best picture','won'::"awardresult"),
('Rebecca',1940,'Oscar, best picture','won'::"awardresult"),
('Gone with the Wind',1939,'Oscar, best picture','won'::"awardresult"),
('You Can''t Take It with You',1938,'Oscar, best picture','won'::"awardresult"),
('The Life of Emile Zola',1937,'Oscar, best picture','won'::"awardresult"),
('The Great Ziegfeld',1936,'Oscar, best picture','won'::"awardresult"),
('Mutiny on the Bounty',1935,'Oscar, best picture','won'::"awardresult"),
('It Happened One Night',1934,'Oscar, best picture','won'::"awardresult"),
('Cavalcade',1933,'Oscar, best picture','won'::"awardresult"),
('Grand Hotel',1932,'Oscar, best picture','won'::"awardresult"),
('Cimarron',1931,'Oscar, best picture','won'::"awardresult"),
('All Quiet on the Western Front',1930,'Oscar, best picture','won'::"awardresult"),
('The Broadway Melody',1929,'Oscar, best picture','won'::"awardresult"),
('Wings',1927,'Oscar, best picture','won'::"awardresult"))i(title,"year",award,"result") 
 WHERE EXISTS(SELECT FROM movies m  
 WHERE (m.title)=(i.title) AND (m.year)=(i.year)  
 FOR SHARE)ON CONFLICT DO NOTHING;
 UPDATE Movies set budget=(budget / 100);