Sample PostgresSQL

sample-postgresql.sql

DROP TABLE IF EXISTS movies;
DROP TABLE IF EXISTS movies;

CREATE TABLE movies (
    id INTEGER PRIMARY KEY,
    title TEXT,
    director TEXT,
    year INTEGER, 
    length_minutes INTEGER
);

insert into movies (id, title, director, year, length_minutes) values (1, 'Carson City', 'Steffane Weaving', 1993, 57);
insert into movies (id, title, director, year, length_minutes) values (2, 'Vampire Apocalypse', 'Rowney Agastina', 2010, 27);
insert into movies (id, title, director, year, length_minutes) values (3, 'Ill Gotten Gains', 'Lesley Thaxter', 1988, 102);
insert into movies (id, title, director, year, length_minutes) values (4, 'Local Color', 'Merilyn Brydell', 1959, 19);
insert into movies (id, title, director, year, length_minutes) values (5, 'Afstiros katallilo', 'Bronnie Gillbanks', 1994, 91);
insert into movies (id, title, director, year, length_minutes) values (6, 'Mongol', 'Glynn Claeskens', 2004, 79);
insert into movies (id, title, director, year, length_minutes) values (7, 'Tempest, The', 'Harmony Crank', 2007, 16);
insert into movies (id, title, director, year, length_minutes) values (8, 'Jumping the Broom', 'Ermentrude Hendriks', 2005, 50);
insert into movies (id, title, director, year, length_minutes) values (9, 'Illegal Tender', 'Lorin Squelch', 2006, 133);
insert into movies (id, title, director, year, length_minutes) values (10, 'Brute, The (Bruto, El)', 'Quincy Littrell', 2006, 25);
insert into movies (id, title, director, year, length_minutes) values (11, 'Birdman', 'Fayette Record', 1994, 62);
insert into movies (id, title, director, year, length_minutes) values (12, 'Dara Ó Briain Talks Funny: Live in London', 'Brandais Ferrone', 2005, 67);
insert into movies (id, title, director, year, length_minutes) values (13, 'Saratov Approach, The', 'Chastity Dexter', 1994, 23);
insert into movies (id, title, director, year, length_minutes) values (14, 'Dumbo', 'Ellery Wilde', 2011, 76);
insert into movies (id, title, director, year, length_minutes) values (15, 'He Who Dares', 'Victor Crellin', 2009, 63);
insert into movies (id, title, director, year, length_minutes) values (16, 'The Sex and Violence Family Hour', 'Hollis Feye', 1996, 72);
insert into movies (id, title, director, year, length_minutes) values (17, 'Rink, The', 'Savina Daunay', 2006, 56);
insert into movies (id, title, director, year, length_minutes) values (18, 'Breaker! Breaker!', 'Araldo Aitchison', 1995, 68);
insert into movies (id, title, director, year, length_minutes) values (19, 'Run for Cover', 'Gardy De Giovanni', 2005, 44);
insert into movies (id, title, director, year, length_minutes) values (20, 'I Just Didn''t Do It (Soredemo boku wa yattenai)', 'Bettye Stollberger', 1994, 60);
insert into movies (id, title, director, year, length_minutes) values (21, 'When Ladies Meet', 'Emilia Radbourne', 2000, 83);
insert into movies (id, title, director, year, length_minutes) values (22, 'Captain Video: Master of the Stratosphere', 'Issi Cunnington', 2012, 133);
insert into movies (id, title, director, year, length_minutes) values (23, 'Jumper', 'Lyell Kalb', 1993, 51);
insert into movies (id, title, director, year, length_minutes) values (24, 'Nico Icon', 'Bobbye Stoeck', 1997, 44);
insert into movies (id, title, director, year, length_minutes) values (25, 'Tapeheads', 'Ina Girardez', 2009, 37);
insert into movies (id, title, director, year, length_minutes) values (26, 'Skin, Skin (Käpy selän alla)', 'Briana Hurll', 2003, 114);
insert into movies (id, title, director, year, length_minutes) values (27, 'Year My Parents Went on Vacation, The (O Ano em Que Meus Pais Saíram de Férias)', 'Corby Grinin', 2011, 39);
insert into movies (id, title, director, year, length_minutes) values (28, '12 Angry Men', 'Michael Wedmore', 2009, 25);
insert into movies (id, title, director, year, length_minutes) values (29, 'Old Fashioned Way, The', 'Linn Hadland', 2003, 65);
insert into movies (id, title, director, year, length_minutes) values (30, '33 Postcards', 'Brigg Conws', 2007, 52);
insert into movies (id, title, director, year, length_minutes) values (31, 'Fuel', 'L;urette Powney', 2001, 126);
insert into movies (id, title, director, year, length_minutes) values (32, 'Conversations with Other Women', 'Emmye Hanlin', 2006, 137);
insert into movies (id, title, director, year, length_minutes) values (33, 'Movie Days (Bíódagar)', 'Fabiano Cowin', 1998, 105);
insert into movies (id, title, director, year, length_minutes) values (34, 'Cashback', 'Darin Kemery', 1988, 98);
insert into movies (id, title, director, year, length_minutes) values (35, 'TPB AFK: The Pirate Bay Away from Keyboard', 'Patricio Prendergrast', 2007, 18);
insert into movies (id, title, director, year, length_minutes) values (36, 'Prophet''s Prey', 'Michaelina Jope', 2012, 136);
insert into movies (id, title, director, year, length_minutes) values (37, 'Watchers', 'Burk Hanney', 1990, 76);
insert into movies (id, title, director, year, length_minutes) values (38, 'Massacre Canyon', 'Sylvester Toman', 2002, 39);
insert into movies (id, title, director, year, length_minutes) values (39, 'Incredible Shrinking Man, The', 'Carolee Gooda', 2003, 32);
insert into movies (id, title, director, year, length_minutes) values (40, 'Bombshell', 'Kyla Peartree', 1994, 33);
insert into movies (id, title, director, year, length_minutes) values (41, 'Girl Walks Into a Bar', 'Barbara Muggeridge', 2009, 14);
insert into movies (id, title, director, year, length_minutes) values (42, 'Snowtown (Snowtown Murders, The)', 'Linoel Dilnot', 2006, 105);
insert into movies (id, title, director, year, length_minutes) values (43, 'Frozen Dead, The', 'Lesli Kneal', 2002, 25);
insert into movies (id, title, director, year, length_minutes) values (44, 'Charlie Victor Romeo', 'Gabriel Winkell', 1996, 11);
insert into movies (id, title, director, year, length_minutes) values (45, 'Tony Takitani', 'Alina Hubbart', 2004, 17);
insert into movies (id, title, director, year, length_minutes) values (46, 'A One-Way Trip to Antibes', 'Lincoln Giff', 2008, 94);
insert into movies (id, title, director, year, length_minutes) values (47, 'Touch of Evil', 'Rab Hateley', 1990, 102);
insert into movies (id, title, director, year, length_minutes) values (48, 'It''s Pat', 'Arlena Torry', 1988, 40);
insert into movies (id, title, director, year, length_minutes) values (49, 'Human Family Tree, The', 'Ame Domokos', 1997, 86);
insert into movies (id, title, director, year, length_minutes) values (50, 'Seeing Other People', 'Husein Blaze', 1994, 72);
insert into movies (id, title, director, year, length_minutes) values (51, 'Daughter of Dr. Jeckyll', 'Marybelle Pastor', 2001, 52);
insert into movies (id, title, director, year, length_minutes) values (52, 'Music Box', 'Huntlee Leeuwerink', 2002, 61);
insert into movies (id, title, director, year, length_minutes) values (53, 'Fine Pair, A (Ruba al prossimo tuo)', 'Aksel Davidwitz', 1994, 45);
insert into movies (id, title, director, year, length_minutes) values (54, 'High Life', 'Erl Benkin', 2004, 93);
insert into movies (id, title, director, year, length_minutes) values (55, 'Well Digger''s Daughter, The (La fille du puisatier)', 'Loy Hellis', 1994, 78);
insert into movies (id, title, director, year, length_minutes) values (56, 'Reap the Wild Wind', 'Jonell Upward', 2002, 11);
insert into movies (id, title, director, year, length_minutes) values (57, 'Junior Prom', 'Bobbette McCrone', 2007, 70);
insert into movies (id, title, director, year, length_minutes) values (58, 'Green Light', 'Cobb Edgcombe', 1994, 29);
insert into movies (id, title, director, year, length_minutes) values (59, 'Wah-Wah', 'Kristine Kersting', 2010, 107);
insert into movies (id, title, director, year, length_minutes) values (60, 'I Love Trouble', 'Nedda Cleevely', 1998, 82);
insert into movies (id, title, director, year, length_minutes) values (61, 'City of Violence, The (Jjakpae)', 'Damon Daburn', 1990, 32);
insert into movies (id, title, director, year, length_minutes) values (62, 'Hobbit: An Unexpected Journey, The', 'Anatole Stangroom', 2007, 19);
insert into movies (id, title, director, year, length_minutes) values (63, 'Big Trouble', 'Lindsay Vaadeland', 1972, 67);
insert into movies (id, title, director, year, length_minutes) values (64, 'Abbott and Costello in Hollywood', 'Eliza Grioli', 2005, 39);
insert into movies (id, title, director, year, length_minutes) values (65, 'No Small Affair', 'Lamond MacKellar', 2005, 118);
insert into movies (id, title, director, year, length_minutes) values (66, 'Generation Iron', 'Bay Gwioneth', 2001, 109);
insert into movies (id, title, director, year, length_minutes) values (67, 'I Know Who Killed Me', 'Alejoa Colly', 1969, 21);
insert into movies (id, title, director, year, length_minutes) values (68, 'Babylon 5: A Call to Arms', 'Sonya Brooks', 2012, 55);
insert into movies (id, title, director, year, length_minutes) values (69, 'Torrente 3: El protector', 'Jemie Kuna', 2013, 133);
insert into movies (id, title, director, year, length_minutes) values (70, 'Private Hell 36', 'Mia Butts', 2006, 97);
insert into movies (id, title, director, year, length_minutes) values (71, 'Magic Sword, The', 'Amata Littrell', 1996, 108);
insert into movies (id, title, director, year, length_minutes) values (72, 'Blue Swallow (Cheong yeon)', 'Karlik Gosneye', 2010, 11);
insert into movies (id, title, director, year, length_minutes) values (73, 'Kwaidan (Kaidan)', 'Neville Pennock', 2002, 128);
insert into movies (id, title, director, year, length_minutes) values (74, 'Love Me Tonight', 'Ulrike Awde', 2007, 125);
insert into movies (id, title, director, year, length_minutes) values (75, 'Calculator', 'Sigismund Brockherst', 1998, 79);
insert into movies (id, title, director, year, length_minutes) values (76, 'First Power, The', 'Richy Inkles', 2012, 55);
insert into movies (id, title, director, year, length_minutes) values (77, 'Nola', 'Lalo Affuso', 2012, 122);
insert into movies (id, title, director, year, length_minutes) values (78, 'Autumn Leaves', 'Annalise Spyer', 2009, 25);
insert into movies (id, title, director, year, length_minutes) values (79, 'Madeleine', 'Fleming Goodspeed', 2004, 122);
insert into movies (id, title, director, year, length_minutes) values (80, 'Noel', 'Windham Branno', 1996, 32);
insert into movies (id, title, director, year, length_minutes) values (81, 'Young and the Dead, The', 'Livvie Negri', 1991, 124);
insert into movies (id, title, director, year, length_minutes) values (82, 'Bat*21', 'Carina Matteacci', 2000, 66);
insert into movies (id, title, director, year, length_minutes) values (83, 'Car Bonus (Autobonus)', 'Sharla Ibotson', 2009, 78);
insert into movies (id, title, director, year, length_minutes) values (84, 'Memento Mori (Yeogo goedam II)', 'Olivie McLenahan', 1985, 18);
insert into movies (id, title, director, year, length_minutes) values (85, 'Speed Zone! (a.k.a. Cannonball Run III)', 'Gabbie Troubridge', 2007, 83);
insert into movies (id, title, director, year, length_minutes) values (86, 'An Alligator Named Daisy', 'Peta Skocroft', 2010, 47);
insert into movies (id, title, director, year, length_minutes) values (87, 'Cloak and Dagger', 'Shandra Jefford', 1994, 118);
insert into movies (id, title, director, year, length_minutes) values (88, 'Hollywood Between Paranoia and Sci-Fi. The Power of Myth', 'Elli Sumpton', 1998, 139);
insert into movies (id, title, director, year, length_minutes) values (89, 'Man Called Adam, A', 'Tobit Hause', 2009, 57);
insert into movies (id, title, director, year, length_minutes) values (90, 'Directed by John Ford', 'Mable Grishmanov', 1999, 130);
insert into movies (id, title, director, year, length_minutes) values (91, 'Alyce Kills', 'Maryrose Barrow', 2000, 32);
insert into movies (id, title, director, year, length_minutes) values (92, 'Vampires Suck', 'Enrico Sully', 2003, 97);
insert into movies (id, title, director, year, length_minutes) values (93, 'El tren de la memoria', 'Blanche Emanuelli', 2006, 61);
insert into movies (id, title, director, year, length_minutes) values (94, 'Tetsuo II: Body Hammer', 'Cassy Kenwrick', 2002, 75);
insert into movies (id, title, director, year, length_minutes) values (95, 'Björk at the Royal Opera House', 'Audi MacAvddy', 1999, 84);
insert into movies (id, title, director, year, length_minutes) values (96, 'Nightmare Factory', 'Francisca Drewitt', 2010, 111);
insert into movies (id, title, director, year, length_minutes) values (97, 'Housesitter', 'Sacha Raubenheimer', 1995, 62);
insert into movies (id, title, director, year, length_minutes) values (98, 'Amazing Grace and Chuck', 'Carmelina Coiley', 2010, 48);
insert into movies (id, title, director, year, length_minutes) values (99, 'The Magic Box', 'Town Fennelly', 2001, 81);
insert into movies (id, title, director, year, length_minutes) values (100, '12:01 PM', 'Riccardo Cocci', 2005, 29);