CREATE DATABASE tomatoes;

\c tomatoes

CREATE TABLE IF NOT EXISTS actors (
  id serial,
  lastname varchar(25) NOT NULL,
  firstname varchar(25) NOT NULL,
  role varchar(50) NOT NULL,
  movie varchar(50) NOT NULL,
  trating int,
  runtime int,
  year int,
  PRIMARY KEY (id)
)  ;


INSERT INTO actors (lastname, firstname, role, movie, year, trating, runtime) VALUES
( 'Firth', 'Colin', 'George', 'King''s Speech', 2010, 95, 118),
( 'Downey', 'Robert', 'Tony Stark', 'Iron Man 2', 2010, 74, 124),
( 'Paltrow', 'Gwyneth', 'Pepper Potts', 'Iron Man 2', 2010, 74, 124),
( 'Mara', 'Kate', 'U.S. Marshall', 'Iron Man 2', 2010, 74, 124),
( 'Jackson', 'Samuel', 'Nick Fury', 'Iron Man 2', 2010, 74, 124),
( 'Downey', 'Robert', 'Tony Stark', 'Avengers', 2012, 92, 142),
( 'Jackson', 'Samuel', 'Nick Fury', 'Avengers', 2012, 92, 142),
( 'Fiennes', 'Ralph', 'John Steed', 'The Avengers', 1998, 5, 90),
( 'Downey', 'Robert', 'Tony Stark', 'Avengers: Age of Ultron', 2015, 75, 141),
( 'Jackson', 'Samuel', 'Nick Fury', 'Avengers: Age of Ultron', 2015, 75, 141),
( 'Evans', 'Chris', 'Steve Rogers/Captain America', 'Captain America: The First Avenger', 2011, 80, 124),
( 'Coleman', 'Jenna-Louise', 'Connie', 'Captain America: The First Avenger', 2011, 80, 124),
( 'Jackson', 'Samuel', 'Nick Fury', 'Captain America: The First Avenger', 2011, 80, 124),
( 'Dormer', 'Natalie', 'Pvt. Lorraine', 'Captain America: The First Avenger', 2011, 80, 124),
( 'Atwell', 'Hayley', 'Peggy Carter', 'Captain America: The First Avenger', 2011, 80, 124),
( 'Evans', 'Chris', 'Steve Rogers/Captain America', 'Avengers: Age of Ultron', 2015, 75, 141),
( 'Johansson', 'Scarlet', 'Black Widow', 'Avengers: Age of Ultron', 2015, 75, 141),
( 'Olsen', 'Elizabeth', 'Scarlet Witch', 'Avengers: Age of Ultron', 2015, 75, 141),
( 'Thurman', 'Ulma', 'Emma Peel', 'The Avengers', 1998, 5, 90),
( 'Connery', 'Sean', 'Sir August de Wynter', 'The Avengers', 1998, 5, 90),
( 'Jolie', 'Angelina', 'Evelyn Salt', 'Salt', 2010, 63, 100),
( 'Jolie', 'Angelina', 'Elise Clifton Ward', 'The Tourist', 2010, 20,103),
( 'Jolie', 'Angelina', 'Tigress', 'Kung Fu Panda', 2008, 87, 88),
( 'Liu', 'Lucy', 'Viper', 'Kung Fu Panda', 2008, 87, 88),
( 'Black', 'Jack', 'Po', 'Kung Fu Panda', 2008, 87, 88),
( 'Black', 'Jack', 'Jerry', 'Be Kind Rewind', 2008, 65, 101),
( 'Jolie', 'Angelina', 'Franky Cook', 'Sky Captain and the World of Tomorrow', 2004, 71, 107),
( 'Black', 'Jack', 'Jeff', 'Year of the Dog', 2007, 69, 96),
( 'Depp', 'Johnny', 'Frank Tupelo', 'The Tourist', 2010, 20, 103),
( 'Depp', 'Johnny', 'Jack Sparrow', 'Pirates of the Caribbean', 2003, 79, 143),
( 'Knightley', 'Keira', 'Elizabeth Swann', 'Pirates of the Caribbean', 2003, 79, 143),
( 'Page', 'Ellen', 'Ariadne', 'Inception', 2010, 87, 148),
( 'Page', 'Ellen', 'Juno MacGuff', 'Juno', 2007, 94, 96),
( 'DiCaprio', 'Leonardo', 'Cobb', 'Inception', 2010, 87, 148),
( 'DiCaprio', 'Leonardo', 'Frank Abagnate, Jr', 'Catch Me If You Can', 2002, 95, 140),
( 'DiCarprio', 'Leonardo', 'Billy Costigan', 'The Departed', 2006, 91, 152),
( 'Watanabe', 'Ken', 'Saito', 'Inception', 2010, 87, 148),
( 'Watanabe', 'Ken', 'Ra''s Al Ghul', 'Batman Begins', 2005, 84, 140),
( 'Bale', 'Christian', 'Bruce Wayne/Batman', 'Batman Begins', 2005, 84, 140),
( 'Holmes', 'Katie', 'Rachel Dawes', 'Batman Begins', 2005, 84, 140),
( 'Paltrow', 'Gwyneth', 'Polly Perkins', 'Sky Captain and the World of Tomorrow', 2004, 71, 107),
( 'Johansson', 'Scarlet', 'Black Widow', 'Iron Man 2', 2010, 74, 124),
( 'Johansson', 'Scarlet', 'Black Widow', 'Avengers', 2012, 97, 142),
( 'Johansson', 'Scarlet', 'Mindy the Mermaid', 'Spongebob Squarepants Movie', 2004, 69, 90),
( 'Paltrow', 'Gwyneth', 'Security Guard', 'Inception', 2010, 87, 148),
( 'Pelaez', 'Angelina', 'Sister Anna', 'Man on Fire', 2004, 39, 146),
( 'Washington', 'Denzel', 'John Creasy', 'Man on Fire', 2004, 39, 146),
( 'Fanning', 'Dakota', 'Pita Ramos', 'Man on Fire', 2004, 39, 146),
( 'Pelaez', 'Angelina', 'Donna Mercedes', 'Casa de los Babys', 2003, 58, 95),
( 'Jolie', 'Samantha', 'Amber Autumn', 'Hysterical Blindness', 2002, 73, 93),
( 'Black', 'Shane', 'director', 'Kiss, Kiss, Bang Bang', 2005, 85, 102),
( 'Downey', 'Robert', 'Harry Lockhart', 'Kiss, Kiss, Bang Bang', 2005, 85, 102),
( 'Back', 'Lucas', 'Oakley', 'Cold Mountain', 2003, 71, 154),
( 'Kidman', 'Nicole', 'Ada Monroe', 'Cold Mountain', 2003, 71, 154),
( 'Zellweger', 'Renée', 'Ruby Thewes', 'Cold Mountain', 2003, 71, 154),
( 'Portman', 'Natalie', 'Sara', 'Cold Mountain', 2003, 71, 154),
( 'Black', 'Karen', 'Mother Firefly', 'House of 1000 Corpses', 2002, 19, 88),
( 'Black', 'Karen', 'Luna', 'Hollywood Dreams', 2006, 36, 101),
( 'Page', 'Bruce', 'Jimmy''s Father', 'Mystic River', 2003, 88, 137),
( 'Downey', 'Roma', 'herself', 'Miracles and Visions', 1996, NULL, 62),
( 'Cruz', 'Penelope', 'Angelica', 'Pirates of the Caribbean On Stranger Tides', 2011, 33, 137),
( 'Holmes', 'Katie', 'Tommy', 'Peaceful Warrior', 2006, 25, 121),
( 'Nolte', 'Nick', 'Socrates', 'Peaceful Warrior', 2006, 25, 121),
( 'Paltrow', 'Gwyneth', 'Pepper Potts', 'Avengers', 2012, 97, 142),
( 'Hoffman', 'Dustin', 'Master Shifu', 'Kung Fu Panda', 2008, 87, 88),
( 'Jolie', 'Angelina', 'Acid Burn', 'Hackers', 1995, 33, 104),
( 'Mori', 'Naoko', 'Tokyo Hacker', 'Hackers', 1995, 33, 104),
( 'Miller', 'Jonny Lee', 'Dade', 'Hackers', 1995, 33, 104),
( 'Miller', 'Jonny Lee', 'Michael Young', 'Endgame', 2009, 79, 109),
( 'Bale', 'Christian', 'Bruce Wayne/Batman', 'Dark Knight Rises', 2012, 87, 165),
( 'Hathaway', 'Anne', 'Selina', 'Dark Knight Rises', 2012, 87, 165),
( 'Damon', 'Matt', 'Mitch Emhoff', 'Contagion', 2011, 84, 107),
( 'Paltrow', 'Gwyneth', 'Beth Emhoff', 'Contagion', 2011, 84, 107),
( 'Paltrow', 'Gwyneth', 'Virginia "Pepper" Potts', 'Iron Man', 2008, 93, 83),
( 'Downey', 'Robert', 'Tony Stark', 'Iron Man', 2008, 93, 83),
( 'Bridges', 'Jess', 'Obadiah Stane', 'Iron Man', 2008, 93, 83),
( 'Stuart', 'Katie', 'Kitty Pryde', 'X2: X-Men United', 2003, 85, 134),
( 'Stewart', 'Patrick', 'Professor Xavier', 'X2: X-Men United', 2003, 85, 134),
( 'Larson', 'Brie', 'Carol Danvers/Captain Marvel', 'Captain Marvel', 2019, 78, 128 ),
( 'Jackson', 'Samuel', 'Nick Fury', 'Captain Marvel', 2019, 78, 128),
( 'Bening', 'Annette', 'Supreme Intelligence', 'Captain Marvel', 2019, 78, 128),
( 'Mendelsohn', 'Ben', 'Talos', 'Captain Marvel', 2019, 78, 128),
( 'Larson', 'Brie', 'Kit', 'Unicorn Store', 2019, 64, 92),
( 'Jackson', 'Samuel', 'Salesman', 'Unicorn Store', 2019, 64, 92),
( 'Jackman', 'Hugh', 'Wolverine', 'X-Men: Days of Future Past', 2014, 90, 131),
( 'Lawrence', 'Jennifer', 'Mystique', 'X-Men: Days of Future Past', 2014, 90, 131),
( 'Stewart', 'Patrick', 'Professor X', 'X-Men: Days of Future Past', 2014, 90, 131),
( 'Page', 'Ellen', 'Kitty Pryde', 'X-Men: Days of Future Past', 2014, 90, 131),
( 'Hathaway', 'Anne', 'Gloria', 'Colossal', 2017, 81, 110),
( 'Sudeikis', 'Jason', 'Oscar', 'Colossal', 2017, 81, 110),
( 'Page', 'Ellen', 'Lucy', 'My Days of Mercy', 2019, 100, 103),
( 'Mara', 'Kate', 'Mercy', 'My Days of Mercy', 2019, 100, 103),
( 'Koteas', 'Elias', 'Simon', 'My Days of Mercy', 2019, 100, 103),
( 'Larson', 'Brie', 'Carol Danvers/Captain Marvel', 'Avengers: Endgame', 2019, 94, 182),
( 'Downey', 'Robert', 'Iron Man', 'Avengers: Endgame', 2019, 94, 182),
( 'Ruffalo', 'Mark', 'Hulk', 'Avengers: Endgame', 2019, 94, 182),
( 'Johansson', 'Scarlet', 'Black Widow', 'Avengers: Endgame', 2019, 94, 182),
( 'Olson', 'Elizabeth', 'Scarlet Witch', 'Avengers: Endgame', 2019, 94, 182),
( 'Saldana', 'Zoe', 'Gamora', 'Avengers: Endgame', 2019, 94, 182),
( 'Saldana', 'Zoe', 'Neytiri', 'Avatar', 2009, 82, 162),
( 'Worthington', 'Sam', 'Jake Sully', 'Avatar', 2009, 82, 162),
( 'Cumberbatch', 'Benedict', 'Stephen Vincent Strange', 'Doctor Strange', 2016, 89, 130),
( 'Swanton', 'Tilda', 'Ancient One', 'Doctor Strange', 2016, 89, 130),
( 'McAdams', 'Rachel', 'Christine Palmer', 'Doctor Strange', 2016, 89, 130),
( 'Johnson', 'Bryce', 'Doctor Stephen Stange', 'Doctor Strange', 2007, NULL, 76),
( 'Yama', 'Michael', 'Ancient One', 'Doctor Strange', 2007, NULL, 76),
( 'Strong', 'Tara', 'April Stange', 'Doctor Strange', 2007, NULL, 76),
( 'Gadot', 'Gal', 'Diana/Wonder Woman', 'Wonder Woman', 2017, 98, 141),
( 'Pine', 'Chris', 'Steve Trever', 'Wonder Woman', 2017, 98, 141),
( 'Nielsen', 'Connie', 'Hippolyta', 'Wonder Woman', 2017, 98, 141),
( 'Gadot', 'Gal', 'Diana/Wonder Woman', 'Wonder Woman 1984', 2020, NULL, NULL),
( 'Pine', 'Chris', 'Steve Trever', 'Wonder Woman 1984', 2020, NULL, NULL),
( 'Wiig', 'Kristen', 'Barbara Minerva/Cheetah', 'Wonder Woman 1984', 2020, NULL, NULL),
( 'Gadot', 'Gal', 'Shank', 'Ralph Breaks the Internet', 2019, 88, 114),
( 'Silverman', 'Sarah', 'Vanellope von Schweetz', 'Ralph Breaks the Internet', 2019, 88, 114),
( 'Lynch', 'Jane', 'Calhoun', 'Ralph Breaks the Internet', 2019, 88, 114),
( 'Reilly', 'John', 'Ralph', 'Ralph Breaks the Internet', 2019, 88, 114),
( 'Gadot', 'Gal', 'Diana/Wonder Woman', 'Justice League Part Two', NULL, NULL, NULL),
( 'Manganiello', 'Joe', 'Slade Wilson / Deathstroke', 'Justice League Part Two', NULL, NULL, NULL),
( 'Wolff', 'Susan', 'Rike', 'Styx', 2019, 94, 94),
( 'Russell', 'Keri', 'Wonder Woman', 'Wonder Woman', 2009, 82, 93),
( 'Fillion', 'Nathan', 'Col. Steve Trevor', 'Wonder Woman', 2009, 82, 93),
( 'Dawson', 'Rosario', 'Artemis', 'Wonder Woman', 2009, 82, 93),
( 'Madsen', 'Virginia', 'Hippolyta', 'Wonder Woman', 2009, 82, 93),
( 'Holt', 'Charlene', 'Hippolyta', 'Wonder Woman', 1974, NULL, 75),
( 'Crosby', 'Cathy Lee', 'Wonder Woman', 'Wonder Woman', 1974, NULL, 75),
( 'Garas', 'Kaz', 'Steve Trever', 'Wonder Woman', 1974, NULL, 75),
( 'Portman', 'Natalie', 'Lena', 'Annihilation', 2018, 88, NULL),
( 'Jason Leigh', 'Jennifer', 'Dr. Ventress', 'Annihilation', 2018, 88, NULL),
( 'Rodriguez', 'Gina', 'Anya Thorensen', 'Annihilation', 2018, 88, NULL),
( 'Portman', 'Natalie', 'Jane Foster', 'Thor', 2011, 77, 115),
( 'Hemsworth', 'Chris', 'Thor', 'Thor', 2011, 77, 115),
( 'Alexander', 'Jaimie', 'Sif', 'Thor', 2011, 77, 115),
( 'Hathaway', 'Anne', 'Agent 99', 'Get Smart', 2008, 50, 110),
( 'Carell', 'Steve', 'Maxwell Smart', 'Get Smart', 2008, 50, 110),
( 'Stewart', 'Kristen', 'Sabina Wilson', 'Charlies Angels', 2019, NULL, NULL),
( 'Scott', 'Naomi', 'Elena Houghlin', 'Charlies Angels', 2019, NULL, NULL),
( 'Stewart', 'Patrick', 'Bosley', 'Charlies Angels', 2019, NULL, NULL),
( 'Balinska', 'Ella', 'Jane Kano', 'Charlies Angels', 2019, NULL, NULL),
( 'Scott', 'Naomi', 'Ryoko', 'The Martian', 2015, 91, 164),
( 'Damon', 'Matt', 'Mark Watney', 'The Martian', 2015, 91, 164),
( 'Chastain', 'Jessica', 'Melissa Lewis', 'The Martian', 2015, 91, 164),
( 'Wiig', 'Kristen', 'Annie Montrose', 'The Martian', 2015, 91, 164),
( 'Mara', 'Kate', 'Beth Johanssen', 'The Martian', 2015, 91, 164), 
( 'Lawrence', 'Jennifer', 'Mystique', 'Dark Phoenix', 2019, 23, NULL),
( 'McAvoy', 'James', 'Professor Charles Xavier', 'Dark Phoenix', 2019, 23, NULL),
( 'Chastain', 'Jessica', 'Smith', 'Dark Phoenix', 2019, 23, NULL),
( 'Boseman', 'Chadwick', 'T''Challa/Black Panther', 'Black Panther', 2018, 97,135),
( 'Nyong''o', 'Lupita', 'Nakia', 'Black Panther', 2018, 97,135),
( 'Gurira', 'Danai', 'Okoye', 'Black Panther', 2018, 97,135),
( 'Evans', 'Chris', 'Steve Rogers/Captain America',  'Captain America: Civil War', 2016, 91, 146),
( 'Downey', 'Tony', 'Tony Stark/Iron Man',     'Captain America: Civil War', 2016, 91, 146),
( 'Johansson', 'Scarlet', 'Natasha Romanoff/Black Widow',     'Captain America: Civil War', 2016, 91, 146)
;