Class clipboard: Movie Data

drop table movie; drop table character; drop table actor; create table actor( actor_id int generated always as identity start with 100 primary key, name varchar(50), birth_date date, birth_place varchar (100) ); create table character( character_id int generated always as identity start with 200 primary key, name varchar(50) ); create table movie( movie_id int generated always as identity start with 300 primary key, name varchar(50), director_name varchar(50), year number(4,0) ); insert into movie (name, director_name, year) values('Adaptation','Spike Jonze',2002); insert into movie (name, director_name, year) values('Clear and Present Danger','Phillip Noyce',1994); insert into movie (name, director_name, year) values('Face Off','John Woo',1997); insert into movie (name, director_name, year) values('It''s a Wonderful Life','Frank Capra',1947); insert into movie (name, director_name, year) values('Star Wars','George Lucas',1977); insert into movie (name, director_name, year) values('The Hunt for Red October','John McTiernan',1990); insert into movie (name, director_name, year) values('The Empire Strikes Back','Irvin Kershner',1980); insert into movie (name, director_name, year) values('The Nutty Professor','Tom Shadyac',1996); insert into movie (name, director_name, year) values('The Nutty Professor','Jerry Lewis',1963); insert into movie (name, director_name, year) values('Sleuth','Joseph L. Mankiewicz',1972); insert into movie (name, director_name, year) values('Sleuth','Kenneth Branagh',2007); insert into movie (name, director_name, year) values(' Mr. Smith Goes to Washington','Frank Capra',1939); insert into movie (name, director_name, year) values('Solo: A Stgar Wars Story','Ron Howard',2018); insert into character (name) values('John Laroche'); insert into character (name) values('Orlean''s Husband'); insert into character (name) values('Augustus Margary'); insert into character (name) values('Buster Baxley'); insert into character (name) values('Prosecutor'); insert into character (name) values('Ranger Tony'); insert into character (name) values('Susan Orlean'); insert into character (name) values('Charlie Kaufman'); insert into character (name) values('Donald Kaufman'); insert into character (name) values('Defense Attorney'); insert into character (name) values('Ranger Steve Neely'); insert into character (name) values('Valerie Thomas'); insert into character (name) values('Moira Wolfson'); insert into character (name) values('Cathy Muller Ryan'); insert into character (name) values('Captain Ramirez'); insert into character (name) values('Judge Moore'); insert into character (name) values('President Bennett'); insert into character (name) values('James Cutter'); insert into character (name) values('Jack Ryan'); insert into character (name) values('Robert Ritter'); insert into character (name) values('Senator Mayo'); insert into character (name) values('Col. Felix Cortez'); insert into character (name) values('Ernesto Escobedo'); insert into character (name) values('Domingo Chavez'); insert into character (name) values('Sally Ryan'); insert into character (name) values('FBI Director Emile Jacobs'); insert into character (name) values('John Clark'); insert into character (name) values('Pollux Troy'); insert into character (name) values('Hollis Miller'); insert into character (name) values('Dr. Malcolm Walsh'); insert into character (name) values('Jamie Archer'); insert into character (name) values('Sasha Hassler'); insert into character (name) values('Victor Lazarro'); insert into character (name) values('Buzz (as Jamie Denton)'); insert into character (name) values('Dr. Eve Archer'); insert into character (name) values('Prison Guard Walton'); insert into character (name) values('Sean Archer'); insert into character (name) values('Castor Troy'); insert into character (name) values('Wanda'); insert into character (name) values('Loomis'); insert into character (name) values('Dietrich Hassler'); insert into character (name) values('Tito Biondi'); insert into character (name) values('Mrs. Bailey'); insert into character (name) values('Mary Hatch'); insert into character (name) values('Sam Wainwright'); insert into character (name) values('Ernie'); insert into character (name) values('Harry Bailey'); insert into character (name) values('Violet'); insert into character (name) values('Mr. Gower'); insert into character (name) values('Clarence'); insert into character (name) values('George Bailey'); insert into character (name) values('Mr. Potter'); insert into character (name) values('Jean Gale'); insert into character (name) values('Cousin Tilly'); insert into character (name) values('Pa Bailey'); insert into character (name) values('Uncle Billy'); insert into character (name) values('Ruth Dakin'); insert into character (name) values('Bert'); insert into character (name) values('Ben Obi-Wan Kenobi'); insert into character (name) values('C-3PO'); insert into character (name) values('Princess Leia Organa'); insert into character (name) values('Darth Vader'); insert into character (name) values('Han Solo'); insert into character (name) values('R2-D2'); insert into character (name) values('Luke Skywalker'); insert into character (name) values('Grand Moff Tarkin'); insert into character (name) values('Chewbacca'); insert into character (name) values('Seaman Jones'); insert into character (name) values('Admiral Painter'); insert into character (name) values('Admiral Greer'); insert into character (name) values('Skip Tyler'); insert into character (name) values('Andrei Lysenko'); insert into character (name) values('Ivan Putin'); insert into character (name) values('Jeffrey Pelt'); insert into character (name) values('Captain Borodin'); insert into character (name) values('Bart Mancuso'); insert into character (name) values('Marko Ramius'); insert into character (name) values('Captain Tupolev'); insert into character (name) values('Dr. Petrov'); insert into character (name) values('Bill Steiner'); insert into character (name) values('Princess Leia'); insert into character (name) values('Lando Calrissian'); insert into character (name) values('Sherman Klump'); insert into character (name) values('Buddy Love'); insert into character (name) values('Lance Perkins'); insert into character (name) values('Papa Klump'); insert into character (name) values('Mama Klump'); insert into character (name) values('Grandma Klump'); insert into character (name) values('Ernie Klump'); insert into character (name) values('Carla Purty'); insert into character (name) values('Harlan Hartley'); insert into character (name) values('Dean Richmond'); insert into character (name) values('Reggie Warrington'); insert into character (name) values('Prof. Julius Kelp'); insert into character (name) values('Stella Purdy'); insert into character (name) values('Dr. Mortimer S. Warfield'); insert into character (name) values('Millie Lemmon'); insert into character (name) values('Andrew Wyke'); insert into character (name) values('Milo Tindle'); insert into character (name) values('Man on T.V.'); insert into character (name) values('Saunders'); insert into character (name) values('Jefferson Smith'); insert into character (name) values('Senator Joseph Paine'); insert into character (name) values('Jim Taylor'); insert into character (name) values('Governor Hopper'); insert into character (name) values('Diz Moore'); insert into character (name) values('Beckett'); insert into character (name) values('Qi''ra'); insert into character (name) values('Val'); insert into character (name) values('L3-37'); insert into character (name) values('Dryden Vos'); insert into actor (name, birth_date, birth_place) values('Edward Arnold',to_date('2/18/1890','MM/DD/YYYY'),'New York City, New York, USA'); insert into actor (name, birth_date, birth_place) values('Edward Arnold',to_date('2/18/1890','MM/DD/YYYY'),'New York City, New York, USA'); insert into actor (name, birth_date, birth_place) values('Guy Kibbee',to_date('3/6/1886','MM/DD/YYYY'),'El Paso, Texas, USA'); insert into actor (name, birth_date, birth_place) values('Phoebe Waller-Bridge',to_date('7/14/1985','MM/DD/YYYY'),'London, England, UK'); insert into actor (name, birth_date, birth_place) values('Alden Ehrenreich',to_date('11/22/1989','MM/DD/YYYY'),'Los Angeles, California, USA'); insert into actor (name, birth_date, birth_place) values('Alec Baldwin',to_date('4/3/1958','MM/DD/YYYY'),'Massapequa, Long Island, New York, USA'); insert into actor (name, birth_date, birth_place) values('Alec Guinness',to_date('4/2/1914','MM/DD/YYYY'),'Marylebone, London, England, UK'); insert into actor (name, birth_date, birth_place) values('Alessandro Nivola',to_date('6/28/1972','MM/DD/YYYY'),'Boston, Massachusetts, USA'); insert into actor (name, birth_date, birth_place) values('Ann Magnuson',to_date('1/4/1956','MM/DD/YYYY'),'Charleston, West Virginia, USA'); insert into actor (name, birth_date, birth_place) values('Anne Archer',to_date('8/24/1947','MM/DD/YYYY'),'Los Angeles, California, USA'); insert into actor (name, birth_date, birth_place) values('Anthony Daniels',to_date('2/21/1946','MM/DD/YYYY'),'Salisbury, Wiltshire, England, UK'); insert into actor (name, birth_date, birth_place) values('Benjamin Bratt',to_date('12/16/1963','MM/DD/YYYY'),'San Francisco, California, USA'); insert into actor (name, birth_date, birth_place) values('Beulah Bondi',to_date('5/3/1889','MM/DD/YYYY'),'Chicago, Illinois, USA'); insert into actor (name, birth_date, birth_place) values('Billy Dee Williams',to_date('4/6/1937','MM/DD/YYYY'),'New York City, New York, USA'); insert into actor (name, birth_date, birth_place) values('Carrie Fisher',to_date('10/21/1956','MM/DD/YYYY'),'Beverly Hills, Los Angeles, California, USA'); insert into actor (name, birth_date, birth_place) values('CCH Pounder',to_date('12/25/1952','MM/DD/YYYY'),'Georgetown, British Guiana'); insert into actor (name, birth_date, birth_place) values('Chris Cooper',to_date('7/9/1951','MM/DD/YYYY'),'Kansas City, Missouri, USA'); insert into actor (name, birth_date, birth_place) values('Claude Rains',to_date('11/10/1889','MM/DD/YYYY'),'Clapham, London, England, UK'); insert into actor (name, birth_date, birth_place) values('Colm Feore',to_date('8/22/1958','MM/DD/YYYY'),'Boston, Massachusetts, USA'); insert into actor (name, birth_date, birth_place) values('Courtney B. Vance',to_date('3/12/1960','MM/DD/YYYY'),'Detroit, Michigan, USA'); insert into actor (name, birth_date, birth_place) values('Curtis Hanson',to_date('3/24/1945','MM/DD/YYYY'),'Reno, Nevada, USA'); insert into actor (name, birth_date, birth_place) values('Dave Chappelle',to_date('8/24/1973','MM/DD/YYYY'),'Washington, District of Columbia, USA'); insert into actor (name, birth_date, birth_place) values('David Prowse',to_date('7/1/1935','MM/DD/YYYY'),'Bristol, England, UK'); insert into actor (name, birth_date, birth_place) values('Dean Jones',to_date('1/25/1931','MM/DD/YYYY'),'Decatur, Alabama, USA'); insert into actor (name, birth_date, birth_place) values('Del Moore',to_date('5/14/1970','MM/DD/YYYY'),'Los Angeles, California, USA'); insert into actor (name, birth_date, birth_place) values('Dominique Swain',to_date('8/12/1980','MM/DD/YYYY'),'Malibu, California, USA'); insert into actor (name, birth_date, birth_place) values('Donald Glover',to_date('9/25/1983','MM/DD/YYYY'),'Edwards Air Force Base, California, USA'); insert into actor (name, birth_date, birth_place) values('Donald Moffat',to_date('12/26/1930','MM/DD/YYYY'),'Plymouth, Devon, England, UK'); insert into actor (name, birth_date, birth_place) values('Donna Reed',to_date('1/27/1921','MM/DD/YYYY'),'Denison, Iowa, USA'); insert into actor (name, birth_date, birth_place) values('Doug Jones',to_date('5/24/1960','MM/DD/YYYY'),'Indianapolis, Indiana, USA'); insert into actor (name, birth_date, birth_place) values('Eddie Murphy',to_date('4/3/1961','MM/DD/YYYY'),' Brooklyn, New York, USA'); insert into actor (name, birth_date, birth_place) values('Emilia Clarke',to_date('10/23/1986','MM/DD/YYYY'),'London, England, UK'); insert into actor (name, birth_date, birth_place) values('Frank Albertson',to_date('2/2/2009','MM/DD/YYYY'),'Fergus Falls, Minnesota, USA'); insert into actor (name, birth_date, birth_place) values('Frank Faylen',to_date('12/8/2005','MM/DD/YYYY'),'St. Louis, Missouri, USA'); insert into actor (name, birth_date, birth_place) values('Fred Dalton Thompson',to_date('8/19/1942','MM/DD/YYYY'),'Sheffield, Alabama, USA'); insert into actor (name, birth_date, birth_place) values('Gary Farmer',to_date('6/12/1953','MM/DD/YYYY'),'Ohsweken, Ontario, Canada'); insert into actor (name, birth_date, birth_place) values('Georgie Nokes',to_date('10/22/1936','MM/DD/YYYY'),'Los Angeles County, California, USA'); insert into actor (name, birth_date, birth_place) values('Gina Gershon',to_date('6/10/1962','MM/DD/YYYY'),'Los Angeles, California, USA'); insert into actor (name, birth_date, birth_place) values('Gloria Grahame',to_date('11/28/1923','MM/DD/YYYY'),'Los Angeles, California, USA'); insert into actor (name, birth_date, birth_place) values('Gregory Itzin',to_date('4/20/1948','MM/DD/YYYY'),'Washington, District of Columbia, USA'); insert into actor (name, birth_date, birth_place) values('H.B. Warner',to_date('10/26/1875','MM/DD/YYYY'),'London, England, UK'); insert into actor (name, birth_date, birth_place) values('Harold Pinter',to_date('10/10/1930','MM/DD/YYYY'),'Hackney, London, England, UK'); insert into actor (name, birth_date, birth_place) values('Harris Yulin',to_date('11/5/1937','MM/DD/YYYY'),'Los Angeles, California, USA'); insert into actor (name, birth_date, birth_place) values('Harrison Ford',to_date('7/13/1942','MM/DD/YYYY'),'Chicago, Illinois, USA'); insert into actor (name, birth_date, birth_place) values('Harve Presnell',to_date('9/14/1933','MM/DD/YYYY'),'Modesto, California, USA'); insert into actor (name, birth_date, birth_place) values('Henry Czerny',to_date('2/8/1959','MM/DD/YYYY'),'Toronto, Ontario, Canada'); insert into actor (name, birth_date, birth_place) values('Henry Travers',to_date('3/5/1874','MM/DD/YYYY'),'Berwick-Upon-Tweed, Northumberland, England, UK'); insert into actor (name, birth_date, birth_place) values('Hope Lange',to_date('11/28/1933','MM/DD/YYYY'),'Redding Ridge, Connecticut, USA'); insert into actor (name, birth_date, birth_place) values('Jada Pinkett Smith',to_date('9/18/1971','MM/DD/YYYY'),'Baltimore, Maryland, USA'); insert into actor (name, birth_date, birth_place) values('James Coburn',to_date('8/31/1928','MM/DD/YYYY'),'Laurel, Nebraska, USA'); insert into actor (name, birth_date, birth_place) values('James Denton',to_date('1/20/1963','MM/DD/YYYY'),'Nashville, Tennessee, USA'); insert into actor (name, birth_date, birth_place) values('James Earl Jones',to_date('1/17/1931','MM/DD/YYYY'),'Arkabutla, Mississippi, USA'); insert into actor (name, birth_date, birth_place) values('James Stewart',to_date('5/20/2008','MM/DD/YYYY'),'Indiana, Pennsylvania, USA'); insert into actor (name, birth_date, birth_place) values('Jean Arthur',to_date('10/17/2000','MM/DD/YYYY'),'Plattsburgh, New York, USA'); insert into actor (name, birth_date, birth_place) values('Jeanine Ann Roose',to_date('10/24/1937','MM/DD/YYYY'),'California, USA'); insert into actor (name, birth_date, birth_place) values('Jeffrey Jones',to_date('9/28/1946','MM/DD/YYYY'),'Buffalo, New York, USA'); insert into actor (name, birth_date, birth_place) values('Jerry Lewis',to_date('3/16/1926','MM/DD/YYYY'),'Newark, New Jersey, USA'); insert into actor (name, birth_date, birth_place) values('Jim Beaver',to_date('8/12/1950','MM/DD/YYYY'),'Laramie, Wyoming, USA'); insert into actor (name, birth_date, birth_place) values('Joan Allen',to_date('8/20/1956','MM/DD/YYYY'),'Rochelle, Illinois, USA'); insert into actor (name, birth_date, birth_place) values('Joaquim de Almeida',to_date('3/15/1957','MM/DD/YYYY'),'São Sebastião da Pedreira, Lisbon, Portugal'); insert into actor (name, birth_date, birth_place) values('John Carroll Lynch',to_date('8/1/1963','MM/DD/YYYY'),'Boulder, Colorado, USA'); insert into actor (name, birth_date, birth_place) values('John Travolta',to_date('2/18/1954','MM/DD/YYYY'),'Englewood, New Jersey, USA'); insert into actor (name, birth_date, birth_place) values('Joonas Suotamo',to_date('10/3/1986','MM/DD/YYYY'),'Espoo, Finland'); insert into actor (name, birth_date, birth_place) values('Joss Ackland',to_date('2/29/1928','MM/DD/YYYY'),'North Kensington, London, England, UK'); insert into actor (name, birth_date, birth_place) values('Jude Law',to_date('12/29/1972','MM/DD/YYYY'),'Lewisham, London, England, UK'); insert into actor (name, birth_date, birth_place) values('Kathleen Freeman',to_date('2/17/1919','MM/DD/YYYY'),'Chicago, Illinois, USA'); insert into actor (name, birth_date, birth_place) values('Kenny Baker',to_date('8/24/1934','MM/DD/YYYY'),'Birmingham, England, UK'); insert into actor (name, birth_date, birth_place) values('Larry Miller',to_date('10/15/1953','MM/DD/YYYY'),'Long Island, New York, USA'); insert into actor (name, birth_date, birth_place) values('Laurence Olivier',to_date('5/22/2007','MM/DD/YYYY'),'Dorking, Surrey, England, UK'); insert into actor (name, birth_date, birth_place) values('Lionel Barrymore',to_date('4/28/1878','MM/DD/YYYY'),'Philadelphia, Pennsylvania, USA'); insert into actor (name, birth_date, birth_place) values('Margaret Cho',to_date('12/5/1968','MM/DD/YYYY'),'San Francisco, California, USA'); insert into actor (name, birth_date, birth_place) values('Mark Hamill',to_date('9/25/1951','MM/DD/YYYY'),'Concord, California, USA'); insert into actor (name, birth_date, birth_place) values('Mary Hatch',to_date('6/6/1929','MM/DD/YYYY'),'Haines City, Florida, USA'); insert into actor (name, birth_date, birth_place) values('Mary Treen',to_date('3/27/2007','MM/DD/YYYY'),'St. Louis, Missouri, USA'); insert into actor (name, birth_date, birth_place) values('Matt Ross',to_date('1/3/1970','MM/DD/YYYY'),'Greenwich, Connecticut, USA'); insert into actor (name, birth_date, birth_place) values('Meryl Streep',to_date('6/22/1949','MM/DD/YYYY'),'Summit, New Jersey, USA'); insert into actor (name, birth_date, birth_place) values('Michael Caine',to_date('3/14/1933','MM/DD/YYYY'),'Rotherhithe, London, England, UK'); insert into actor (name, birth_date, birth_place) values('Miguel Sandoval',to_date('11/16/1951','MM/DD/YYYY'),'Washington, District of Columbia, USA'); insert into actor (name, birth_date, birth_place) values('Nick Cassavetes',to_date('5/21/1959','MM/DD/YYYY'),'New York City, New York, USA'); insert into actor (name, birth_date, birth_place) values('Nicolas Cage',to_date('1/7/1964','MM/DD/YYYY'),'Long Beach, California, USA'); insert into actor (name, birth_date, birth_place) values('Paul Bettany',to_date('5/27/1971','MM/DD/YYYY'),'Harlesden, London, England, UK'); insert into actor (name, birth_date, birth_place) values('Peter Cushing',to_date('5/26/1913','MM/DD/YYYY'),'Kenley, Surrey, England, UK'); insert into actor (name, birth_date, birth_place) values('Peter Firth',to_date('10/27/1953','MM/DD/YYYY'),'Bradford, Yorkshire, England, UK'); insert into actor (name, birth_date, birth_place) values('Peter Jason',to_date('7/22/1944','MM/DD/YYYY'),'Hollywood, California, USA'); insert into actor (name, birth_date, birth_place) values('Peter Mayhew',to_date('5/19/1944','MM/DD/YYYY'),'Barnes, London, England, UK'); insert into actor (name, birth_date, birth_place) values('Raymond Cruz',to_date('7/9/1961','MM/DD/YYYY'),'Los Angeles, California, USA'); insert into actor (name, birth_date, birth_place) values('Richard Jordan',to_date('7/19/1937','MM/DD/YYYY'),'New York City, New York, USA'); insert into actor (name, birth_date, birth_place) values('Robert J. Anderson',to_date('3/6/1933','MM/DD/YYYY'),'Hollywood, California, USA'); insert into actor (name, birth_date, birth_place) values('Robert Wisdom',to_date('9/14/1953','MM/DD/YYYY'),'Washington, District of Columbia, USA'); insert into actor (name, birth_date, birth_place) values('Ronnie Ralph',to_date('9/23/1933','MM/DD/YYYY'),'Los Angeles, California, USA'); insert into actor (name, birth_date, birth_place) values('Sam Neill',to_date('9/14/1947','MM/DD/YYYY'),'Omagh, Co. Tyrone, Northern Ireland, UK'); insert into actor (name, birth_date, birth_place) values('Samuel S. Hinds',to_date('4/4/1875','MM/DD/YYYY'),'Brooklyn, New York, USA'); insert into actor (name, birth_date, birth_place) values('Scott Glenn',to_date('1/26/1941','MM/DD/YYYY'),'Pittsburgh, Pennsylvania, USA'); insert into actor (name, birth_date, birth_place) values('Sean Connery',to_date('8/25/1930','MM/DD/YYYY'),'Edinburgh, Scotland, UK'); insert into actor (name, birth_date, birth_place) values('Stella Stevens',to_date('10/1/1938','MM/DD/YYYY'),'Yazoo City, Mississippi, USA'); insert into actor (name, birth_date, birth_place) values('Stellan Skarsgård',to_date('6/13/1951','MM/DD/YYYY'),'Gothenburg, Västra Götalands län, Sweden'); insert into actor (name, birth_date, birth_place) values('Stephen Tobolowsky',to_date('5/30/1951','MM/DD/YYYY'),'Dallas, Texas, USA'); insert into actor (name, birth_date, birth_place) values('Thandie Newton',to_date('11/6/1972','MM/DD/YYYY'),'Westminster, London, England, UK'); insert into actor (name, birth_date, birth_place) values('Thomas Mitchell',to_date('7/11/1892','MM/DD/YYYY'),'Elizabeth, New Jersey, USA'); insert into actor (name, birth_date, birth_place) values('Thomas Mitchell',to_date('7/44/1892','MM/DD/YYYY'),'Elizabeth, New Jersey, USA'); insert into actor (name, birth_date, birth_place) values('Thora Birch',to_date('3/11/1982','MM/DD/YYYY'),'Los Angeles, California, USA'); insert into actor (name, birth_date, birth_place) values('Tilda Swinton',to_date('11/5/1960','MM/DD/YYYY'),'Westminster, London, England, UK'); insert into actor (name, birth_date, birth_place) values('Tim Curry',to_date('4/19/1946','MM/DD/YYYY'),'Grappenhall, Cheshire, England, UK'); insert into actor (name, birth_date, birth_place) values('Timothy Carhart',to_date('12/24/1953','MM/DD/YYYY'),'Washington, District of Columbia, USA'); insert into actor (name, birth_date, birth_place) values('Todd Karns',to_date('1/15/1921','MM/DD/YYYY'),'Hollywood, California, USA'); insert into actor (name, birth_date, birth_place) values('Tom Tammi',to_date('9/2/1945','MM/DD/YYYY'),'Finland'); insert into actor (name, birth_date, birth_place) values('Virginia Patton',to_date('6/25/1926','MM/DD/YYYY'),'Portland, Oregon, USA'); insert into actor (name, birth_date, birth_place) values('Ward Bond',to_date('4/9/2003','MM/DD/YYYY'),'Benkelman, Nebraska, USA'); insert into actor (name, birth_date, birth_place) values('Willem Dafoe',to_date('7/22/1955','MM/DD/YYYY'),'Appleton, Wisconsin, USA'); insert into actor (name, birth_date, birth_place) values('Woody Harrelson',to_date('7/23/1961','MM/DD/YYYY'),'Midland, Texas, USA');