Quickstart
This is a quickstart guide on how to use Superinsight ML database to perform ML operations using SQL query. You will learn how to create a database table and insert data into your table. Finally you will be able to run a semantic search using SQL query. It's that simple. If you don't have an account yet, sign up to get early access here.
1. Installation
We have the standalone and cluster verison of Superinsight. To get started we recommend you use our standalone version in a non-production environment. When you are ready to move to a production environment, we recommend the distributed version which will give you much better scalability when runnin in kubernetes.
For the standalone version, you can run it using a simple docker command. Don't forget to change the username and password.
docker run \
--name superinsight-db-standalone \
-p 5432:5432 \
-e SUPERINSIGHT_USER=admin \
-e SUPERINSIGHT_PASSWORD=password \
superinsight/superinsight-db-standalone:latest
For the distributed version, please reach out to the our Support Team
2. Connect using a database client
Once the docker container is running, you can connect to Superinsight using the PostgreSQL protocol and the default database Superinsight on Port 5432.
postgres://admin:password@127.0.0.1:5432/superinsight
3. Create a database table
Database table can be created using the CREATE TABLE statement in superinsight. For the columns that you will like to enable semantic search, assign them with the data type TEXT.
CREATE TABLE mldb.movie (
_id serial PRIMARY KEY,
title TEXT,
genre TEXT,
overview TEXT,
released_year varchar(100),
runtime varchar(100),
imdb_rating float8,
director varchar(100),
no_of_votes int4
);
4. Insert data to database table
Rows can be inserted to the database using the INSERT statement in superinsight.
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('The Shawshank Redemption','Drama','Two imprisoned men bond over a number of years, finding solace and eventual redemption through acts of common decency.','1994','142 min',9.3,'Frank Darabont',2343110),
('The Godfather','Crime, Drama','An organized crime dynasty''s aging patriarch transfers control of his clandestine empire to his reluctant son.','1972','175 min',9.2,'Francis Ford Coppola',1620367),
('The Dark Knight','Action, Crime, Drama','When the menace known as the Joker wreaks havoc and chaos on the people of Gotham, Batman must accept one of the greatest psychological and physical tests of his ability to fight injustice.','2008','152 min',9.0,'Christopher Nolan',2303232),
('The Godfather: Part II','Crime, Drama','The early life and career of Vito Corleone in 1920s New York City is portrayed, while his son, Michael, expands and tightens his grip on the family crime syndicate.','1974','202 min',9.0,'Francis Ford Coppola',1129952),
('12 Angry Men','Crime, Drama','A jury holdout attempts to prevent a miscarriage of justice by forcing his colleagues to reconsider the evidence.','1957','96 min',9.0,'Sidney Lumet',689845),
('The Lord of the Rings: The Return of the King','Action, Adventure, Drama','Gandalf and Aragorn lead the World of Men against Sauron''s army to draw his gaze from Frodo and Sam as they approach Mount Doom with the One Ring.','2003','201 min',8.9,'Peter Jackson',1642758),
('Pulp Fiction','Crime, Drama','The lives of two mob hitmen, a boxer, a gangster and his wife, and a pair of diner bandits intertwine in four tales of violence and redemption.','1994','154 min',8.9,'Quentin Tarantino',1826188),
('Schindler''s List','Biography, Drama, History','In German-occupied Poland during World War II, industrialist Oskar Schindler gradually becomes concerned for his Jewish workforce after witnessing their persecution by the Nazis.','1993','195 min',8.9,'Steven Spielberg',1213505),
('Inception','Action, Adventure, Sci-Fi','A thief who steals corporate secrets through the use of dream-sharing technology is given the inverse task of planting an idea into the mind of a C.E.O.','2010','148 min',8.8,'Christopher Nolan',2067042),
('Fight Club','Drama','An insomniac office worker and a devil-may-care soapmaker form an underground fight club that evolves into something much, much more.','1999','139 min',8.8,'David Fincher',1854740);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('The Lord of the Rings: The Fellowship of the Ring','Action, Adventure, Drama','A meek Hobbit from the Shire and eight companions set out on a journey to destroy the powerful One Ring and save Middle-earth from the Dark Lord Sauron.','2001','178 min',8.8,'Peter Jackson',1661481),
('Forrest Gump','Drama, Romance','The presidencies of Kennedy and Johnson, the events of Vietnam, Watergate and other historical events unfold through the perspective of an Alabama man with an IQ of 75, whose only desire is to be reunited with his childhood sweetheart.','1994','142 min',8.8,'Robert Zemeckis',1809221),
('Il buono, il brutto, il cattivo','Western','A bounty hunting scam joins two men in an uneasy alliance against a third in a race to find a fortune in gold buried in a remote cemetery.','1966','161 min',8.8,'Sergio Leone',688390),
('The Lord of the Rings: The Two Towers','Action, Adventure, Drama','While Frodo and Sam edge closer to Mordor with the help of the shifty Gollum, the divided fellowship makes a stand against Sauron''s new ally, Saruman, and his hordes of Isengard.','2002','179 min',8.7,'Peter Jackson',1485555),
('The Matrix','Action, Sci-Fi','When a beautiful stranger leads computer hacker Neo to a forbidding underworld, he discovers the shocking truth--the life he knows is the elaborate deception of an evil cyber-intelligence.','1999','136 min',8.7,'Lana Wachowski',1676426),
('Goodfellas','Biography, Crime, Drama','The story of Henry Hill and his life in the mob, covering his relationship with his wife Karen Hill and his mob partners Jimmy Conway and Tommy DeVito in the Italian-American crime syndicate.','1990','146 min',8.7,'Martin Scorsese',1020727),
('Star Wars: Episode V - The Empire Strikes Back','Action, Adventure, Fantasy','After the Rebels are brutally overpowered by the Empire on the ice planet Hoth, Luke Skywalker begins Jedi training with Yoda, while his friends are pursued by Darth Vader and a bounty hunter named Boba Fett all over the galaxy.','1980','124 min',8.7,'Irvin Kershner',1159315),
('One Flew Over the Cuckoo''s Nest','Drama','A criminal pleads insanity and is admitted to a mental institution, where he rebels against the oppressive nurse and rallies up the scared patients.','1975','133 min',8.7,'Milos Forman',918088),
('Hamilton','Biography, Drama, History','The real life of one of America''s foremost founding fathers and first Secretary of the Treasury, Alexander Hamilton. Captured live on Broadway from the Richard Rodgers Theater with the original Broadway cast.','2020','160 min',8.6,'Thomas Kail',55291),
('Gisaengchung','Comedy, Drama, Thriller','Greed and class discrimination threaten the newly formed symbiotic relationship between the wealthy Park family and the destitute Kim clan.','2019','132 min',8.6,'Bong Joon Ho',552778);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Soorarai Pottru','Drama','Nedumaaran Rajangam "Maara" sets out to make the common man fly and in the process takes on the world''s most capital intensive industry and several enemies who stand in his way.','2020','153 min',8.6,'Sudha Kongara',54995),
('Interstellar','Adventure, Drama, Sci-Fi','A team of explorers travel through a wormhole in space in an attempt to ensure humanity''s survival.','2014','169 min',8.6,'Christopher Nolan',1512360),
('Cidade de Deus','Crime, Drama','In the slums of Rio, two kids'' paths diverge as one struggles to become a photographer and the other a kingpin.','2002','130 min',8.6,'Fernando Meirelles',699256),
('Sen to Chihiro no kamikakushi','Animation, Adventure, Family','During her family''s move to the suburbs, a sullen 10-year-old girl wanders into a world ruled by gods, witches, and spirits, and where humans are changed into beasts.','2001','125 min',8.6,'Hayao Miyazaki',651376),
('Saving Private Ryan','Drama, War','Following the Normandy Landings, a group of U.S. soldiers go behind enemy lines to retrieve a paratrooper whose brothers have been killed in action.','1998','169 min',8.6,'Steven Spielberg',1235804),
('The Green Mile','Crime, Drama, Fantasy','The lives of guards on Death Row are affected by one of their charges: a black man accused of child murder and rape, yet who has a mysterious gift.','1999','189 min',8.6,'Frank Darabont',1147794),
('La vita è bella','Comedy, Drama, Romance','When an open-minded Jewish librarian and his son become victims of the Holocaust, he uses a perfect mixture of will, humor, and imagination to protect his son from the dangers around their camp.','1997','116 min',8.6,'Roberto Benigni',623629),
('Se7en','Crime, Drama, Mystery','Two detectives, a rookie and a veteran, hunt a serial killer who uses the seven deadly sins as his motives.','1995','127 min',8.6,'David Fincher',1445096),
('The Silence of the Lambs','Crime, Drama, Thriller','A young F.B.I. cadet must receive the help of an incarcerated and manipulative cannibal killer to help catch another serial killer, a madman who skins his victims.','1991','118 min',8.6,'Jonathan Demme',1270197),
('Star Wars','Action, Adventure, Fantasy','Luke Skywalker joins forces with a Jedi Knight, a cocky pilot, a Wookiee and two droids to save the galaxy from the Empire''s world-destroying battle station, while also attempting to rescue Princess Leia from the mysterious Darth Vader.','1977','121 min',8.6,'George Lucas',1231473);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Seppuku','Action, Drama, Mystery','When a ronin requesting seppuku at a feudal lord''s palace is told of the brutal suicide of another ronin who previously visited, he reveals how their pasts are intertwined - and in doing so challenges the clan''s integrity.','1962','133 min',8.6,'Masaki Kobayashi',42004),
('Shichinin no samurai','Action, Adventure, Drama','A poor village under attack by bandits recruits seven unemployed samurai to help them defend themselves.','1954','207 min',8.6,'Akira Kurosawa',315744),
('It''s a Wonderful Life','Drama, Family, Fantasy','An angel is sent from Heaven to help a desperately frustrated businessman by showing him what life would have been like if he had never existed.','1946','130 min',8.6,'Frank Capra',405801),
('Joker','Crime, Drama, Thriller','In Gotham City, mentally troubled comedian Arthur Fleck is disregarded and mistreated by society. He then embarks on a downward spiral of revolution and bloody crime. This path brings him face-to-face with his alter-ego: the Joker.','2019','122 min',8.5,'Todd Phillips',939252),
('Whiplash','Drama, Music','A promising young drummer enrolls at a cut-throat music conservatory where his dreams of greatness are mentored by an instructor who will stop at nothing to realize a student''s potential.','2014','106 min',8.5,'Damien Chazelle',717585),
('The Intouchables','Biography, Comedy, Drama','After he becomes a quadriplegic from a paragliding accident, an aristocrat hires a young man from the projects to be his caregiver.','2011','112 min',8.5,'Olivier Nakache',760360),
('The Prestige','Drama, Mystery, Sci-Fi','After a tragic accident, two stage magicians engage in a battle to create the ultimate illusion while sacrificing everything they have to outwit each other.','2006','130 min',8.5,'Christopher Nolan',1190259),
('The Departed','Crime, Drama, Thriller','An undercover cop and a mole in the police attempt to identify each other while infiltrating an Irish gang in South Boston.','2006','151 min',8.5,'Martin Scorsese',1189773),
('The Pianist','Biography, Drama, Music','A Polish Jewish musician struggles to survive the destruction of the Warsaw ghetto of World War II.','2002','150 min',8.5,'Roman Polanski',729603),
('Gladiator','Action, Adventure, Drama','A former Roman General sets out to exact vengeance against the corrupt emperor who murdered his family and sent him into slavery.','2000','155 min',8.5,'Ridley Scott',1341460);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('American History X','Drama','A former neo-nazi skinhead tries to prevent his younger brother from going down the same wrong path that he did.','1998','119 min',8.5,'Tony Kaye',1034705),
('The Usual Suspects','Crime, Mystery, Thriller','A sole survivor tells of the twisty events leading up to a horrific gun battle on a boat, which began when five criminals met at a seemingly random police lineup.','1995','106 min',8.5,'Bryan Singer',991208),
('Léon','Action, Crime, Drama','Mathilda, a 12-year-old girl, is reluctantly taken in by Léon, a professional assassin, after her family is murdered. An unusual relationship forms as she becomes his protégée and learns the assassin''s trade.','1994','110 min',8.5,'Luc Besson',1035236),
('The Lion King','Animation, Adventure, Drama','Lion prince Simba and his father are targeted by his bitter uncle, who wants to ascend the throne himself.','1994','88 min',8.5,'Roger Allers',942045),
('Terminator 2: Judgment Day','Action, Sci-Fi','A cyborg, identical to the one who failed to kill Sarah Connor, must now protect her teenage son, John Connor, from a more advanced and powerful cyborg.','1991','137 min',8.5,'James Cameron',995506),
('Nuovo Cinema Paradiso','Drama, Romance','A filmmaker recalls his childhood when falling in love with the pictures at the cinema of his home village and forms a deep friendship with the cinema''s projectionist.','1988','155 min',8.5,'Giuseppe Tornatore',230763),
('Hotaru no haka','Animation, Drama, War','A young boy and his little sister struggle to survive in Japan during World War II.','1988','89 min',8.5,'Isao Takahata',235231),
('Back to the Future','Adventure, Comedy, Sci-Fi','Marty McFly, a 17-year-old high school student, is accidentally sent thirty years into the past in a time-traveling DeLorean invented by his close friend, the eccentric scientist Doc Brown.','1985','116 min',8.5,'Robert Zemeckis',1058081),
('Once Upon a Time in the West','Western','A mysterious stranger with a harmonica joins forces with a notorious desperado to protect a beautiful widow from a ruthless assassin working for the railroad.','1968','165 min',8.5,'Sergio Leone',302844),
('Psycho','Horror, Mystery, Thriller','A Phoenix secretary embezzles $40,000 from her employer''s client, goes on the run, and checks into a remote motel run by a young man under the domination of his mother.','1960','109 min',8.5,'Alfred Hitchcock',604211);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Casablanca','Drama, Romance, War','A cynical expatriate American cafe owner struggles to decide whether or not to help his former lover and her fugitive husband escape the Nazis in French Morocco.','1942','102 min',8.5,'Michael Curtiz',522093),
('Modern Times','Comedy, Drama, Family','The Tramp struggles to live in modern industrial society with the help of a young homeless woman.','1936','87 min',8.5,'Charles Chaplin',217881),
('City Lights','Comedy, Drama, Romance','With the aid of a wealthy erratic tippler, a dewy-eyed tramp who has fallen in love with a sightless flower girl accumulates money to be able to help her medically.','1931','87 min',8.5,'Charles Chaplin',167839),
('Capharnaüm','Drama','While serving a five-year sentence for a violent crime, a 12-year-old boy sues his parents for neglect.','2018','126 min',8.4,'Nadine Labaki',62635),
('Ayla: The Daughter of War','Biography, Drama, History','In 1950, amid-st the ravages of the Korean War, Sergeant Süleyman stumbles upon a half-frozen little girl, with no parents and no help in sight. Frantic, scared and on the verge of death, ... See full summary »','2017','125 min',8.4,'Can Ulkay',34112),
('Vikram Vedha','Action, Crime, Drama','Vikram, a no-nonsense police officer, accompanied by Simon, his partner, is on the hunt to capture Vedha, a smuggler and a murderer. Vedha tries to change Vikram''s life, which leads to a conflict.','2017','147 min',8.4,'Gayatri',28401),
('Kimi no na wa.','Animation, Drama, Fantasy','Two strangers find themselves linked in a bizarre way. When a connection forms, will distance be the only thing to keep them apart?','2016','106 min',8.4,'Makoto Shinkai',194838),
('Dangal','Action, Biography, Drama','Former wrestler Mahavir Singh Phogat and his two wrestler daughters struggle towards glory at the Commonwealth Games in the face of societal oppression.','2016','161 min',8.4,'Nitesh Tiwari',156479),
('Spider-Man: Into the Spider-Verse','Animation, Action, Adventure','Teen Miles Morales becomes the Spider-Man of his universe, and must join with five spider-powered individuals from other dimensions to stop a threat for all realities.','2018','117 min',8.4,'Bob Persichetti',375110),
('Avengers: Endgame','Action, Adventure, Drama','After the devastating events of Avengers: Infinity War (2018), the universe is in ruins. With the help of remaining allies, the Avengers assemble once more in order to reverse Thanos'' actions and restore balance to the universe.','2019','181 min',8.4,'Anthony Russo',809955);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Avengers: Infinity War','Action, Adventure, Sci-Fi','The Avengers and their allies must be willing to sacrifice all in an attempt to defeat the powerful Thanos before his blitz of devastation and ruin puts an end to the universe.','2018','149 min',8.4,'Anthony Russo',834477),
('Coco','Animation, Adventure, Family','Aspiring musician Miguel, confronted with his family''s ancestral ban on music, enters the Land of the Dead to find his great-great-grandfather, a legendary singer.','2017','105 min',8.4,'Lee Unkrich',384171),
('Django Unchained','Drama, Western','With the help of a German bounty hunter, a freed slave sets out to rescue his wife from a brutal Mississippi plantation owner.','2012','165 min',8.4,'Quentin Tarantino',1357682),
('The Dark Knight Rises','Action, Adventure','Eight years after the Joker''s reign of anarchy, Batman, with the help of the enigmatic Catwoman, is forced from his exile to save Gotham City from the brutal guerrilla terrorist Bane.','2012','164 min',8.4,'Christopher Nolan',1516346),
('3 Idiots','Comedy, Drama','Two friends are searching for their long lost companion. They revisit their college days and recall the memories of their friend who inspired them to think differently, even as the rest of the world called them "idiots".','2009','170 min',8.4,'Rajkumar Hirani',344445),
('Taare Zameen Par','Drama, Family','An eight-year-old boy is thought to be a lazy trouble-maker, until the new art teacher has the patience and compassion to discover the real problem behind his struggles in school.','2007','165 min',8.4,'Aamir Khan',168895),
('WALL·E','Animation, Adventure, Family','In the distant future, a small waste-collecting robot inadvertently embarks on a space journey that will ultimately decide the fate of mankind.','2008','98 min',8.4,'Andrew Stanton',999790),
('The Lives of Others','Drama, Mystery, Thriller','In 1984 East Berlin, an agent of the secret police, conducting surveillance on a writer and his lover, finds himself becoming increasingly absorbed by their lives.','2006','137 min',8.4,'Florian Henckel von Donnersmarck',358685),
('Oldeuboi','Action, Drama, Mystery','After being kidnapped and imprisoned for fifteen years, Oh Dae-Su is released, only to find that he must find his captor in five days.','2003','101 min',8.4,'Chan-wook Park',515451),
('Memento','Mystery, Thriller','A man with short-term memory loss attempts to track down his wife''s murderer.','2000','113 min',8.4,'Christopher Nolan',1125712);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Mononoke-hime','Animation, Action, Adventure','On a journey to find the cure for a Tatarigami''s curse, Ashitaka finds himself in the middle of a war between the forest gods and Tatara, a mining colony. In this quest he also meets San, the Mononoke Hime.','1997','134 min',8.4,'Hayao Miyazaki',343171),
('Once Upon a Time in America','Crime, Drama','A former Prohibition-era Jewish gangster returns to the Lower East Side of Manhattan over thirty years later, where he once again must confront the ghosts and regrets of his old life.','1984','229 min',8.4,'Sergio Leone',311365),
('Raiders of the Lost Ark','Action, Adventure','In 1936, archaeologist and adventurer Indiana Jones is hired by the U.S. government to find the Ark of the Covenant before Adolf Hitler''s Nazis can obtain its awesome powers.','1981','115 min',8.4,'Steven Spielberg',884112),
('The Shining','Drama, Horror','A family heads to an isolated hotel for the winter where a sinister presence influences the father into violence, while his psychic son sees horrific forebodings from both past and future.','1980','146 min',8.4,'Stanley Kubrick',898237),
('Apocalypse Now','Drama, Mystery, War','A U.S. Army officer serving in Vietnam is tasked with assassinating a renegade Special Forces Colonel who sees himself as a god.','1979','147 min',8.4,'Francis Ford Coppola',606398),
('Alien','Horror, Sci-Fi','After a space merchant vessel receives an unknown transmission as a distress call, one of the crew is attacked by a mysterious life form and they soon realize that its life cycle has merely begun.','1979','117 min',8.4,'Ridley Scott',787806),
('Anand','Drama, Musical','The story of a terminally ill man who wishes to live life to the fullest before the inevitable occurs, as told by his best friend.','1971','122 min',8.4,'Hrishikesh Mukherjee',30273),
('Tengoku to jigoku','Crime, Drama, Mystery','An executive of a shoe company becomes a victim of extortion when his chauffeur''s son is kidnapped and held for ransom.','1963','143 min',8.4,'Akira Kurosawa',34357),
('Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb','Comedy','An insane general triggers a path to nuclear holocaust that a War Room full of politicians and generals frantically tries to stop.','1964','95 min',8.4,'Stanley Kubrick',450474),
('Witness for the Prosecution','Crime, Drama, Mystery','A veteran British barrister must defend his client in a murder trial that has surprise after surprise.','1957','116 min',8.4,'Billy Wilder',108862);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Paths of Glory','Drama, War','After refusing to attack an enemy position, a general accuses the soldiers of cowardice and their commanding officer must defend them.','1957','88 min',8.4,'Stanley Kubrick',178092),
('Rear Window','Mystery, Thriller','A wheelchair-bound photographer spies on his neighbors from his apartment window and becomes convinced one of them has committed murder.','1954','112 min',8.4,'Alfred Hitchcock',444074),
('Sunset Blvd.','Drama, Film-Noir','A screenwriter develops a dangerous relationship with a faded film star determined to make a triumphant return.','1950','110 min',8.4,'Billy Wilder',201632),
('The Great Dictator','Comedy, Drama, War','Dictator Adenoid Hynkel tries to expand his empire while a poor Jewish barber tries to avoid persecution from Hynkel''s regime.','1940','125 min',8.4,'Charles Chaplin',203150),
('1917','Drama, Thriller, War','April 6th, 1917. As a regiment assembles to wage war deep in enemy territory, two soldiers are assigned to race against time and deliver a message that will stop 1,600 men from walking straight into a deadly trap.','2019','119 min',8.3,'Sam Mendes',425844),
('Tumbbad','Drama, Fantasy, Horror','A mythological story about a goddess who created the entire universe. The plot revolves around the consequences when humans build a temple for her first-born.','2018','104 min',8.3,'Rahi Anil Barve',27793),
('Andhadhun','Crime, Drama, Music','A series of mysterious events change the life of a blind pianist, who must now report a crime that he should technically know nothing of.','2018','139 min',8.3,'Sriram Raghavan',71875),
('Drishyam','Crime, Drama, Thriller','A man goes to extreme lengths to save his family from punishment after the family commits an accidental crime.','2013','160 min',8.3,'Jeethu Joseph',30722),
('Vertigo','Mystery, Romance, Thriller','A former police detective juggles wrestling with his personal demons and becoming obsessed with a hauntingly beautiful woman.','1958','128 min',8.3,'Alfred Hitchcock',364368),
('Jagten','Drama','A teacher lives a lonely life, all the while struggling over his son''s custody. His life slowly gets better as he finds love and receives good news from his son, but his new luck is about to be brutally shattered by an innocent little lie.','2012','115 min',8.3,'Thomas Vinterberg',281623);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Jodaeiye Nader az Simin','Drama','A married couple are faced with a difficult decision - to improve the life of their child by moving to another country or to stay in Iran and look after a deteriorating parent who has Alzheimer''s disease.','2011','123 min',8.3,'Asghar Farhadi',220002),
('Incendies','Drama, Mystery, War','Twins journey to the Middle East to discover their family history and fulfill their mother''s last wishes.','2010','131 min',8.3,'Denis Villeneuve',150023),
('Miracle in cell NO.7','Drama','A story of love between a mentally-ill father who was wrongly accused of murder and his lovely six years old daughter. The prison would be their home. Based on the 2013 Korean movie 7-beon-bang-ui seon-mul (2013).','2019','132 min',8.3,'Mehmet Ada Öztekin',33935),
('Babam ve Oglum','Drama, Family','The family of a left-wing journalist is torn apart after the military coup of Turkey in 1980.','2005','112 min',8.3,'Çagan Irmak',78925),
('Inglourious Basterds','Adventure, Drama, War','In Nazi-occupied France during World War II, a plan to assassinate Nazi leaders by a group of Jewish U.S. soldiers coincides with a theatre owner''s vengeful plans for the same.','2009','153 min',8.3,'Quentin Tarantino',1267869),
('Eternal Sunshine of the Spotless Mind','Drama, Romance, Sci-Fi','When their relationship turns sour, a couple undergoes a medical procedure to have each other erased from their memories.','2004','108 min',8.3,'Michel Gondry',911664),
('Amélie','Comedy, Romance','Amélie is an innocent and naive girl in Paris with her own sense of justice. She decides to help those around her and, along the way, discovers love.','2001','122 min',8.3,'Jean-Pierre Jeunet',703810),
('Snatch','Comedy, Crime','Unscrupulous boxing promoters, violent bookmakers, a Russian gangster, incompetent amateur robbers and supposedly Jewish jewelers fight to track down a priceless stolen diamond.','2000','104 min',8.3,'Guy Ritchie',782001),
('Requiem for a Dream','Drama','The drug-induced utopias of four Coney Island people are shattered when their addictions run deep.','2000','102 min',8.3,'Darren Aronofsky',766870),
('American Beauty','Drama','A sexually frustrated suburban father has a mid-life crisis after becoming infatuated with his daughter''s best friend.','1999','122 min',8.3,'Sam Mendes',1069738);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Good Will Hunting','Drama, Romance','Will Hunting, a janitor at M.I.T., has a gift for mathematics, but needs help from a psychologist to find direction in his life.','1997','126 min',8.3,'Gus Van Sant',861606),
('Bacheha-Ye aseman','Drama, Family, Sport','After a boy loses his sister''s pair of shoes, he goes on a series of adventures in order to find them. When he can''t, he tries a new way to "win" a new pair.','1997','89 min',8.3,'Majid Majidi',65341),
('Toy Story','Animation, Adventure, Comedy','A cowboy doll is profoundly threatened and jealous when a new spaceman figure supplants him as top toy in a boy''s room.','1995','81 min',8.3,'John Lasseter',887429),
('Braveheart','Biography, Drama, History','Scottish warrior William Wallace leads his countrymen in a rebellion to free his homeland from the tyranny of King Edward I of England.','1995','178 min',8.3,'Mel Gibson',959181),
('Reservoir Dogs','Crime, Drama, Thriller','When a simple jewelry heist goes horribly wrong, the surviving criminals begin to suspect that one of them is a police informant.','1992','99 min',8.3,'Quentin Tarantino',918562),
('Full Metal Jacket','Drama, War','A pragmatic U.S. Marine observes the dehumanizing effects the Vietnam War has on his fellow recruits from their brutal boot camp training to the bloody street fighting in Hue.','1987','116 min',8.3,'Stanley Kubrick',675146),
('Idi i smotri','Drama, Thriller, War','After finding an old rifle, a young boy joins the Soviet resistance movement against ruthless German forces and experiences the horrors of World War II.','1985','142 min',8.3,'Elem Klimov',59056),
('Aliens','Action, Adventure, Sci-Fi','Fifty-seven years after surviving an apocalyptic attack aboard her space vessel by merciless space creatures, Officer Ripley awakens from hyper-sleep and tries to warn anyone who will listen about the predators.','1986','137 min',8.3,'James Cameron',652719),
('Amadeus','Biography, Drama, History','The life, success and troubles of Wolfgang Amadeus Mozart, as told by Antonio Salieri, the contemporaneous composer who was insanely jealous of Mozart''s talent and claimed to have murdered him.','1984','160 min',8.3,'Milos Forman',369007),
('Scarface','Crime, Drama','In 1980 Miami, a determined Cuban immigrant takes over a drug cartel and succumbs to greed.','1983','170 min',8.3,'Brian De Palma',740911);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Star Wars: Episode VI - Return of the Jedi','Action, Adventure, Fantasy','After a daring mission to rescue Han Solo from Jabba the Hutt, the Rebels dispatch to Endor to destroy the second Death Star. Meanwhile, Luke struggles to help Darth Vader back from the dark side without falling into the Emperor''s trap.','1983','131 min',8.3,'Richard Marquand',950470),
('Das Boot','Adventure, Drama, Thriller','The claustrophobic world of a WWII German U-boat; boredom, filth and sheer terror.','1981','149 min',8.3,'Wolfgang Petersen',231855),
('Taxi Driver','Crime, Drama','A mentally unstable veteran works as a nighttime taxi driver in New York City, where the perceived decadence and sleaze fuels his urge for violent action by attempting to liberate a presidential campaign worker and an underage prostitute.','1976','114 min',8.3,'Martin Scorsese',724636),
('The Sting','Comedy, Crime, Drama','Two grifters team up to pull off the ultimate con.','1973','129 min',8.3,'George Roy Hill',241513),
('A Clockwork Orange','Crime, Drama, Sci-Fi','In the future, a sadistic gang leader is imprisoned and volunteers for a conduct-aversion experiment, but it doesn''t go as planned.','1971','136 min',8.3,'Stanley Kubrick',757904),
('2001: A Space Odyssey','Adventure, Sci-Fi','After discovering a mysterious artifact buried beneath the Lunar surface, mankind sets off on a quest to find its origins with help from intelligent supercomputer H.A.L. 9000.','1968','149 min',8.3,'Stanley Kubrick',603517),
('Per qualche dollaro in più','Western','Two bounty hunters with the same intentions team up to track down a Western outlaw.','1965','132 min',8.3,'Sergio Leone',232772),
('Lawrence of Arabia','Adventure, Biography, Drama','The story of T.E. Lawrence, the English officer who successfully united and led the diverse, often warring, Arab tribes during World War I in order to fight the Turks.','1962','228 min',8.3,'David Lean',268085),
('The Apartment','Comedy, Drama, Romance','A man tries to rise in his company by letting its executives use his apartment for trysts, but complications and a romance of his own ensue.','1960','125 min',8.3,'Billy Wilder',164363),
('North by Northwest','Adventure, Mystery, Thriller','A New York City advertising executive goes on the run after being mistaken for a government agent by a group of foreign spies.','1959','136 min',8.3,'Alfred Hitchcock',299198);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Singin'' in the Rain','Comedy, Musical, Romance','A silent film production company and cast make a difficult transition to sound.','1952','103 min',8.3,'Stanley Donen',218957),
('Ikiru','Drama','A bureaucrat tries to find a meaning in his life after he discovers he has terminal cancer.','1952','143 min',8.3,'Akira Kurosawa',68463),
('Ladri di biciclette','Drama','In post-war Italy, a working-class man''s bicycle is stolen. He and his son set out to find it.','1948','89 min',8.3,'Vittorio De Sica',146427),
('Double Indemnity','Crime, Drama, Film-Noir','An insurance representative lets himself be talked by a seductive housewife into a murder/insurance fraud scheme that arouses the suspicion of an insurance investigator.','1944','107 min',8.3,'Billy Wilder',143525),
('Citizen Kane','Drama, Mystery','Following the death of publishing tycoon Charles Foster Kane, reporters scramble to uncover the meaning of his final utterance; ''Rosebud''.','1941','119 min',8.3,'Orson Welles',403351),
('M - Eine Stadt sucht einen Mörder','Crime, Mystery, Thriller','When the police in a German city are unable to catch a child-murderer, other criminals join in the manhunt.','1931','117 min',8.3,'Fritz Lang',143434),
('Metropolis','Drama, Sci-Fi','In a futuristic city sharply divided between the working class and the city planners, the son of the city''s mastermind falls in love with a working-class prophet who predicts the coming of a savior to mediate their differences.','1927','153 min',8.3,'Fritz Lang',159992),
('The Kid','Comedy, Drama, Family','The Tramp cares for an abandoned child, but events put that relationship in jeopardy.','1921','68 min',8.3,'Charles Chaplin',113314),
('Chhichhore','Comedy, Drama','A tragic incident forces Anirudh, a middle-aged man, to take a trip down memory lane and reminisce his college days along with his friends, who were labelled as losers.','2019','143 min',8.2,'Nitesh Tiwari',33893),
('Uri: The Surgical Strike','Action, Drama, War','Indian army special forces execute a covert operation, avenging the killing of fellow army men at their base by a terrorist group.','2018','138 min',8.2,'Aditya Dhar',43444);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('K.G.F: Chapter 1','Action, Drama','In the 1970s, a fierce rebel rises against brutal oppression and becomes the symbol of hope to legions of downtrodden people.','2018','156 min',8.2,'Prashanth Neel',36680),
('Green Book','Biography, Comedy, Drama','A working-class Italian-American bouncer becomes the driver of an African-American classical pianist on a tour of venues through the 1960s American South.','2018','130 min',8.2,'Peter Farrelly',377884),
('Three Billboards Outside Ebbing, Missouri','Comedy, Crime, Drama','A mother personally challenges the local authorities to solve her daughter''s murder when they fail to catch the culprit.','2017','115 min',8.2,'Martin McDonagh',432610),
('Talvar','Crime, Drama, Mystery','An experienced investigator confronts several conflicting theories about the perpetrators of a violent double homicide.','2015','132 min',8.2,'Meghna Gulzar',31142),
('Baahubali 2: The Conclusion','Action, Drama','When Shiva, the son of Bahubali, learns about his heritage, he begins to look for answers. His story is juxtaposed with past events that unfolded in the Mahishmati Kingdom.','2017','167 min',8.2,'S.S. Rajamouli',75348),
('Klaus','Animation, Adventure, Comedy','A simple act of kindness always sparks another, even in a frozen, faraway place. When Smeerensburg''s new postman, Jesper, befriends toymaker Klaus, their gifts melt an age-old feud and deliver a sleigh full of holiday traditions.','2019','96 min',8.2,'Sergio Pablos',104761),
('Drishyam','Crime, Drama, Mystery','Desperate measures are taken by a man who tries to save his family from the dark side of the law, after they commit an unexpected crime.','2015','163 min',8.2,'Nishikant Kamat',70367),
('Queen','Adventure, Comedy, Drama','A Delhi girl from a traditional family sets out on a solo honeymoon after her marriage gets cancelled.','2013','146 min',8.2,'Vikas Bahl',60701),
('Mandariinid','Drama, War','In 1992, war rages in Abkhazia, a breakaway region of Georgia. An Estonian man Ivo has decided to stay behind and harvest his crops of tangerines. In a bloody conflict at his door, a wounded man is left behind, and Ivo takes him in.','2013','87 min',8.2,'Zaza Urushadze',40382),
('Bhaag Milkha Bhaag','Biography, Drama, Sport','The truth behind the ascension of Milkha Singh who was scarred because of the India-Pakistan partition.','2013','186 min',8.2,'Rakeysh Omprakash Mehra',61137);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Gangs of Wasseypur','Action, Comedy, Crime','A clash between Sultan and Shahid Khan leads to the expulsion of Khan from Wasseypur, and ignites a deadly blood feud spanning three generations.','2012','321 min',8.2,'Anurag Kashyap',82365),
('Udaan','Drama','Expelled from his school, a 16-year old boy returns home to his abusive and oppressive father.','2010','134 min',8.2,'Vikramaditya Motwane',42341),
('Paan Singh Tomar','Action, Biography, Crime','The story of Paan Singh Tomar, an Indian athlete and seven-time national steeplechase champion who becomes one of the most feared dacoits in Chambal Valley after his retirement.','2012','135 min',8.2,'Tigmanshu Dhulia',33237),
('El secreto de sus ojos','Drama, Mystery, Romance','A retired legal counselor writes a novel hoping to find closure for one of his past unresolved homicide cases and for his unreciprocated love with his superior - both of which still haunt him decades later.','2009','129 min',8.2,'Juan José Campanella',193217),
('Warrior','Action, Drama, Sport','The youngest son of an alcoholic former boxer returns home, where he''s trained by his father for competition in a mixed martial arts tournament - a path that puts the fighter on a collision course with his estranged, older brother.','2011','140 min',8.2,'Gavin O''Connor',435950),
('Shutter Island','Mystery, Thriller','In 1954, a U.S. Marshal investigates the disappearance of a murderer who escaped from a hospital for the criminally insane.','2010','138 min',8.2,'Martin Scorsese',1129894),
('Up','Animation, Adventure, Comedy','78-year-old Carl Fredricksen travels to Paradise Falls in his house equipped with balloons, inadvertently taking a young stowaway.','2009','96 min',8.2,'Pete Docter',935507),
('The Wolf of Wall Street','Biography, Crime, Drama','Based on the true story of Jordan Belfort, from his rise to a wealthy stock-broker living the high life to his fall involving crime, corruption and the federal government.','2013','180 min',8.2,'Martin Scorsese',1187498),
('Chak De! India','Drama, Family, Sport','Kabir Khan is the coach of the Indian Women''s National Hockey Team and his dream is to make his all girls team emerge victorious against all odds.','2007','153 min',8.2,'Shimit Amin',74129),
('There Will Be Blood','Drama','A story of family, religion, hatred, oil and madness, focusing on a turn-of-the-century prospector in the early days of the business.','2007','158 min',8.2,'Paul Thomas Anderson',517359);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Pan''s Labyrinth','Drama, Fantasy, War','In the Falangist Spain of 1944, the bookish young stepdaughter of a sadistic army officer escapes into an eerie but captivating fantasy world.','2006','118 min',8.2,'Guillermo del Toro',618623),
('Toy Story 3','Animation, Adventure, Comedy','The toys are mistakenly delivered to a day-care center instead of the attic right before Andy leaves for college, and it''s up to Woody to convince the other toys that they weren''t abandoned and to return home.','2010','103 min',8.2,'Lee Unkrich',757032),
('V for Vendetta','Action, Drama, Sci-Fi','In a future British tyranny, a shadowy freedom fighter, known only by the alias of "V", plots to overthrow it with the help of a young woman.','2005','132 min',8.2,'James McTeigue',1032749),
('Rang De Basanti','Comedy, Crime, Drama','The story of six young Indians who assist an English woman to film a documentary on the freedom fighters from their past, and the events that lead them to relive the long-forgotten saga of freedom.','2006','167 min',8.2,'Rakeysh Omprakash Mehra',111937),
('Black','Drama','The cathartic tale of a young woman who can''t see, hear or talk and the teacher who brings a ray of light into her dark world.','2005','122 min',8.2,'Sanjay Leela Bhansali',33354),
('Batman Begins','Action, Adventure','After training with his mentor, Batman begins his fight to free crime-ridden Gotham City from corruption.','2005','140 min',8.2,'Christopher Nolan',1308302),
('Swades: We, the People','Drama','A successful Indian scientist returns to an Indian village to take his nanny to America with him and in the process rediscovers his roots.','2004','210 min',8.2,'Ashutosh Gowariker',83005),
('Der Untergang','Biography, Drama, History','Traudl Junge, the final secretary for Adolf Hitler, tells of the Nazi dictator''s final days in his Berlin bunker at the end of WWII.','2004','156 min',8.2,'Oliver Hirschbiegel',331308),
('Hauru no ugoku shiro','Animation, Adventure, Family','When an unconfident young woman is cursed with an old body by a spiteful witch, her only chance of breaking the spell lies with a self-indulgent yet insecure young wizard and his companions in his legged, walking castle.','2004','119 min',8.2,'Hayao Miyazaki',333915),
('A Beautiful Mind','Biography, Drama','After John Nash, a brilliant but asocial mathematician, accepts secret work in cryptography, his life takes a turn for the nightmarish.','2001','135 min',8.2,'Ron Howard',848920);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Hera Pheri','Action, Comedy, Crime','Three unemployed men look for answers to all their money problems - but when their opportunity arrives, will they know what to do with it?','2000','156 min',8.2,'Priyadarshan',57057),
('Lock, Stock and Two Smoking Barrels','Action, Comedy, Crime','A botched card game in London triggers four friends, thugs, weed-growers, hard gangsters, loan sharks and debt collectors to collide with each other in a series of unexpected events, all for the sake of weed, cash and two antique shotguns.','1998','107 min',8.2,'Guy Ritchie',535216),
('L.A. Confidential','Crime, Drama, Mystery','As corruption grows in 1950s Los Angeles, three policemen - one strait-laced, one brutal, and one sleazy - investigate a series of murders with their own brand of justice.','1997','138 min',8.2,'Curtis Hanson',531967),
('Eskiya','Crime, Drama, Thriller','Baran the Bandit, released from prison after 35 years, searches for vengeance and his lover.','1996','128 min',8.2,'Yavuz Turgul',64118),
('Heat','Crime, Drama, Thriller','A group of professional bank robbers start to feel the heat from police when they unknowingly leave a clue at their latest heist.','1995','170 min',8.2,'Michael Mann',577113),
('Casino','Crime, Drama','A tale of greed, deception, money, power, and murder occur between two best friends: a mafia enforcer and a casino executive compete against each other over a gambling empire, and over a fast-living and fast-loving socialite.','1995','178 min',8.2,'Martin Scorsese',466276),
('Andaz Apna Apna','Action, Comedy, Romance','Two slackers competing for the affections of an heiress inadvertently become her protectors from an evil criminal.','1994','160 min',8.2,'Rajkumar Santoshi',49300),
('Unforgiven','Drama, Western','Retired Old West gunslinger William Munny reluctantly takes on one last job, with the help of his old partner Ned Logan and a young man, The "Schofield Kid."','1992','130 min',8.2,'Clint Eastwood',375935),
('Indiana Jones and the Last Crusade','Action, Adventure','In 1938, after his father Professor Henry Jones, Sr. goes missing while pursuing the Holy Grail, Professor Henry "Indiana" Jones, Jr. finds himself up against Adolf Hitler''s Nazis again to stop them from obtaining its powers.','1989','127 min',8.2,'Steven Spielberg',692366),
('Dom za vesanje','Comedy, Crime, Drama','In this luminous tale set in the area around Sarajevo and in Italy, Perhan, an engaging young Romany (gypsy) with telekinetic powers, is seduced by the quick-cash world of petty crime, which threatens to destroy him and those he loves.','1988','142 min',8.2,'Emir Kusturica',26402);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Tonari no Totoro','Animation, Family, Fantasy','When two girls move to the country to be near their ailing mother, they have adventures with the wondrous forest spirits who live nearby.','1988','86 min',8.2,'Hayao Miyazaki',291180),
('Die Hard','Action, Thriller','An NYPD officer tries to save his wife and several others taken hostage by German terrorists during a Christmas party at the Nakatomi Plaza in Los Angeles.','1988','132 min',8.2,'John McTiernan',793164),
('Ran','Action, Drama, War','In Medieval Japan, an elderly warlord retires, handing over his empire to his three sons. However, he vastly underestimates how the new-found power will corrupt them and cause them to turn on each other...and him.','1985','162 min',8.2,'Akira Kurosawa',112505),
('Raging Bull','Biography, Drama, Sport','The life of boxer Jake LaMotta, whose violence and temper that led him to the top in the ring destroyed his life outside of it.','1980','129 min',8.2,'Martin Scorsese',321860),
('Stalker','Drama, Sci-Fi','A guide leads two men through an area known as the Zone to find a room that grants wishes.','1979','162 min',8.2,'Andrei Tarkovsky',116945),
('Höstsonaten','Drama, Music','A married daughter who longs for her mother''s love is visited by the latter, a successful concert pianist.','1978','99 min',8.2,'Ingmar Bergman',26875),
('The Message','Biography, Drama, History','This epic historical drama chronicles the life and times of Prophet Muhammad and serves as an introduction to early Islamic history.','1976','177 min',8.2,'Moustapha Akkad',43885),
('Sholay','Action, Adventure, Comedy','After his family is murdered by a notorious and ruthless bandit, a former police officer enlists the services of two outlaws to capture the bandit.','1975','204 min',8.2,'Ramesh Sippy',51284),
('Monty Python and the Holy Grail','Adventure, Comedy, Fantasy','King Arthur and his Knights of the Round Table embark on a surreal, low-budget search for the Holy Grail, encountering many, very silly obstacles.','1975','91 min',8.2,'Terry Gilliam',500875),
('The Great Escape','Adventure, Drama, History','Allied prisoners of war plan for several hundred of their number to escape from a German camp during World War II.','1963','172 min',8.2,'John Sturges',224730);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('To Kill a Mockingbird','Crime, Drama','Atticus Finch, a lawyer in the Depression-era South, defends a black man against an undeserved rape charge, and his children against prejudice.','1962','129 min',8.2,'Robert Mulligan',293811),
('Yôjinbô','Action, Drama, Thriller','A crafty ronin comes to a town divided by two criminal gangs and decides to play them against each other to free the town.','1961','110 min',8.2,'Akira Kurosawa',111244),
('Judgment at Nuremberg','Drama, War','In 1948, an American court in occupied Germany tries four Nazis judged for war crimes.','1961','179 min',8.2,'Stanley Kramer',69458),
('Some Like It Hot','Comedy, Music, Romance','After two male musicians witness a mob hit, they flee the state in an all-female band disguised as women, but further complications set in.','1959','121 min',8.2,'Billy Wilder',243943),
('Smultronstället','Drama, Romance','After living a life marked by coldness, an aging professor is forced to confront the emptiness of his existence.','1957','91 min',8.2,'Ingmar Bergman',96381),
('Det sjunde inseglet','Drama, Fantasy, History','A man seeks answers about life, death, and the existence of God as he plays chess against the Grim Reaper during the Black Plague.','1957','96 min',8.2,'Ingmar Bergman',164939),
('Du rififi chez les hommes','Crime, Drama, Thriller','Four men plan a technically perfect crime, but the human element intervenes...','1955','118 min',8.2,'Jules Dassin',28810),
('Dial M for Murder','Crime, Thriller','A former tennis player tries to arrange his wife''s murder after learning of her affair.','1954','105 min',8.2,'Alfred Hitchcock',158335),
('Tôkyô monogatari','Drama','An old couple visit their children and grandchildren in the city, but receive little attention.','1953','136 min',8.2,'Yasujirô Ozu',53153),
('Rashômon','Crime, Drama, Mystery','The rape of a bride and the murder of her samurai husband are recalled from the perspectives of a bandit, the bride, the samurai''s ghost and a woodcutter.','1950','88 min',8.2,'Akira Kurosawa',152572);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('All About Eve','Drama','A seemingly timid but secretly ruthless ingénue insinuates herself into the lives of an aging Broadway star and her circle of theater friends.','1950','138 min',8.2,'Joseph L. Mankiewicz',120539),
('The Treasure of the Sierra Madre','Adventure, Drama, Western','Two Americans searching for work in Mexico convince an old prospector to help them mine for gold in the Sierra Madre Mountains.','1948','126 min',8.2,'John Huston',114304),
('To Be or Not to Be','Comedy, War','During the Nazi occupation of Poland, an acting troupe becomes embroiled in a Polish soldier''s efforts to track down a German spy.','1942','99 min',8.2,'Ernst Lubitsch',29915),
('The Gold Rush','Adventure, Comedy, Drama','A prospector goes to the Klondike in search of gold and finds it and more.','1925','95 min',8.2,'Charles Chaplin',101053),
('Sherlock Jr.','Action, Comedy, Romance','A film projectionist longs to be a detective, and puts his meagre skills to work when he is framed by a rival for stealing his girlfriend''s father''s pocketwatch.','1924','45 min',8.2,'Buster Keaton',41985),
('Portrait de la jeune fille en feu','Drama, Romance','On an isolated island in Brittany at the end of the eighteenth century, a female painter is obliged to paint a wedding portrait of a young woman.','2019','122 min',8.1,'Céline Sciamma',63134),
('Pink','Drama, Thriller','When three young women are implicated in a crime, a retired lawyer steps forward to help them clear their names.','2016','136 min',8.1,'Aniruddha Roy Chowdhury',39216),
('Koe no katachi','Animation, Drama, Family','A young man is ostracized by his classmates after he bullies a deaf girl to the point where she moves away. Years later, he sets off on a path for redemption.','2016','130 min',8.1,'Naoko Yamada',47708),
('Contratiempo','Crime, Drama, Mystery','A successful entrepreneur accused of murder and a witness preparation expert have less than three hours to come up with an impregnable defense.','2016','106 min',8.1,'Oriol Paulo',141516),
('Ah-ga-ssi','Drama, Romance, Thriller','A woman is hired as a handmaiden to a Japanese heiress, but secretly she is involved in a plot to defraud her.','2016','145 min',8.1,'Chan-wook Park',113649);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Mommy','Drama','A widowed single mother, raising her violent son alone, finds new hope when a mysterious neighbor inserts herself into their household.','2014','139 min',8.1,'Xavier Dolan',50700),
('Haider','Action, Crime, Drama','A young man returns to Kashmir after his father''s disappearance to confront his uncle, whom he suspects of playing a role in his father''s fate.','2014','160 min',8.1,'Vishal Bhardwaj',50445),
('Logan','Action, Drama, Sci-Fi','In a future where mutants are nearly extinct, an elderly and weary Logan leads a quiet life. But when Laura, a mutant child pursued by scientists, comes to him for help, he must get her to safety.','2017','137 min',8.1,'James Mangold',647884),
('Room','Drama, Thriller','Held captive for 7 years in an enclosed space, a woman and her young son finally gain their freedom, allowing the boy to experience the outside world for the first time.','2015','118 min',8.1,'Lenny Abrahamson',371538),
('Relatos salvajes','Comedy, Drama, Thriller','Six short stories that explore the extremities of human behavior involving people in distress.','2014','122 min',8.1,'Damián Szifron',177059),
('Soul','Animation, Adventure, Comedy','After landing the gig of a lifetime, a New York jazz pianist suddenly finds himself trapped in a strange land between Earth and the afterlife.','2020','100 min',8.1,'Pete Docter',159171),
('Kis Uykusu','Drama','A hotel owner and landlord in a remote Turkish village deals with conflicts within his family and a tenant behind on his rent.','2014','196 min',8.1,'Nuri Bilge Ceylan',46547),
('PK','Comedy, Drama, Musical','An alien on Earth loses the only device he can use to communicate with his spaceship. His innocent nature and child-like questions force the country to evaluate the impact of religion on its people.','2014','153 min',8.1,'Rajkumar Hirani',163061),
('OMG: Oh My God!','Comedy, Drama, Fantasy','A shopkeeper takes God to court when his shop is destroyed by an earthquake.','2012','125 min',8.1,'Umesh Shukla',51739),
('The Grand Budapest Hotel','Adventure, Comedy, Crime','A writer encounters the owner of an aging high-class hotel, who tells him of his early years serving as a lobby boy in the hotel''s glorious years under an exceptional concierge.','2014','99 min',8.1,'Wes Anderson',707630);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Gone Girl','Drama, Mystery, Thriller','With his wife''s disappearance having become the focus of an intense media circus, a man sees the spotlight turned on him when it''s suspected that he may not be innocent.','2014','149 min',8.1,'David Fincher',859695),
('Ôkami kodomo no Ame to Yuki','Animation, Drama, Fantasy','After her werewolf lover unexpectedly dies in an accident while hunting for food for their children, a young woman must find ways to raise the werewolf son and daughter that she had with him while keeping their trait hidden from society.','2012','117 min',8.1,'Mamoru Hosoda',38803),
('Hacksaw Ridge','Biography, Drama, History','World War II American Army Medic Desmond T. Doss, who served during the Battle of Okinawa, refuses to kill people, and becomes the first man in American history to receive the Medal of Honor without firing a shot.','2016','139 min',8.1,'Mel Gibson',435928),
('Inside Out','Animation, Adventure, Comedy','After young Riley is uprooted from her Midwest life and moved to San Francisco, her emotions - Joy, Fear, Anger, Disgust and Sadness - conflict on how best to navigate a new city, house, and school.','2015','95 min',8.1,'Pete Docter',616228),
('Barfi!','Comedy, Drama, Romance','Three young people learn that love can neither be defined nor contained by society''s definition of normal and abnormal.','2012','151 min',8.1,'Anurag Basu',75721),
('12 Years a Slave','Biography, Drama, History','In the antebellum United States, Solomon Northup, a free black man from upstate New York, is abducted and sold into slavery.','2013','134 min',8.1,'Steve McQueen',640533),
('Rush','Action, Biography, Drama','The merciless 1970s rivalry between Formula One rivals James Hunt and Niki Lauda.','2013','123 min',8.1,'Ron Howard',432811),
('Ford v Ferrari','Action, Biography, Drama','American car designer Carroll Shelby and driver Ken Miles battle corporate interference and the laws of physics to build a revolutionary race car for Ford in order to defeat Ferrari at the 24 Hours of Le Mans in 1966.','2019','152 min',8.1,'James Mangold',291289),
('Spotlight','Biography, Crime, Drama','The true story of how the Boston Globe uncovered the massive scandal of child molestation and cover-up within the local Catholic Archdiocese, shaking the entire Catholic Church to its core.','2015','129 min',8.1,'Tom McCarthy',420316),
('Song of the Sea','Animation, Adventure, Drama','Ben, a young Irish boy, and his little sister Saoirse, a girl who can turn into a seal, go on an adventure to free the fairies and save the spirit world.','2014','93 min',8.1,'Tomm Moore',51679);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Kahaani','Mystery, Thriller','A pregnant woman''s search for her missing husband takes her from London to Kolkata, but everyone she questions denies having ever met him.','2012','122 min',8.1,'Sujoy Ghosh',57806),
('Zindagi Na Milegi Dobara','Comedy, Drama','Three friends decide to turn their fantasy vacation into reality after one of their friends gets engaged.','2011','155 min',8.1,'Zoya Akhtar',67927),
('Prisoners','Crime, Drama, Mystery','When Keller Dover''s daughter and her friend go missing, he takes matters into his own hands as the police pursue multiple leads and the pressure mounts.','2013','153 min',8.1,'Denis Villeneuve',601149),
('Mad Max: Fury Road','Action, Adventure, Sci-Fi','In a post-apocalyptic wasteland, a woman rebels against a tyrannical ruler in search for her homeland with the aid of a group of female prisoners, a psychotic worshiper, and a drifter named Max.','2015','120 min',8.1,'George Miller',882316),
('A Wednesday','Action, Crime, Drama','A retiring police officer reminisces about the most astounding day of his career. About a case that was never filed but continues to haunt him in his memories - the case of a man and a Wednesday.','2008','104 min',8.1,'Neeraj Pandey',73891),
('Gran Torino','Drama','Disgruntled Korean War veteran Walt Kowalski sets out to reform his neighbor, Thao Lor, a Hmong teenager who tried to steal Kowalski''s prized possession: a 1972 Gran Torino.','2008','116 min',8.1,'Clint Eastwood',720450),
('Harry Potter and the Deathly Hallows: Part 2','Adventure, Drama, Fantasy','Harry, Ron, and Hermione search for Voldemort''s remaining Horcruxes in their effort to destroy the Dark Lord as the final battle rages on at Hogwarts.','2011','130 min',8.1,'David Yates',764493),
('Okuribito','Drama, Music','A newly unemployed cellist takes a job preparing the dead for funerals.','2008','130 min',8.1,'Yôjirô Takita',48582),
('Hachi: A Dog''s Tale','Biography, Drama, Family','A college professor bonds with an abandoned dog he takes into his home.','2009','93 min',8.1,'Lasse Hallström',253575),
('Mary and Max','Animation, Comedy, Drama','A tale of friendship between two unlikely pen pals: Mary, a lonely, eight-year-old girl living in the suburbs of Melbourne, and Max, a forty-four-year old, severely obese man living in New York.','2009','92 min',8.1,'Adam Elliot',164462);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('How to Train Your Dragon','Animation, Action, Adventure','A hapless young Viking who aspires to hunt dragons becomes the unlikely friend of a young dragon himself, and learns there may be more to the creatures than he assumed.','2010','98 min',8.1,'Dean DeBlois',666773),
('Into the Wild','Adventure, Biography, Drama','After graduating from Emory University, top student and athlete Christopher McCandless abandons his possessions, gives his entire $24,000 savings account to charity and hitchhikes to Alaska to live in the wilderness. Along the way, Christopher encounters a series of characters that shape his life.','2007','148 min',8.1,'Sean Penn',572921),
('No Country for Old Men','Crime, Drama, Thriller','Violence and mayhem ensue after a hunter stumbles upon a drug deal gone wrong and more than two million dollars in cash near the Rio Grande.','2007','122 min',8.1,'Ethan Coen',856916),
('Lage Raho Munna Bhai','Comedy, Drama, Romance','Munna Bhai embarks on a journey with Mahatma Gandhi in order to fight against a corrupt property dealer.','2006','144 min',8.1,'Rajkumar Hirani',43137),
('Million Dollar Baby','Drama, Sport','A determined woman works with a hardened boxing trainer to become a professional.','2004','132 min',8.1,'Clint Eastwood',635975),
('Hotel Rwanda','Biography, Drama, History','Paul Rusesabagina, a hotel manager, houses over a thousand Tutsi refugees during their struggle against the Hutu militia in Rwanda, Africa.','2004','121 min',8.1,'Terry George',334320),
('Taegukgi hwinalrimyeo','Action, Drama, War','When two brothers are forced to fight in the Korean War, the elder decides to take the riskiest missions if it will help shield the younger from battle.','2004','140 min',8.1,'Je-kyu Kang',37820),
('Before Sunset','Drama, Romance','Nine years after Jesse and Celine first met, they encounter each other again on the French leg of Jesse''s book tour.','2004','80 min',8.1,'Richard Linklater',236311),
('Munna Bhai M.B.B.S.','Comedy, Drama, Musical','A gangster sets out to fulfill his father''s dream of becoming a doctor.','2003','156 min',8.1,'Rajkumar Hirani',73992),
('Salinui chueok','Crime, Drama, Mystery','In a small Korean province in 1986, two detectives struggle with the case of multiple young women being found raped and murdered by an unknown culprit.','2003','131 min',8.1,'Bong Joon Ho',139558);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Dil Chahta Hai','Comedy, Drama, Romance','Three inseparable childhood friends are just out of college. Nothing comes between them - until they each fall in love, and their wildly different approaches to relationships creates tension.','2001','183 min',8.1,'Farhan Akhtar',66803),
('Kill Bill: Vol. 1','Action, Crime, Drama','After awakening from a four-year coma, a former assassin wreaks vengeance on the team of assassins who betrayed her.','2003','111 min',8.1,'Quentin Tarantino',1000639),
('Finding Nemo','Animation, Adventure, Comedy','After his son is captured in the Great Barrier Reef and taken to Sydney, a timid clownfish sets out on a journey to bring him home.','2003','100 min',8.1,'Andrew Stanton',949565),
('Catch Me If You Can','Biography, Crime, Drama','Barely 21 yet, Frank is a skilled forger who has passed as a doctor, lawyer and pilot. FBI agent Carl becomes obsessed with tracking down the con man, who only revels in the pursuit.','2002','141 min',8.1,'Steven Spielberg',832846),
('Amores perros','Drama, Thriller','A horrific car accident connects three stories, each involving characters dealing with loss, regret, and life''s harsh realities, all in the name of love.','2000','154 min',8.1,'Alejandro G. Iñárritu',223741),
('Monsters, Inc.','Animation, Adventure, Comedy','In order to power the city, monsters have to scare children so that they scream. However, the children are toxic to the monsters, and after a child gets through, 2 monsters realize things may not be what they think.','2001','92 min',8.1,'Pete Docter',815505),
('Shin seiki Evangelion Gekijô-ban: Air/Magokoro wo, kimi ni','Animation, Action, Drama','Concurrent theatrical ending of the TV series Shin seiki evangerion (1995).','1997','87 min',8.1,'Hideaki Anno',38847),
('Lagaan: Once Upon a Time in India','Adventure, Drama, Musical','The people of a small village in Victorian India stake their future on a game of cricket against their ruthless British rulers.','2001','224 min',8.1,'Ashutosh Gowariker',105036),
('The Sixth Sense','Drama, Mystery, Thriller','A boy who communicates with spirits seeks the help of a disheartened child psychologist.','1999','107 min',8.1,'M. Night Shyamalan',911573),
('La leggenda del pianista sull''oceano','Drama, Music, Romance','A baby boy, discovered in 1900 on an ocean liner, grows into a musical prodigy, never setting foot on land.','1998','169 min',8.1,'Giuseppe Tornatore',59020);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('The Truman Show','Comedy, Drama','An insurance salesman discovers his whole life is actually a reality TV show.','1998','103 min',8.1,'Peter Weir',939631),
('Crna macka, beli macor','Comedy, Crime, Romance','Matko and his son Zare live on the banks of the Danube river and get by through hustling and basically doing anything to make a living. In order to pay off a business debt Matko agrees to marry off Zare to the sister of a local gangster.','1998','127 min',8.1,'Emir Kusturica',50862),
('The Big Lebowski','Comedy, Crime, Sport','Jeff "The Dude" Lebowski, mistaken for a millionaire of the same name, seeks restitution for his ruined rug and enlists his bowling buddies to help get it.','1998','117 min',8.1,'Joel Coen',732620),
('Fa yeung nin wah','Drama, Romance','Two neighbors, a woman and a man, form a strong bond after both suspect extramarital activities of their spouses. However, they agree to keep their bond platonic so as not to commit similar wrongs.','2000','98 min',8.1,'Kar-Wai Wong',124383),
('Trainspotting','Drama','Renton, deeply immersed in the Edinburgh drug scene, tries to clean up and get out, despite the allure of the drugs and influence of friends.','1996','93 min',8.1,'Danny Boyle',634716),
('Fargo','Crime, Drama, Thriller','Jerry Lundegaard''s inept crime falls apart due to his and his henchmen''s bungling and the persistent police work of the quite pregnant Marge Gunderson.','1996','98 min',8.1,'Joel Coen',617444),
('Underground','Comedy, Drama, War','A group of Serbian socialists prepares for the war in a surreal underground filled by parties, tragedies, love and hate.','1995','170 min',8.1,'Emir Kusturica',55220),
('La haine','Crime, Drama','24 hours in the lives of three young men in the French suburbs the day after a violent riot.','1995','98 min',8.1,'Mathieu Kassovitz',150345),
('Dilwale Dulhania Le Jayenge','Drama, Romance','When Raj meets Simran in Europe, it isn''t love at first sight but when Simran moves to India for an arranged marriage, love makes its presence felt.','1995','189 min',8.1,'Aditya Chopra',63516),
('Before Sunrise','Drama, Romance','A young man and woman meet on a train in Europe, and wind up spending one evening together in Vienna. Unfortunately, both know that this will probably be their only night together.','1995','101 min',8.1,'Richard Linklater',272291);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Trois couleurs: Rouge','Drama, Mystery, Romance','A model discovers a retired judge is keen on invading people''s privacy.','1994','99 min',8.1,'Krzysztof Kieslowski',90729),
('Chung Hing sam lam','Comedy, Crime, Drama','Two melancholy Hong Kong policemen fall in love: one with a mysterious female underworld figure, the other with a beautiful and ethereal server at a late-night restaurant he frequents.','1994','102 min',8.1,'Kar-Wai Wong',63122),
('Jurassic Park','Action, Adventure, Sci-Fi','A pragmatic paleontologist visiting an almost complete theme park is tasked with protecting a couple of kids after a power failure causes the park''s cloned dinosaurs to run loose.','1993','127 min',8.1,'Steven Spielberg',867615),
('In the Name of the Father','Biography, Crime, Drama','A man''s coerced confession to an I.R.A. bombing he did not commit results in the imprisonment of his father as well. An English lawyer fights to free them.','1993','133 min',8.1,'Jim Sheridan',156842),
('Ba wang bie ji','Drama, Music, Romance','Two boys meet at an opera training school in Peking in 1924. Their resulting friendship will span nearly 70 years and will endure some of the most troublesome times in China''s history.','1993','171 min',8.1,'Kaige Chen',25088),
('Dà hóng denglong gaogao guà','Drama, History, Romance','A young woman becomes the fourth wife of a wealthy lord, and must learn to live with the strict rules and tensions within the household.','1991','125 min',8.1,'Yimou Zhang',29662),
('Dead Poets Society','Comedy, Drama','Maverick teacher John Keating uses poetry to embolden his boarding school students to new heights of self-expression.','1989','128 min',8.1,'Peter Weir',425457),
('Stand by Me','Adventure, Drama','After the death of one of his friends, a writer recounts a childhood journey with his friends to find the body of a missing boy.','1986','89 min',8.1,'Rob Reiner',363401),
('Platoon','Drama, War','Chris Taylor, a neophyte recruit in Vietnam, finds himself caught in a battle of wills between two sergeants, one good and the other evil. A shrewd examination of the brutality of war and the duality of man in conflict.','1986','120 min',8.1,'Oliver Stone',381222),
('Paris, Texas','Drama','Travis Henderson, an aimless drifter who has been missing for four years, wanders out of the desert and must reconnect with society, himself, his life, and his family.','1984','145 min',8.1,'Wim Wenders',91188);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Kaze no tani no Naushika','Animation, Adventure, Fantasy','Warrior and pacifist Princess Nausicaä desperately struggles to prevent two warring nations from destroying themselves and their dying planet.','1984','117 min',8.1,'Hayao Miyazaki',150924),
('The Thing','Horror, Mystery, Sci-Fi','A research team in Antarctica is hunted by a shape-shifting alien that assumes the appearance of its victims.','1982','109 min',8.1,'John Carpenter',371271),
('Pink Floyd: The Wall','Drama, Fantasy, Music','A confined but troubled rock star descends into madness in the midst of his physical and social isolation from everyone.','1982','95 min',8.1,'Alan Parker',76081),
('Fitzcarraldo','Adventure, Drama','The story of Brian Sweeney Fitzgerald, an extremely determined man who intends to build an opera house in the middle of a jungle.','1982','158 min',8.1,'Werner Herzog',31595),
('Fanny och Alexander','Drama','Two young Swedish children experience the many comedies and tragedies of their family, the Ekdahls.','1982','188 min',8.1,'Ingmar Bergman',57784),
('Blade Runner','Action, Sci-Fi, Thriller','A blade runner must pursue and terminate four replicants who stole a ship in space, and have returned to Earth to find their creator.','1982','117 min',8.1,'Ridley Scott',693827),
('The Elephant Man','Biography, Drama','A Victorian surgeon rescues a heavily disfigured man who is mistreated while scraping a living as a side-show freak. Behind his monstrous façade, there is revealed a person of kindness, intelligence and sophistication.','1980','124 min',8.1,'David Lynch',220078),
('Life of Brian','Comedy','Born on the original Christmas in the stable next door to Jesus Christ, Brian of Nazareth spends his life being mistaken for a messiah.','1979','94 min',8.1,'Terry Jones',367250),
('The Deer Hunter','Drama, War','An in-depth examination of the ways in which the U.S. Vietnam War impacts and disrupts the lives of people in a small industrial town in Pennsylvania.','1978','183 min',8.1,'Michael Cimino',311361),
('Rocky','Drama, Sport','A small-time boxer gets a supremely rare chance to fight a heavy-weight champion in a bout in which he strives to go the distance for his self-respect.','1976','120 min',8.1,'John G. Avildsen',518546);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Network','Drama','A television network cynically exploits a deranged former anchor''s ravings and revelations about the news media for its own profit.','1976','121 min',8.1,'Sidney Lumet',144911),
('Barry Lyndon','Adventure, Drama, History','An Irish rogue wins the heart of a rich widow and assumes her dead husband''s aristocratic position in 18th-century England.','1975','185 min',8.1,'Stanley Kubrick',149843),
('Zerkalo','Biography, Drama','A dying man in his forties remembers his past. His childhood, his mother, the war, personal moments and things that tell of the recent history of all the Russian nation.','1975','107 min',8.1,'Andrei Tarkovsky',40081),
('Chinatown','Drama, Mystery, Thriller','A private detective hired to expose an adulterer finds himself caught up in a web of deceit, corruption, and murder.','1974','130 min',8.1,'Roman Polanski',294230),
('Paper Moon','Comedy, Crime, Drama','During the Great Depression, a con man finds himself saddled with a young girl who may or may not be his daughter, and the two forge an unlikely partnership.','1973','102 min',8.1,'Peter Bogdanovich',42285),
('Viskningar och rop','Drama','When a woman dying of cancer in early twentieth-century Sweden is visited by her two sisters, long-repressed feelings between the siblings rise to the surface.','1972','91 min',8.1,'Ingmar Bergman',30206),
('Solaris','Drama, Mystery, Sci-Fi','A psychologist is sent to a station orbiting a distant planet in order to discover what has caused the crew to go insane.','1972','167 min',8.1,'Andrei Tarkovsky',81021),
('Le samouraï','Crime, Drama, Mystery','After professional hitman Jef Costello is seen by witnesses his efforts to provide himself an alibi drive him further into a corner.','1967','105 min',8.1,'Jean-Pierre Melville',45434),
('Cool Hand Luke','Crime, Drama','A laid back Southern man is sentenced to two years in a rural prison, but refuses to conform.','1967','127 min',8.1,'Stuart Rosenberg',161984),
('Persona','Drama, Thriller','A nurse is put in charge of a mute actress and finds that their personae are melding together.','1966','85 min',8.1,'Ingmar Bergman',103191);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Andrei Rublev','Biography, Drama, History','The life, times and afflictions of the fifteenth-century Russian iconographer St. Andrei Rublev.','1966','205 min',8.1,'Andrei Tarkovsky',46947),
('La battaglia di Algeri','Drama, War','In the 1950s, fear and violence escalate as the people of Algiers fight for independence from the French government.','1966','121 min',8.1,'Gillo Pontecorvo',53089),
('El ángel exterminador','Drama, Fantasy','The guests at an upper-class dinner party find themselves unable to leave.','1962','95 min',8.1,'Luis Buñuel',29682),
('What Ever Happened to Baby Jane?','Drama, Horror, Thriller','A former child star torments her paraplegic sister in their decaying Hollywood mansion.','1962','134 min',8.1,'Robert Aldrich',50058),
('Sanjuro','Action, Comedy, Crime','A crafty samurai helps a young man and his fellow clansmen save his uncle, who has been framed and imprisoned by a corrupt superintendent.','1962','96 min',8.1,'Akira Kurosawa',33044),
('The Man Who Shot Liberty Valance','Drama, Western','A senator returns to a western town for the funeral of an old friend and tells the story of his origins.','1962','123 min',8.1,'John Ford',68827),
('Ivanovo detstvo','Drama, War','In WW2, twelve year old Soviet orphan Ivan Bondarev works for the Soviet army as a scout behind the German lines and strikes a friendship with three sympathetic Soviet officers.','1962','95 min',8.1,'Andrei Tarkovsky',31728),
('Jungfrukällan','Drama','An innocent yet pampered young virgin and her family''s pregnant and jealous servant set out to deliver candles to church, but only one returns from events that transpire in the woods along the way.','1960','89 min',8.1,'Ingmar Bergman',26697),
('Inherit the Wind','Biography, Drama, History','Based on a real-life case in 1925, two great lawyers argue the case for and against a science teacher accused of the crime of teaching evolution.','1960','128 min',8.1,'Stanley Kramer',27254),
('Les quatre cents coups','Crime, Drama','A young boy, left without attention, delves into a life of petty crime.','1959','99 min',8.1,'François Truffaut',105291);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Ben-Hur','Adventure, Drama, History','After a Jewish prince is betrayed and sent into slavery by a Roman friend, he regains his freedom and comes back for revenge.','1959','212 min',8.1,'William Wyler',219466),
('Kakushi-toride no san-akunin','Adventure, Drama','Lured by gold, two greedy peasants unknowingly escort a princess and her general across enemy lines.','1958','139 min',8.1,'Akira Kurosawa',34797),
('Le notti di Cabiria','Drama','A waifish prostitute wanders the streets of Rome looking for true love but finds only heartbreak.','1957','110 min',8.1,'Federico Fellini',42940),
('Kumonosu-jô','Drama, History','A war-hardened general, egged on by his ambitious wife, works to fulfill a prophecy that he would become lord of Spider''s Web Castle.','1957','110 min',8.1,'Akira Kurosawa',46678),
('The Bridge on the River Kwai','Adventure, Drama, War','British POWs are forced to build a railway bridge across the river Kwai for their Japanese captors, not knowing that the allied forces are planning to destroy it.','1957','161 min',8.1,'David Lean',203463),
('On the Waterfront','Crime, Drama, Thriller','An ex-prize fighter turned longshoreman struggles to stand up to his corrupt union bosses.','1954','108 min',8.1,'Elia Kazan',142107),
('Le salaire de la peur','Adventure, Drama, Thriller','In a decrepit South American village, four men are hired to transport an urgent nitroglycerine shipment without the equipment that would make it safe.','1953','131 min',8.1,'Henri-Georges Clouzot',54588),
('Ace in the Hole','Drama, Film-Noir','A frustrated former big-city journalist now stuck working for an Albuquerque newspaper exploits a story about a man trapped in a cave to rekindle his career, but the situation quickly escalates into an out-of-control circus.','1951','111 min',8.1,'Billy Wilder',31568),
('White Heat','Action, Crime, Drama','A psychopathic criminal with a mother complex makes a daring break from prison and leads his old gang in a chemical plant payroll heist.','1949','114 min',8.1,'Raoul Walsh',29807),
('The Third Man','Film-Noir, Mystery, Thriller','Pulp novelist Holly Martins travels to shadowy, postwar Vienna, only to find himself investigating the mysterious death of an old friend, Harry Lime.','1949','104 min',8.1,'Carol Reed',158731);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('The Red Shoes','Drama, Music, Romance','A young ballet dancer is torn between the man she loves and her pursuit to become a prima ballerina.','1948','135 min',8.1,'Michael Powell',30935),
('The Shop Around the Corner','Comedy, Drama, Romance','Two employees at a gift shop can barely stand each other, without realizing that they are falling in love through the post as each other''s anonymous pen pal.','1940','99 min',8.1,'Ernst Lubitsch',28450),
('Rebecca','Drama, Mystery, Romance','A self-conscious woman juggles adjusting to her new role as an aristocrat''s wife and avoiding being intimidated by his first wife''s spectral presence.','1940','130 min',8.1,'Alfred Hitchcock',123942),
('Mr. Smith Goes to Washington','Comedy, Drama','A naive man is appointed to fill a vacancy in the United States Senate. His plans promptly collide with political corruption, but he doesn''t back down.','1939','129 min',8.1,'Frank Capra',107017),
('Gone with the Wind','Drama, History, Romance','A manipulative woman and a roguish man conduct a turbulent romance during the American Civil War and Reconstruction periods.','1939','238 min',8.1,'Victor Fleming',290074),
('La Grande Illusion','Drama, War','During WWI, two French soldiers are captured and imprisoned in a German P.O.W. camp. Several escape attempts follow until they are eventually sent to a seemingly inescapable fortress.','1937','113 min',8.1,'Jean Renoir',33829),
('It Happened One Night','Comedy, Romance','A renegade reporter and a crazy young heiress meet on a bus heading for New York, and end up stuck with each other when the bus leaves them behind at one of the stops.','1934','105 min',8.1,'Frank Capra',94016),
('La passion de Jeanne d''Arc','Biography, Drama, History','In 1431, Jeanne d''Arc is placed on trial on charges of heresy. The ecclesiastical jurists attempt to force Jeanne to recant her claims of holy visions.','1928','110 min',8.1,'Carl Theodor Dreyer',47676),
('The Circus','Comedy, Romance','The Tramp finds work and the girl of his dreams at a circus.','1928','72 min',8.1,'Charles Chaplin',30205),
('Sunrise: A Song of Two Humans','Drama, Romance','An allegorical tale about a man fighting the good and evil within him. Both sides are made flesh - one a sophisticated woman he is attracted to and the other his wife.','1927','94 min',8.1,'F.W. Murnau',46865);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('The General','Action, Adventure, Comedy','When Union spies steal an engineer''s beloved locomotive, he pursues it single-handedly and straight through enemy lines.','1926','67 min',8.1,'Clyde Bruckman',81156),
('Das Cabinet des Dr. Caligari','Fantasy, Horror, Mystery','Hypnotist Dr. Caligari uses a somnambulist, Cesare, to commit murders.','1920','76 min',8.1,'Robert Wiene',57428),
('Badhaai ho','Comedy, Drama','A man is embarrassed when he finds out his mother is pregnant.','2018','124 min',8.0,'Amit Ravindernath Sharma',27978),
('Togo','Adventure, Biography, Drama','The story of Togo, the sled dog who led the 1925 serum run yet was considered by most to be too small and weak to lead such an intense race.','2019','113 min',8.0,'Ericson Core',37556),
('Airlift','Drama, History','When Iraq invades Kuwait in August 1990, a callous Indian businessman becomes the spokesperson for more than 170,000 stranded countrymen.','2016','130 min',8.0,'Raja Menon',52897),
('Bajrangi Bhaijaan','Action, Adventure, Comedy','An Indian man with a magnanimous heart takes a young mute Pakistani girl back to her homeland to reunite her with her family.','2015','163 min',8.0,'Kabir Khan',72245),
('Baby','Action, Crime, Thriller','An elite counter-intelligence unit learns of a plot, masterminded by a maniacal madman. With the clock ticking, it''s up to them to track the terrorists'' international tentacles and prevent them from striking at the heart of India.','2015','159 min',8.0,'Neeraj Pandey',52848),
('La La Land','Comedy, Drama, Music','While navigating their careers in Los Angeles, a pianist and an actress fall in love while attempting to reconcile their aspirations for the future.','2016','128 min',8.0,'Damien Chazelle',505918),
('Lion','Biography, Drama','A five-year-old Indian boy is adopted by an Australian couple after getting lost hundreds of kilometers from home. 25 years later, he sets out to find his lost family.','2016','118 min',8.0,'Garth Davis',213970),
('The Martian','Adventure, Drama, Sci-Fi','An astronaut becomes stranded on Mars after his team assume him dead, and must rely on his ingenuity to find a way to signal to Earth that he is alive.','2015','144 min',8.0,'Ridley Scott',760094);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Zootopia','Animation, Adventure, Comedy','In a city of anthropomorphic animals, a rookie bunny cop and a cynical con artist fox must work together to uncover a conspiracy.','2016','108 min',8.0,'Byron Howard',434143),
('Bãhubali: The Beginning','Action, Drama','In ancient India, an adventurous and daring man becomes involved in a decades-old feud between two warring peoples.','2015','159 min',8.0,'S.S. Rajamouli',102972),
('Kaguyahime no monogatari','Animation, Adventure, Drama','Found inside a shining stalk of bamboo by an old bamboo cutter and his wife, a tiny girl grows rapidly into an exquisite young lady. The mysterious young princess enthralls all who encounter her, but ultimately she must confront her fate, the punishment for her crime.','2013','137 min',8.0,'Isao Takahata',38746),
('Wonder','Drama, Family','Based on the New York Times bestseller, this movie tells the incredibly inspiring and heartwarming story of August Pullman, a boy with facial differences who enters the fifth grade, attending a mainstream elementary school for the first time.','2017','113 min',8.0,'Stephen Chbosky',141923),
('Gully Boy','Drama, Music, Romance','A coming-of-age story based on the lives of street rappers in Mumbai.','2019','154 min',8.0,'Zoya Akhtar',31886),
('Special Chabbis','Crime, Drama, Thriller','A gang of con-men rob prominent rich businessmen and politicians by posing as C.B.I and income tax officers.','2013','144 min',8.0,'Neeraj Pandey',51069),
('Short Term 12','Drama','A 20-something supervising staff member of a residential treatment facility navigates the troubled waters of that world alongside her co-worker and longtime boyfriend.','2013','96 min',8.0,'Destin Daniel Cretton',81770),
('Serbuan maut 2: Berandal','Action, Crime, Thriller','Only a short time after the first raid, Rama goes undercover with the thugs of Jakarta and plans to bring down the syndicate and uncover the corruption within his police force.','2014','150 min',8.0,'Gareth Evans',114316),
('The Imitation Game','Biography, Drama, Thriller','During World War II, the English mathematical genius Alan Turing tries to crack the German Enigma code with help from fellow mathematicians.','2014','114 min',8.0,'Morten Tyldum',685201),
('Guardians of the Galaxy','Action, Adventure, Comedy','A group of intergalactic criminals must pull together to stop a fanatical warrior with plans to purge the universe.','2014','121 min',8.0,'James Gunn',1043455);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Blade Runner 2049','Action, Drama, Mystery','Young Blade Runner K''s discovery of a long-buried secret leads him to track down former Blade Runner Rick Deckard, who''s been missing for thirty years.','2017','164 min',8.0,'Denis Villeneuve',461823),
('Her','Drama, Romance, Sci-Fi','In a near future, a lonely writer develops an unlikely relationship with an operating system designed to meet his every need.','2013','126 min',8.0,'Spike Jonze',540772),
('Bohemian Rhapsody','Biography, Drama, Music','The story of the legendary British rock band Queen and lead singer Freddie Mercury, leading up to their famous performance at Live Aid (1985).','2018','134 min',8.0,'Bryan Singer',450349),
('The Revenant','Action, Adventure, Drama','A frontiersman on a fur trading expedition in the 1820s fights for survival after being mauled by a bear and left for dead by members of his own hunting team.','2015','156 min',8.0,'Alejandro G. Iñárritu',705589),
('The Perks of Being a Wallflower','Drama, Romance','An introvert freshman is taken under the wings of two seniors who welcome him to the real world','2012','103 min',8.0,'Stephen Chbosky',462252),
('Tropa de Elite 2: O Inimigo Agora é Outro','Action, Crime, Drama','After a prison riot, former-Captain Nascimento, now a high ranking security officer in Rio de Janeiro, is swept into a bloody political dispute that involves government officials and paramilitary groups.','2010','115 min',8.0,'José Padilha',79200),
('The King''s Speech','Biography, Drama, History','The story of King George VI, his impromptu ascension to the throne of the British Empire in 1936, and the speech therapist who helped the unsure monarch overcome his stammer.','2010','118 min',8.0,'Tom Hooper',639603),
('The Help','Drama','An aspiring author during the civil rights movement of the 1960s decides to write a book detailing the African American maids'' point of view on the white families for which they work, and the hardships they go through on a daily basis.','2011','146 min',8.0,'Tate Taylor',428521),
('Deadpool','Action, Adventure, Comedy','A wisecracking mercenary gets experimented on and becomes immortal but ugly, and sets out to track down the man who ruined his looks.','2016','108 min',8.0,'Tim Miller',902669),
('Darbareye Elly','Drama, Mystery','The mysterious disappearance of a kindergarten teacher during a picnic in the north of Iran is followed by a series of misadventures for her fellow travelers.','2009','119 min',8.0,'Asghar Farhadi',45803);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Dev.D','Drama, Romance','After breaking up with his childhood sweetheart, a young man finds solace in drugs. Meanwhile, a teenage girl is caught in the world of prostitution. Will they be destroyed, or will they find redemption?','2009','144 min',8.0,'Anurag Kashyap',28749),
('Yip Man','Action, Biography, Drama','During the Japanese invasion of China, a wealthy martial artist is forced to leave his home when his city is occupied. With little means of providing for themselves, Ip Man and the remaining members of the city must find a way to survive.','2008','106 min',8.0,'Wilson Yip',211427),
('My Name Is Khan','Drama','An Indian Muslim man with Asperger''s syndrome takes a challenge to speak to the President of the United States seriously and embarks on a cross-country journey.','2010','165 min',8.0,'Karan Johar',98575),
('Nefes: Vatan Sagolsun','Action, Drama, Thriller','Story of 40-man Turkish task force who must defend a relay station.','2009','128 min',8.0,'Levent Semerci',31838),
('Slumdog Millionaire','Drama, Romance','A Mumbai teenager reflects on his life after being accused of cheating on the Indian version of "Who Wants to be a Millionaire?".','2008','120 min',8.0,'Danny Boyle',798882),
('Black Swan','Drama, Thriller','A committed dancer struggles to maintain her sanity after winning the lead role in a production of Tchaikovsky''s "Swan Lake".','2010','108 min',8.0,'Darren Aronofsky',699673),
('Tropa de Elite','Action, Crime, Drama','In 1997 Rio de Janeiro, Captain Nascimento has to find a substitute for his position while trying to take down drug dealers and criminals before the Pope visits.','2007','115 min',8.0,'José Padilha',98097),
('The Avengers','Action, Adventure, Sci-Fi','Earth''s mightiest heroes must come together and learn to fight as a team if they are going to stop the mischievous Loki and his alien army from enslaving humanity.','2012','143 min',8.0,'Joss Whedon',1260806),
('Persepolis','Animation, Biography, Drama','A precocious and outspoken Iranian girl grows up during the Islamic Revolution.','2007','96 min',8.0,'Vincent Paronnaud',88656),
('Dallas Buyers Club','Biography, Drama','In 1985 Dallas, electrician and hustler Ron Woodroof works around the system to help AIDS patients get the medication they need after he is diagnosed with the disease.','2013','117 min',8.0,'Jean-Marc Vallée',441614);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('The Pursuit of Happyness','Biography, Drama','A struggling salesman takes custody of his son as he''s poised to begin a life-changing professional career.','2006','117 min',8.0,'Gabriele Muccino',448930),
('Blood Diamond','Adventure, Drama, Thriller','A fisherman, a smuggler, and a syndicate of businessmen match wits over the possession of a priceless diamond.','2006','143 min',8.0,'Edward Zwick',499439),
('The Bourne Ultimatum','Action, Mystery, Thriller','Jason Bourne dodges a ruthless C.I.A. official and his Agents from a new assassination program while searching for the origins of his life as a trained killer.','2007','115 min',8.0,'Paul Greengrass',604694),
('Bin-jip','Crime, Drama, Romance','A transient young man breaks into empty homes to partake of the vacationing residents'' lives for a few days.','2004','88 min',8.0,'Ki-duk Kim',50610),
('Sin City','Crime, Thriller','A movie that explores the dark and miserable town, Basin City, tells the story of three different people, all caught up in violent corruption.','2005','124 min',8.0,'Frank Miller',738512),
('Le scaphandre et le papillon','Biography, Drama','The true story of Elle editor Jean-Dominique Bauby who suffers a stroke and has to live with an almost totally paralyzed body; only his left eye isn''t paralyzed.','2007','112 min',8.0,'Julian Schnabel',103284),
('G.O.R.A.','Adventure, Comedy, Sci-Fi','A slick young Turk kidnapped by extraterrestrials shows his great « humanitarian spirit » by outwitting the evil commander-in-chief of the planet of G.O.R.A.','2004','127 min',8.0,'Ömer Faruk Sorak',56960),
('Ratatouille','Animation, Adventure, Comedy','A rat who can cook makes an unusual alliance with a young kitchen worker at a famous restaurant.','2007','111 min',8.0,'Brad Bird',641645),
('Casino Royale','Action, Adventure, Thriller','After earning 00 status and a licence to kill, Secret Agent James Bond sets out on his first mission as 007. Bond must defeat a private banker funding terrorists in a high-stakes game of poker at Casino Royale, Montenegro.','2006','144 min',8.0,'Martin Campbell',582239),
('Kill Bill: Vol. 2','Action, Crime, Thriller','The Bride continues her quest of vengeance against her former boss and lover Bill, the reclusive bouncer Budd, and the treacherous, one-eyed Elle.','2004','137 min',8.0,'Quentin Tarantino',683900);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Vozvrashchenie','Drama','In the Russian wilderness, two brothers face a range of new, conflicting emotions when their father - a man they know only through a single photograph - resurfaces.','2003','110 min',8.0,'Andrey Zvyagintsev',42399),
('Bom Yeoareum Gaeul Gyeoul Geurigo Bom','Drama, Romance','A boy is raised by a Buddhist monk in an isolated floating temple where the years pass like the seasons.','2003','103 min',8.0,'Ki-duk Kim',77520),
('Mar adentro','Biography, Drama','The factual story of Spaniard Ramon Sampedro, who fought a thirty-year campaign in favor of euthanasia and his own right to die.','2014','126 min',8.0,'Alejandro Amenábar',77554),
('Cinderella Man','Biography, Drama, History','The story of James J. Braddock, a supposedly washed-up boxer who came back to become a champion and an inspiration in the 1930s.','2005','144 min',8.0,'Ron Howard',176151),
('Kal Ho Naa Ho','Comedy, Drama, Musical','Naina, an introverted, perpetually depressed girl''s life changes when she meets Aman. But Aman has a secret of his own which changes their lives forever. Embroiled in all this is Rohit, Naina''s best friend who conceals his love for her.','2003','186 min',8.0,'Nikkhil Advani',63460),
('Mou gaan dou','Action, Crime, Drama','A story between a mole in the police department and an undercover cop. Their objectives are the same: to find out who is the mole, and who is the cop.','2002','101 min',8.0,'Andrew Lau',117857),
('Pirates of the Caribbean: The Curse of the Black Pearl','Action, Adventure, Fantasy','Blacksmith Will Turner teams up with eccentric pirate "Captain" Jack Sparrow to save his love, the governor''s daughter, from Jack''s former pirate allies, who are now undead.','2003','143 min',8.0,'Gore Verbinski',1015122),
('Big Fish','Adventure, Drama, Fantasy','A frustrated son tries to determine the fact from fiction in his dying father''s life.','2003','125 min',8.0,'Tim Burton',415218),
('The Incredibles','Animation, Action, Adventure','A family of undercover superheroes, while trying to live the quiet suburban life, are forced into action to save the world.','2004','115 min',8.0,'Brad Bird',657047),
('Yeopgijeogin geunyeo','Comedy, Drama, Romance','A young man sees a drunk, cute woman standing too close to the tracks at a metro station in Seoul and pulls her back. She ends up getting him into trouble repeatedly after that, starting on the train.','2001','137 min',8.0,'Jae-young Kwak',45403);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Dogville','Crime, Drama','A woman on the run from the mob is reluctantly accepted in a small Colorado community in exchange for labor, but when a search visits the town she finds out that their support has a price.','2003','178 min',8.0,'Lars von Trier',137963),
('Vizontele','Comedy, Drama','Lives of residents in a small Anatolian village change when television is introduced to them','2001','110 min',8.0,'Yilmaz Erdogan',33592),
('Donnie Darko','Drama, Mystery, Sci-Fi','After narrowly escaping a bizarre accident, a troubled teenager is plagued by visions of a man in a large rabbit suit who manipulates him to commit a series of crimes.','2001','113 min',8.0,'Richard Kelly',740086),
('Magnolia','Drama','An epic mosaic of interrelated characters in search of love, forgiveness, and meaning in the San Fernando Valley.','1999','188 min',8.0,'Paul Thomas Anderson',289742),
('Dancer in the Dark','Crime, Drama, Musical','An East European girl travels to the United States with her young son, expecting it to be like a Hollywood film.','2000','140 min',8.0,'Lars von Trier',102285),
('The Straight Story','Biography, Drama','An old man makes a long journey by lawnmower to mend his relationship with an ill brother.','1999','112 min',8.0,'David Lynch',82002),
('Pâfekuto burû','Animation, Crime, Mystery','A pop singer gives up her career to become an actress, but she slowly goes insane when she starts being stalked by an obsessed fan and what seems to be a ghost of her past.','1997','81 min',8.0,'Satoshi Kon',58192),
('Festen','Drama','At Helge''s 60th birthday party, some unpleasant family truths are revealed.','1998','105 min',8.0,'Thomas Vinterberg',78341),
('Central do Brasil','Drama','An emotive journey of a former school teacher, who writes letters for illiterate people, and a young boy, whose mother has just died, as they search for the father he never knew.','1998','110 min',8.0,'Walter Salles',36419),
('The Iron Giant','Animation, Action, Adventure','A young boy befriends a giant robot from outer space that a paranoid government agent wants to destroy.','1999','86 min',8.0,'Brad Bird',172083);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Knockin'' on Heaven''s Door','Action, Crime, Comedy','Two terminally ill patients escape from a hospital, steal a car and rush towards the sea.','1997','87 min',8.0,'Thomas Jahn',27721),
('Sling Blade','Drama','Karl Childers, a simple man hospitalized since his childhood murder of his mother and her lover, is released to start a new life in a small town.','1996','135 min',8.0,'Billy Bob Thornton',86838),
('Secrets & Lies','Comedy, Drama','Following the death of her adoptive parents, a successful young black optometrist establishes contact with her biological mother -- a lonely white factory worker living in poverty in East London.','1996','136 min',8.0,'Mike Leigh',37564),
('Twelve Monkeys','Mystery, Sci-Fi, Thriller','In a future world devastated by disease, a convict is sent back in time to gather information about the man-made virus that wiped out most of the human population on the planet.','1995','129 min',8.0,'Terry Gilliam',578443),
('Kôkaku Kidôtai','Animation, Action, Crime','A cyborg policewoman and her partner hunt a mysterious and powerful hacker called the Puppet Master.','1995','83 min',8.0,'Mamoru Oshii',129231),
('The Nightmare Before Christmas','Animation, Family, Fantasy','Jack Skellington, king of Halloween Town, discovers Christmas Town, but his attempts to bring Christmas to his home causes confusion.','1993','76 min',8.0,'Henry Selick',300208),
('Groundhog Day','Comedy, Fantasy, Romance','A weatherman finds himself inexplicably living the same day over and over again.','1993','101 min',8.0,'Harold Ramis',577991),
('Bound by Honor','Crime, Drama','Based on the true life experiences of poet Jimmy Santiago Baca, the film focuses on step-brothers Paco and Cruz, and their bi-racial cousin Miklo.','1993','180 min',8.0,'Taylor Hackford',28825),
('Scent of a Woman','Drama','A prep school student needing money agrees to "babysit" a blind man, but the job is not at all what he anticipated.','1992','156 min',8.0,'Martin Brest',263918),
('Aladdin','Animation, Adventure, Comedy','A kindhearted street urchin and a power-hungry Grand Vizier vie for a magic lamp that has the power to make their deepest wishes come true.','1992','90 min',8.0,'Ron Clements',373845);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('JFK','Drama, History, Thriller','New Orleans District Attorney Jim Garrison discovers there''s more to the Kennedy assassination than the official story.','1991','189 min',8.0,'Oliver Stone',142110),
('Beauty and the Beast','Animation, Family, Fantasy','A prince cursed to spend his days as a hideous monster sets out to regain his humanity by earning a young woman''s love.','1991','84 min',8.0,'Gary Trousdale',417178),
('8½','Drama','A harried movie director retreats into his memories and fantasies.','1963','138 min',8.0,'Federico Fellini',108844),
('Dances with Wolves','Adventure, Drama, Western','Lieutenant John Dunbar, assigned to a remote western Civil War outpost, befriends wolves and Indians, making him an intolerable aberration in the military.','1990','181 min',8.0,'Kevin Costner',240266),
('Do the Right Thing','Comedy, Drama','On the hottest day of the year on a street in the Bedford-Stuyvesant section of Brooklyn, everyone''s hate and bigotry smolders and builds until it explodes into violence.','1989','120 min',8.0,'Spike Lee',89429),
('Rain Man','Drama','Selfish yuppie Charlie Babbitt''s father left a fortune to his savant brother Raymond and a pittance to Charlie; they travel cross-country.','1988','133 min',8.0,'Barry Levinson',473064),
('Akira','Animation, Action, Sci-Fi','A secret military project endangers Neo-Tokyo when it turns a biker gang member into a rampaging psychic psychopath who can only be stopped by two teenagers and a group of psychics.','1988','124 min',8.0,'Katsuhiro Ôtomo',164918),
('The Princess Bride','Adventure, Family, Fantasy','While home sick in bed, a young boy''s grandfather reads him the story of a farmboy-turned-pirate who encounters numerous obstacles, enemies and allies in his quest to be reunited with his true love.','1987','98 min',8.0,'Rob Reiner',393899),
('Der Himmel über Berlin','Drama, Fantasy, Romance','An angel tires of overseeing human activity and wishes to become human when he falls in love with a mortal.','1987','128 min',8.0,'Wim Wenders',64722),
('Au revoir les enfants','Drama, War','A French boarding school run by priests seems to be a haven from World War II until a new student arrives. He becomes the roommate of the top student in his class. Rivals at first, the roommates form a bond and share a secret.','1987','104 min',8.0,'Louis Malle',31163);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Tenkû no shiro Rapyuta','Animation, Adventure, Drama','A young boy and a girl with a magic crystal must race against pirates and foreign agents in a search for a legendary floating castle.','1986','125 min',8.0,'Hayao Miyazaki',150140),
('The Terminator','Action, Sci-Fi','A human soldier is sent from 2029 to 1984 to stop an almost indestructible cyborg killing machine, sent from the same year, which has been programmed to execute a young woman whose unborn son is the key to humanity''s future salvation.','1984','107 min',8.0,'James Cameron',799795),
('Gandhi','Biography, Drama, History','The life of the lawyer who became the famed leader of the Indian revolts against the British rule through his philosophy of nonviolent protest.','1982','191 min',8.0,'Richard Attenborough',217664),
('Kagemusha','Drama, History, War','A petty thief with an utter resemblance to a samurai warlord is hired as the lord''s double. When the warlord later dies the thief is forced to take up arms in his place.','1980','180 min',8.0,'Akira Kurosawa',32195),
('Being There','Comedy, Drama','A simpleminded, sheltered gardener becomes an unlikely trusted advisor to a powerful businessman and an insider in Washington politics.','1979','130 min',8.0,'Hal Ashby',65625),
('Annie Hall','Comedy, Romance','Neurotic New York comedian Alvy Singer falls in love with the ditzy Annie Hall.','1977','93 min',8.0,'Woody Allen',251823),
('Jaws','Adventure, Thriller','When a killer shark unleashes chaos on a beach community, it''s up to a local sheriff, a marine biologist, and an old seafarer to hunt the beast down.','1975','124 min',8.0,'Steven Spielberg',543388),
('Dog Day Afternoon','Biography, Crime, Drama','Three amateur bank robbers plan to hold up a bank. A nice simple robbery: Walk in, take the money, and run. Unfortunately, the supposedly uncomplicated heist suddenly becomes a bizarre nightmare as everything that could go wrong does.','1975','125 min',8.0,'Sidney Lumet',235652),
('Young Frankenstein','Comedy','An American grandson of the infamous scientist, struggling to prove that his grandfather was not as insane as people believe, is invited to Transylvania, where he discovers the process that reanimates a dead body.','1974','106 min',8.0,'Mel Brooks',143359),
('Papillon','Biography, Crime, Drama','A man befriends a fellow criminal as the two of them begin serving their sentence on a dreadful prison island, which inspires the man to plot his escape.','1973','151 min',8.0,'Franklin J. Schaffner',121627);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('The Exorcist','Horror','When a 12-year-old girl is possessed by a mysterious entity, her mother seeks the help of two priests to save her.','1973','122 min',8.0,'William Friedkin',362393),
('Sleuth','Mystery, Thriller','A man who loves games and theater invites his wife''s lover to meet him, setting up a battle of wits with potentially deadly results.','1972','138 min',8.0,'Joseph L. Mankiewicz',44748),
('The Last Picture Show','Drama, Romance','In 1951, a group of high schoolers come of age in a bleak, isolated, atrophied North Texas town that is slowly dying, both culturally and economically.','1971','118 min',8.0,'Peter Bogdanovich',42456),
('Fiddler on the Roof','Drama, Family, Musical','In prerevolutionary Russia, a Jewish peasant contends with marrying off three of his daughters while growing anti-Semitic sentiment threatens his village.','1971','181 min',8.0,'Norman Jewison',39491),
('Il conformista','Drama','A weak-willed Italian man becomes a fascist flunky who goes abroad to arrange the assassination of his old teacher, now a political dissident.','1970','113 min',8.0,'Bernardo Bertolucci',27067),
('Butch Cassidy and the Sundance Kid','Biography, Crime, Drama','Wyoming, early 1900s. Butch Cassidy and The Sundance Kid are the leaders of a band of outlaws. After a train robbery goes wrong they find themselves on the run with a posse hard on their heels. Their solution - escape to Bolivia.','1969','110 min',8.0,'George Roy Hill',201888),
('Rosemary''s Baby','Drama, Horror','A young couple trying for a baby move into a fancy apartment surrounded by peculiar neighbors.','1968','137 min',8.0,'Roman Polanski',193674),
('Planet of the Apes','Adventure, Sci-Fi','An astronaut crew crash-lands on a planet in the distant future where intelligent talking apes are the dominant species, and humans are the oppressed and enslaved.','1968','112 min',8.0,'Franklin J. Schaffner',165167),
('The Graduate','Comedy, Drama, Romance','A disillusioned college graduate finds himself torn between his older lover and her daughter.','1967','106 min',8.0,'Mike Nichols',253676),
('Who''s Afraid of Virginia Woolf?','Drama','A bitter, aging couple, with the help of alcohol, use their young houseguests to fuel anguish and emotional pain towards each other over the course of a distressing night.','1966','131 min',8.0,'Mike Nichols',68926);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('The Sound of Music','Biography, Drama, Family','A woman leaves an Austrian convent to become a governess to the children of a Naval officer widower.','1965','172 min',8.0,'Robert Wise',205425),
('Doctor Zhivago','Drama, Romance, War','The life of a Russian physician and poet who, although married to another, falls in love with a political activist''s wife and experiences hardship during World War I and then the October Revolution.','1965','197 min',8.0,'David Lean',69903),
('Per un pugno di dollari','Action, Drama, Western','A wandering gunfighter plays two rival families against each other in a town torn apart by greed, pride, and revenge.','1964','99 min',8.0,'Sergio Leone',198219),
('Vivre sa vie: Film en douze tableaux','Drama','Twelve episodic tales in the life of a Parisian woman and her slow descent into prostitution.','1962','80 min',8.0,'Jean-Luc Godard',28057),
('The Hustler','Drama, Sport','An up-and-coming pool player plays a long-time champion in a single high-stakes match.','1961','134 min',8.0,'Robert Rossen',75067),
('La dolce vita','Comedy, Drama','A series of stories following a week in the life of a philandering paparazzo journalist living in Rome.','1960','174 min',8.0,'Federico Fellini',66621),
('Rio Bravo','Action, Drama, Western','A small-town sheriff in the American West enlists the help of a cripple, a drunk, and a young gunfighter in his efforts to hold in jail the brother of the local bad guy.','1959','141 min',8.0,'Howard Hawks',56305),
('Anatomy of a Murder','Crime, Drama, Mystery','In a murder trial, the defendant says he suffered temporary insanity after the victim raped his wife. What is the truth, and will he win his case?','1959','161 min',8.0,'Otto Preminger',59847),
('Touch of Evil','Crime, Drama, Film-Noir','A stark, perverse story of murder, kidnapping, and police corruption in a Mexican border town.','1958','95 min',8.0,'Orson Welles',98431),
('Cat on a Hot Tin Roof','Drama','Brick is an alcoholic ex-football player who drinks his days away and resists the affections of his wife. A reunion with his terminal father jogs a host of memories and revelations for both father and son.','1958','108 min',8.0,'Richard Brooks',45062);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Sweet Smell of Success','Drama, Film-Noir','Powerful but unethical Broadway columnist J.J. Hunsecker coerces unscrupulous press agent Sidney Falco into breaking up his sister''s romance with a jazz musician.','1957','96 min',8.0,'Alexander Mackendrick',28137),
('The Killing','Crime, Drama, Film-Noir','Crook Johnny Clay assembles a five man team to plan and execute a daring race-track robbery.','1956','84 min',8.0,'Stanley Kubrick',81702),
('The Night of the Hunter','Crime, Drama, Film-Noir','A religious fanatic marries a gullible widow whose young children are reluctant to tell him where their real daddy hid the $10,000 he''d stolen in a robbery.','1955','92 min',8.0,'Charles Laughton',81980),
('La Strada','Drama','A care-free girl is sold to a traveling entertainer, consequently enduring physical and emotional pain along the way.','1954','108 min',8.0,'Federico Fellini',58314),
('Les diaboliques','Crime, Drama, Horror','The wife and mistress of a loathed school principal plan to murder him with what they believe is the perfect alibi.','1955','117 min',8.0,'Henri-Georges Clouzot',61503),
('Stalag 17','Comedy, Drama, War','When two escaping American World War II prisoners are killed, the German P.O.W. camp barracks black marketeer, J.J. Sefton, is suspected of being an informer.','1953','120 min',8.0,'Billy Wilder',51046),
('Roman Holiday','Comedy, Romance','A bored and sheltered princess escapes her guardians and falls in love with an American newsman in Rome.','1953','118 min',8.0,'William Wyler',127256),
('A Streetcar Named Desire','Drama','Disturbed Blanche DuBois moves in with her sister in New Orleans and is tormented by her brutish brother-in-law while her reality crumbles around her.','1951','122 min',8.0,'Elia Kazan',99182),
('In a Lonely Place','Drama, Film-Noir, Mystery','A potentially violent screenwriter is a murder suspect until his lovely neighbor clears him. However, she soon starts to have her doubts.','1950','94 min',8.0,'Nicholas Ray',26784),
('Kind Hearts and Coronets','Comedy, Crime','A distant poor relative of the Duke D''Ascoyne plots to inherit the title by murdering the eight other heirs who stand ahead of him in the line of succession.','1949','106 min',8.0,'Robert Hamer',34485);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Rope','Crime, Drama, Mystery','Two men attempt to prove they committed the perfect crime by hosting a dinner party after strangling their former classmate to death.','1948','80 min',8.0,'Alfred Hitchcock',129783),
('Out of the Past','Crime, Drama, Film-Noir','A private eye escapes his past to run a gas station in a small town, but his past catches up with him. Now he must return to the big city world of danger, corruption, double crosses and duplicitous dames.','1947','97 min',8.0,'Jacques Tourneur',32784),
('Brief Encounter','Drama, Romance','Meeting a stranger in a railway station, a woman is tempted to cheat on her husband.','1945','86 min',8.0,'David Lean',35601),
('Laura','Drama, Film-Noir, Mystery','A police detective falls in love with the woman whose murder he is investigating.','1944','88 min',8.0,'Otto Preminger',42725),
('The Best Years of Our Lives','Drama, Romance, War','Three World War II veterans return home to small-town America to discover that they and their families have been irreparably changed.','1946','170 min',8.0,'William Wyler',57259),
('Arsenic and Old Lace','Comedy, Crime, Thriller','A writer of books on the futility of marriage risks his reputation when he decides to get married. Things get even more complicated when he learns on his wedding day that his beloved maiden aunts are habitual murderers.','1942','118 min',8.0,'Frank Capra',65101),
('The Maltese Falcon','Film-Noir, Mystery','A private detective takes on a case that involves him with three eccentric criminals, a gorgeous liar, and their quest for a priceless statuette.','1941','100 min',8.0,'John Huston',148928),
('The Grapes of Wrath','Drama, History','A poor Midwest family is forced off their land. They travel to California, suffering the misfortunes of the homeless in the Great Depression.','1940','129 min',8.0,'John Ford',85559),
('The Wizard of Oz','Adventure, Family, Fantasy','Dorothy Gale is swept away from a farm in Kansas to a magical land of Oz in a tornado and embarks on a quest with her new friends to see the Wizard who can help her return home to Kansas and help her friends as well.','1939','102 min',8.0,'Victor Fleming',371379),
('La règle du jeu','Comedy, Drama','A bourgeois life in France at the onset of World War II, as the rich and their poor servants meet up at a French chateau.','1939','110 min',8.0,'Jean Renoir',26725);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('The Thin Man','Comedy, Crime, Mystery','Former detective Nick Charles and his wealthy wife Nora investigate a murder case, mostly for the fun of it.','1934','91 min',8.0,'W.S. Van Dyke',26642),
('All Quiet on the Western Front','Drama, War','A German youth eagerly enters World War I, but his enthusiasm wanes as he gets a firsthand view of the horror.','1930','152 min',8.0,'Lewis Milestone',57318),
('Bronenosets Potemkin','Drama, History, Thriller','In the midst of the Russian Revolution of 1905, the crew of the battleship Potemkin mutiny against the brutal, tyrannical regime of the vessel''s officers. The resulting street demonstration in Odessa brings on a police massacre.','1925','75 min',8.0,'Sergei M. Eisenstein',53054),
('Knives Out','Comedy, Crime, Drama','A detective investigates the death of a patriarch of an eccentric, combative family.','2019','130 min',7.9,'Rian Johnson',454203),
('Dil Bechara','Comedy, Drama, Romance','The emotional journey of two hopelessly in love youngsters, a young girl, Kizie, suffering from cancer, and a boy, Manny, whom she meets at a support group.','2020','101 min',7.9,'Mukesh Chhabra',111478),
('Manbiki kazoku','Crime, Drama','A family of small-time crooks take in a child they find outside in the cold.','2018','121 min',7.9,'Hirokazu Koreeda',62754),
('Marriage Story','Comedy, Drama, Romance','Noah Baumbach''s incisive and compassionate look at a marriage breaking up and a family staying together.','2019','137 min',7.9,'Noah Baumbach',246644),
('Call Me by Your Name','Drama, Romance','In 1980s Italy, romance blossoms between a seventeen-year-old student and the older man hired as his father''s research assistant.','2017','132 min',7.9,'Luca Guadagnino',212651),
('I, Daniel Blake','Drama','After having suffered a heart-attack, a 59-year-old carpenter must fight the bureaucratic forces of the system in order to receive Employment and Support Allowance.','2016','100 min',7.9,'Ken Loach',53818),
('Isle of Dogs','Animation, Adventure, Comedy','Set in Japan, Isle of Dogs follows a boy''s odyssey in search of his lost dog.','2018','101 min',7.9,'Wes Anderson',139114);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Hunt for the Wilderpeople','Adventure, Comedy, Drama','A national manhunt is ordered for a rebellious kid and his foster uncle who go missing in the wild New Zealand bush.','2016','101 min',7.9,'Taika Waititi',111483),
('Captain Fantastic','Comedy, Drama','In the forests of the Pacific Northwest, a father devoted to raising his six kids with a rigorous physical and intellectual education is forced to leave his paradise and enter the world, challenging his idea of what it means to be a parent.','2016','118 min',7.9,'Matt Ross',189400),
('Sing Street','Comedy, Drama, Music','A boy growing up in Dublin during the 1980s escapes his strained family life by starting a band to impress the mysterious girl he likes.','2016','106 min',7.9,'John Carney',85109),
('Thor: Ragnarok','Action, Adventure, Comedy','Imprisoned on the planet Sakaar, Thor must race against time to return to Asgard and stop Ragnarök, the destruction of his world, at the hands of the powerful and ruthless villain Hela.','2017','130 min',7.9,'Taika Waititi',587775),
('Nightcrawler','Crime, Drama, Thriller','When Louis Bloom, a con man desperate for work, muscles into the world of L.A. crime journalism, he blurs the line between observer and participant to become the star of his own story.','2014','117 min',7.9,'Dan Gilroy',466134),
('Jojo Rabbit','Comedy, Drama, War','A young boy in Hitler''s army finds out his mother is hiding a Jewish girl in their home.','2019','108 min',7.9,'Taika Waititi',297918),
('Arrival','Drama, Sci-Fi','A linguist works with the military to communicate with alien lifeforms after twelve mysterious spacecrafts appear around the world.','2016','116 min',7.9,'Denis Villeneuve',594181),
('Star Wars: Episode VII - The Force Awakens','Action, Adventure, Sci-Fi','As a new threat to the galaxy rises, Rey, a desert scavenger, and Finn, an ex-stormtrooper, must join Han Solo and Chewbacca to search for the one hope of restoring peace.','2015','138 min',7.9,'J.J. Abrams',860823),
('Before Midnight','Drama, Romance','We meet Jesse and Celine nine years on in Greece. Almost two decades have passed since their first meeting on that train bound for Vienna.','2013','109 min',7.9,'Richard Linklater',141457),
('X-Men: Days of Future Past','Action, Adventure, Sci-Fi','The X-Men send Wolverine to the past in a desperate effort to change history and prevent an event that results in doom for both humans and mutants.','2014','132 min',7.9,'Bryan Singer',659763);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Bir Zamanlar Anadolu''da','Crime, Drama','A group of men set out in search of a dead body in the Anatolian steppes.','2011','157 min',7.9,'Nuri Bilge Ceylan',41995),
('The Artist','Comedy, Drama, Romance','An egomaniacal film star develops a relationship with a young dancer against the backdrop of Hollywood''s silent era.','2011','100 min',7.9,'Michel Hazanavicius',230624),
('Edge of Tomorrow','Action, Adventure, Sci-Fi','A soldier fighting aliens gets to relive the same day over and over again, the day restarting every time he dies.','2014','113 min',7.9,'Doug Liman',600004),
('Amour','Drama, Romance','Georges and Anne are an octogenarian couple. They are cultivated, retired music teachers. Their daughter, also a musician, lives in Britain with her family. One day, Anne has a stroke, and the couple''s bond of love is severely tested.','2012','127 min',7.9,'Michael Haneke',93090),
('The Irishman','Biography, Crime, Drama','An old man recalls his time painting houses for his friend, Jimmy Hoffa, through the 1950-70s.','2019','209 min',7.9,'Martin Scorsese',324720),
('Un prophète','Crime, Drama','A young Arab man is sent to a French prison.','2009','155 min',7.9,'Jacques Audiard',93560),
('Moon','Drama, Mystery, Sci-Fi','Astronaut Sam Bell has a quintessentially personal encounter toward the end of his three-year stint on the Moon, where he, working alongside his computer, GERTY, sends back to Earth parcels of a resource that has helped diminish our planet''s power problems.','2009','97 min',7.9,'Duncan Jones',335152),
('Låt den rätte komma in','Crime, Drama, Fantasy','Oskar, an overlooked and bullied boy, finds love and revenge through Eli, a beautiful but peculiar girl.','2008','114 min',7.9,'Tomas Alfredson',205609),
('District 9','Action, Sci-Fi, Thriller','Violence ensues after an extraterrestrial race forced to live in slum-like conditions on Earth finds a kindred spirit in a government agent exposed to their biotechnology.','2009','112 min',7.9,'Neill Blomkamp',638202),
('The Wrestler','Drama, Sport','A faded professional wrestler must retire, but finds his quest for a new life outside the ring a dispiriting struggle.','2008','109 min',7.9,'Darren Aronofsky',289415);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Jab We Met','Comedy, Drama, Romance','A depressed wealthy businessman finds his life changing after he meets a spunky and care-free young woman.','2007','138 min',7.9,'Imtiaz Ali',47720),
('Boyhood','Drama','The life of Mason, from early childhood to his arrival at college.','2014','165 min',7.9,'Richard Linklater',335533),
('4 luni, 3 saptamâni si 2 zile','Drama','A woman assists her friend in arranging an illegal abortion in 1980s Romania.','2007','113 min',7.9,'Cristian Mungiu',56625),
('Star Trek','Action, Adventure, Sci-Fi','The brash James T. Kirk tries to live up to his father''s legacy with Mr. Spock keeping him in check as a vengeful Romulan from the future creates black holes to destroy the Federation one planet at a time.','2009','127 min',7.9,'J.J. Abrams',577336),
('In Bruges','Comedy, Crime, Drama','Guilt-stricken after a job gone wrong, hitman Ray and his partner await orders from their ruthless boss in Bruges, Belgium, the last place in the world Ray wants to be.','2008','107 min',7.9,'Martin McDonagh',390334),
('The Man from Earth','Drama, Fantasy, Mystery','An impromptu goodbye party for Professor John Oldman becomes a mysterious interrogation after the retiring scholar reveals to his colleagues he has a longer and stranger past than they can imagine.','2007','87 min',7.9,'Richard Schenkman',174125),
('Letters from Iwo Jima','Action, Adventure, Drama','The story of the battle of Iwo Jima between the United States and Imperial Japan during World War II, as told from the perspective of the Japanese who fought it.','2006','141 min',7.9,'Clint Eastwood',154011),
('The Fall','Adventure, Drama, Fantasy','In a hospital on the outskirts of 1920s Los Angeles, an injured stuntman begins to tell a fellow patient, a little girl with a broken arm, a fantastic story of five mythical heroes. Thanks to his fractured state of mind and her vivid imagination, the line between fiction and reality blurs as the tale advances.','2006','117 min',7.9,'Tarsem Singh',107290),
('Life of Pi','Adventure, Drama, Fantasy','A young man who survives a disaster at sea is hurtled into an epic journey of adventure and discovery. While cast away, he forms an unexpected connection with another survivor: a fearsome Bengal tiger.','2012','127 min',7.9,'Ang Lee',580708),
('Fantastic Mr. Fox','Animation, Adventure, Comedy','An urbane fox cannot resist returning to his farm raiding ways and then must help his community survive the farmers'' retaliation.','2009','87 min',7.9,'Wes Anderson',199696);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('C.R.A.Z.Y.','Comedy, Drama','A young French-Canadian, growing up in the 1960s and 1970s, struggles to reconcile his emerging homosexuality with his father''s conservative values and his own Catholic beliefs.','2005','129 min',7.9,'Jean-Marc Vallée',31476),
('Les choristes','Drama, Music','The new teacher at a severely administered boys'' boarding school works to positively affect the students'' lives through music.','2004','97 min',7.9,'Christophe Barratier',57430),
('Iron Man','Action, Adventure, Sci-Fi','After being held captive in an Afghan cave, billionaire engineer Tony Stark creates a unique weaponized suit of armor to fight evil.','2008','126 min',7.9,'Jon Favreau',939644),
('Shaun of the Dead','Comedy, Horror','A man''s uneventful life is disrupted by the zombie apocalypse.','2004','99 min',7.9,'Edgar Wright',512249),
('Gegen die Wand','Drama, Romance','With the intention to break free from the strict familial restrictions, a suicidal young woman sets up a marriage of convenience with a forty-year-old addict, an act that will lead to an outburst of envious love.','2004','121 min',7.9,'Fatih Akin',51325),
('Mystic River','Crime, Drama, Mystery','The lives of three men who were childhood friends are shattered when one of them has a family tragedy.','2003','138 min',7.9,'Clint Eastwood',419420),
('Harry Potter and the Prisoner of Azkaban','Adventure, Family, Fantasy','Harry Potter, Ron and Hermione return to Hogwarts School of Witchcraft and Wizardry for their third year of study, where they delve into the mystery surrounding an escaped prisoner who poses a dangerous threat to the young wizard.','2004','142 min',7.9,'Alfonso Cuarón',552493),
('Ying xiong','Action, Adventure, History','A defense officer, Nameless, was summoned by the King of Qin regarding his success of terminating three warriors.','2002','120 min',7.9,'Yimou Zhang',173999),
('Hable con ella','Drama, Mystery, Romance','Two men share an odd friendship while they care for two women who are both in deep comas.','2002','112 min',7.9,'Pedro Almodóvar',104691),
('No Man''s Land','Comedy, Drama, War','Bosnia and Herzegovina during 1993 at the time of the heaviest fighting between the two warring sides. Two soldiers from opposing sides in the conflict, Nino and Ciki, become trapped in no man''s land, whilst a third soldier becomes a living booby trap.','2001','98 min',7.9,'Danis Tanovic',44618);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Cowboy Bebop: Tengoku no tobira','Animation, Action, Crime','A terrorist explosion releases a deadly virus on the masses, and it''s up the bounty-hunting Bebop crew to catch the cold-blooded culprit.','2001','115 min',7.9,'Shin''ichirô Watanabe',42897),
('The Bourne Identity','Action, Mystery, Thriller','A man is picked up by a fishing boat, bullet-riddled and suffering from amnesia, before racing to elude assassins and attempting to regain his memory.','2002','119 min',7.9,'Doug Liman',508771),
('Nueve reinas','Crime, Drama, Thriller','Two con artists try to swindle a stamp collector by selling him a sheet of counterfeit rare stamps (the "nine queens").','2000','114 min',7.9,'Fabián Bielinsky',49721),
('Children of Men','Adventure, Drama, Sci-Fi','In 2027, in a chaotic world in which women have become somehow infertile, a former activist agrees to help transport a miraculously pregnant woman to a sanctuary at sea.','2006','109 min',7.9,'Alfonso Cuarón',465113),
('Almost Famous','Adventure, Comedy, Drama','A high-school boy is given the chance to write a story for Rolling Stone Magazine about an up-and-coming rock band as he accompanies them on their concert tour.','2000','122 min',7.9,'Cameron Crowe',252586),
('Mulholland Dr.','Drama, Mystery, Thriller','After a car wreck on the winding Mulholland Drive renders a woman amnesiac, she and a perky Hollywood-hopeful search for clues and answers across Los Angeles in a twisting venture beyond dreams and reality.','2001','147 min',7.9,'David Lynch',322031),
('Toy Story 2','Animation, Adventure, Comedy','When Woody is stolen by a toy collector, Buzz and his friends set out on a rescue mission to save Woody before he becomes a museum toy property with his roundup gang Jessie, Prospector, and Bullseye.','1999','92 min',7.9,'John Lasseter',527512),
('Boogie Nights','Drama','Back when sex was safe, pleasure was a business and business was booming, an idealistic porn producer aspires to elevate his craft to an art when he discovers a hot young talent.','1997','155 min',7.9,'Paul Thomas Anderson',239473),
('Mimi wo sumaseba','Animation, Drama, Family','A love story between a girl who loves reading books, and a boy who has previously checked out all of the library books she chooses.','1995','111 min',7.9,'Yoshifumi Kondô',51943),
('Once Were Warriors','Crime, Drama','A family descended from Maori warriors is bedeviled by a violent father and the societal problems of being treated as outcasts.','1994','102 min',7.9,'Lee Tamahori',31590);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('True Romance','Crime, Drama, Romance','In Detroit, a lonely pop culture geek marries a call girl, steals cocaine from her pimp, and tries to sell it in Hollywood. Meanwhile, the owners of the cocaine, the Mob, track them down in an attempt to reclaim it.','1993','119 min',7.9,'Tony Scott',206918),
('Trois couleurs: Bleu','Drama, Music, Mystery','A woman struggles to find a way to live her life after the death of her husband and child.','1993','94 min',7.9,'Krzysztof Kieslowski',89836),
('Jûbê ninpûchô','Animation, Action, Adventure','A vagabond swordsman is aided by a beautiful ninja girl and a crafty spy in confronting a demonic clan of killers - with a ghost from his past as their leader - who are bent on overthrowing the Tokugawa Shogunate.','1993','94 min',7.9,'Yoshiaki Kawajiri',34529),
('Carlito''s Way','Crime, Drama, Thriller','A Puerto Rican former convict, just released from prison, pledges to stay away from drugs and violence despite the pressure around him and lead on to a better life outside of N.Y.C.','1993','144 min',7.9,'Brian De Palma',201000),
('Edward Scissorhands','Drama, Fantasy, Romance','An artificial man, who was incompletely constructed and has scissors for hands, leads a solitary life. Then one day, a suburban lady meets him and introduces him to her world.','1990','105 min',7.9,'Tim Burton',447368),
('My Left Foot: The Story of Christy Brown','Biography, Drama','Christy Brown, born with cerebral palsy, learns to paint and write with his only controllable limb - his left foot.','1989','103 min',7.9,'Jim Sheridan',68076),
('Crimes and Misdemeanors','Comedy, Drama','An ophthalmologist''s mistress threatens to reveal their affair to his wife while a married documentary filmmaker is infatuated with another woman.','1989','104 min',7.9,'Woody Allen',54670),
('The Untouchables','Crime, Drama, Thriller','During the era of Prohibition in the United States, Federal Agent Eliot Ness sets out to stop ruthless Chicago gangster Al Capone and, because of rampant corruption, assembles a small, hand-picked team to help him.','1987','119 min',7.9,'Brian De Palma',281842),
('Hannah and Her Sisters','Comedy, Drama','Between two Thanksgivings two years apart, Hannah''s husband falls in love with her sister Lee, while her hypochondriac ex-husband rekindles his relationship with her sister Holly.','1986','107 min',7.9,'Woody Allen',67176),
('Brazil','Drama, Sci-Fi','A bureaucrat in a dystopic society becomes an enemy of the state as he pursues the woman of his dreams.','1985','132 min',7.9,'Terry Gilliam',187567);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('This Is Spinal Tap','Comedy, Music','Spinal Tap, one of England''s loudest bands, is chronicled by film director Marty DiBergi on what proves to be a fateful tour.','1984','82 min',7.9,'Rob Reiner',128812),
('A Christmas Story','Comedy, Family','In the 1940s, a young boy named Ralphie attempts to convince his parents, his teacher and Santa that a Red Ryder BB gun really is the perfect Christmas gift.','1983','93 min',7.9,'Bob Clark',132947),
('The Blues Brothers','Action, Adventure, Comedy','Jake Blues, just released from prison, puts together his old band to save the Catholic home where he and his brother Elwood were raised.','1980','133 min',7.9,'John Landis',183182),
('Manhattan','Comedy, Drama, Romance','The life of a divorced television writer dating a teenage girl is further complicated when he falls in love with his best friend''s mistress.','1979','96 min',7.9,'Woody Allen',131436),
('All That Jazz','Drama, Music, Musical','Director/choreographer Bob Fosse tells his own life story as he details the sordid career of Joe Gideon, a womanizing, drug-using dancer.','1979','123 min',7.9,'Bob Fosse',28223),
('Dawn of the Dead','Action, Adventure, Horror','Following an ever-growing epidemic of zombies that have risen from the dead, two Philadelphia S.W.A.T. team members, a traffic reporter, and his television executive girlfriend seek refuge in a secluded shopping mall.','1978','127 min',7.9,'George A. Romero',111512),
('All the President''s Men','Biography, Drama, History','"The Washington Post" reporters Bob Woodward and Carl Bernstein uncover the details of the Watergate scandal that leads to President Richard Nixon''s resignation.','1976','138 min',7.9,'Alan J. Pakula',103031),
('La montaña sagrada','Adventure, Drama, Fantasy','In a corrupt, greed-fueled world, a powerful alchemist leads a messianic character and seven materialistic figures to the Holy Mountain, where they hope to achieve enlightenment.','1973','114 min',7.9,'Alejandro Jodorowsky',37183),
('Amarcord','Comedy, Drama, Family','A series of comedic and nostalgic vignettes set in a 1930s Italian coastal town.','1973','123 min',7.9,'Federico Fellini',39897),
('Le charme discret de la bourgeoisie','Comedy','A surreal, virtually plotless series of dreams centered around six middle-class people and their consistently interrupted attempts to have a meal together.','1972','102 min',7.9,'Luis Buñuel',38737);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Aguirre, der Zorn Gottes','Action, Adventure, Biography','In the 16th century, the ruthless and insane Don Lope de Aguirre leads a Spanish expedition in search of El Dorado.','1972','95 min',7.9,'Werner Herzog',52397),
('Harold and Maude','Comedy, Drama, Romance','Young, rich, and obsessed with death, Harold finds himself changed forever when he meets lively septuagenarian Maude at a funeral.','1971','91 min',7.9,'Hal Ashby',70826),
('Patton','Biography, Drama, War','The World War II phase of the career of controversial American general George S. Patton.','1970','172 min',7.9,'Franklin J. Schaffner',93741),
('The Wild Bunch','Action, Adventure, Western','An aging group of outlaws look for one last big score as the "traditional" American West is disappearing around them.','1969','145 min',7.9,'Sam Peckinpah',77401),
('Night of the Living Dead','Horror, Thriller','A ragtag group of Pennsylvanians barricade themselves in an old farmhouse to remain safe from a horde of flesh-eating ghouls that are ravaging the East Coast of the United States.','1968','96 min',7.9,'George A. Romero',116557),
('The Lion in Winter','Biography, Drama, History','1183 A.D.: King Henry II''s three sons all want to inherit the throne, but he won''t commit to a choice. They and his wife variously plot to force him.','1968','134 min',7.9,'Anthony Harvey',29003),
('In the Heat of the Night','Crime, Drama, Mystery','A black police detective is asked to investigate a murder in a racially hostile southern town.','1967','110 min',7.9,'Norman Jewison',67804),
('Charade','Comedy, Mystery, Romance','Romance and suspense ensue in Paris as a woman is pursued by several men who want a fortune her murdered husband had stolen. Whom can she trust?','1963','113 min',7.9,'Stanley Donen',68689),
('The Manchurian Candidate','Drama, Thriller','A former prisoner of war is brainwashed as an unwitting assassin for an international Communist conspiracy.','1962','126 min',7.9,'John Frankenheimer',71122),
('Spartacus','Adventure, Biography, Drama','The slave Spartacus leads a violent revolt against the decadent Roman Republic.','1960','197 min',7.9,'Stanley Kubrick',124339);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('L''avventura','Drama, Mystery','A woman disappears during a Mediterranean boating trip. During the search, her lover and her best friend become attracted to each other.','1960','144 min',7.9,'Michelangelo Antonioni',26542),
('Hiroshima mon amour','Drama, Romance','A French actress filming an anti-war film in Hiroshima has an affair with a married Japanese architect as they share their differing perspectives on war.','1959','90 min',7.9,'Alain Resnais',28421),
('The Ten Commandments','Adventure, Drama','Moses, an Egyptian Prince, learns of his true heritage as a Hebrew and his divine mission as the deliverer of his people.','1956','220 min',7.9,'Cecil B. DeMille',63560),
('The Searchers','Adventure, Drama, Western','An American Civil War veteran embarks on a journey to rescue his niece from the Comanches.','1956','119 min',7.9,'John Ford',80316),
('East of Eden','Drama','Two brothers struggle to maintain their strict, Bible-toting father''s favor.','1955','118 min',7.9,'Elia Kazan',40313),
('High Noon','Drama, Thriller, Western','A town Marshal, despite the disagreements of his newlywed bride and the townspeople around him, must face a gang of deadly killers alone at high noon when the gang leader, an outlaw he sent up years ago, arrives on the noon train.','1952','85 min',7.9,'Fred Zinnemann',97222),
('Strangers on a Train','Crime, Film-Noir, Thriller','A psychopath forces a tennis star to comply with his theory that two strangers can get away with murder.','1951','101 min',7.9,'Alfred Hitchcock',123341),
('Harvey','Comedy, Drama, Fantasy','Due to his insistence that he has an invisible six foot-tall rabbit for a best friend, a whimsical middle-aged man is thought by his family to be insane - but he may be wiser than anyone knows.','1950','104 min',7.9,'Henry Koster',52573),
('Miracle on 34th Street','Comedy, Drama, Family','When a nice old man who claims to be Santa Claus is institutionalized as insane, a young lawyer decides to defend him by arguing in court that he is the real thing.','1947','96 min',7.9,'George Seaton',41625),
('Notorious','Drama, Film-Noir, Romance','A woman is asked to spy on a group of Nazi friends in South America. How far will she have to go to ingratiate herself with them?','1946','102 min',7.9,'Alfred Hitchcock',92306);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('The Big Sleep','Crime, Film-Noir, Mystery','Private detective Philip Marlowe is hired by a wealthy family. Before the complex case is over, he''s seen murder, blackmail, and what might be love.','1946','114 min',7.9,'Howard Hawks',78796),
('The Lost Weekend','Drama, Film-Noir','The desperate life of a chronic alcoholic is followed through a four-day drinking bout.','1945','101 min',7.9,'Billy Wilder',33549),
('The Philadelphia Story','Comedy, Romance','When a rich woman''s ex-husband and a tabloid-type reporter turn up just before her planned remarriage, she begins to learn the truth about herself.','1940','112 min',7.9,'George Cukor',63550),
('His Girl Friday','Comedy, Drama, Romance','A newspaper editor uses every trick in the book to keep his ace reporter ex-wife from remarrying.','1940','92 min',7.9,'Howard Hawks',53667),
('The Adventures of Robin Hood','Action, Adventure, Romance','When Prince John and the Norman Lords begin oppressing the Saxon masses in King Richard''s absence, a Saxon lord fights back as the outlaw leader of a rebel guerrilla army.','1938','102 min',7.9,'Michael Curtiz',47175),
('A Night at the Opera','Comedy, Music, Musical','A sly business manager and two wacky friends of two opera singers help them achieve success while humiliating their stuffy and snobbish enemies.','1935','96 min',7.9,'Sam Wood',30580),
('King Kong','Adventure, Horror, Sci-Fi','A film crew goes to a tropical island for an exotic location shoot and discovers a colossal ape who takes a shine to their female blonde star. He is then captured and brought back to New York City for public exhibition.','1933','100 min',7.9,'Merian C. Cooper',78991),
('Freaks','Drama, Horror','A circus'' beautiful trapeze artist agrees to marry the leader of side-show performers, but his deformed friends discover she is only marrying him for his inheritance.','1932','64 min',7.9,'Tod Browning',42117),
('Nosferatu','Fantasy, Horror','Vampire Count Orlok expresses interest in a new residence and real estate agent Hutter''s wife.','1922','94 min',7.9,'F.W. Murnau',88794),
('The Gentlemen','Action, Comedy, Crime','An American expat tries to sell off his highly profitable marijuana empire in London, triggering plots, schemes, bribery and blackmail in an attempt to steal his domain out from under him.','2019','113 min',7.8,'Guy Ritchie',237392);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Raazi','Action, Drama, Thriller','A Kashmiri woman agrees to marry a Pakistani army officer in order to spy on Pakistan during the Indo-Pakistan War of 1971.','2018','138 min',7.8,'Meghna Gulzar',25344),
('Sound of Metal','Drama, Music','A heavy-metal drummer''s life is thrown into freefall when he begins to lose his hearing.','2019','120 min',7.8,'Darius Marder',27187),
('Forushande','Drama','While both participating in a production of "Death of a Salesman," a teacher''s wife is assaulted in her new home, which leaves him determined to find the perpetrator over his wife''s traumatized objections.','2016','124 min',7.8,'Asghar Farhadi',51240),
('Dunkirk','Action, Drama, History','Allied soldiers from Belgium, the British Empire, and France are surrounded by the German Army and evacuated during a fierce battle in World War II.','2017','106 min',7.8,'Christopher Nolan',555092),
('Perfetti sconosciuti','Comedy, Drama','Seven long-time friends get together for a dinner. When they decide to share with each other the content of every text message, email and phone call they receive, many secrets start to unveil and the equilibrium trembles.','2016','96 min',7.8,'Paolo Genovese',57168),
('Hidden Figures','Biography, Drama, History','The story of a team of female African-American mathematicians who served a vital role in NASA during the early years of the U.S. space program.','2016','127 min',7.8,'Theodore Melfi',200876),
('Paddington 2','Adventure, Comedy, Family','Paddington (Ben Whishaw), now happily settled with the Brown family and a popular member of the local community, picks up a series of odd jobs to buy the perfect present for his Aunt Lucy''s (Imelda Staunton''s) 100th birthday, only for the gift to be stolen.','2017','103 min',7.8,'Paul King',61594),
('Udta Punjab','Action, Crime, Drama','A story that revolves around drug abuse in the affluent north Indian State of Punjab and how the youth there have succumbed to it en-masse resulting in a socio-economic decline.','2016','148 min',7.8,'Abhishek Chaubey',27175),
('Kubo and the Two Strings','Animation, Action, Adventure','A young boy named Kubo must locate a magical suit of armour worn by his late father in order to defeat a vengeful spirit from the past.','2016','101 min',7.8,'Travis Knight',118035),
('M.S. Dhoni: The Untold Story','Biography, Drama, Sport','The untold story of Mahendra Singh Dhoni''s journey from ticket collector to trophy collector - the world-cup-winning captain of the Indian Cricket Team.','2016','184 min',7.8,'Neeraj Pandey',40416);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Manchester by the Sea','Drama','A depressed uncle is asked to take care of his teenage nephew after the boy''s father dies.','2016','137 min',7.8,'Kenneth Lonergan',246963),
('Under sandet','Drama, History, War','In post-World War II Denmark, a group of young German POWs are forced to clear a beach of thousands of land mines under the watch of a Danish Sergeant who slowly learns to appreciate their plight.','2015','100 min',7.8,'Martin Zandvliet',35539),
('Rogue One','Action, Adventure, Sci-Fi','The daughter of an Imperial scientist joins the Rebel Alliance in a risky move to steal the plans for the Death Star.','2016','133 min',7.8,'Gareth Edwards',556608),
('Captain America: Civil War','Action, Adventure, Sci-Fi','Political involvement in the Avengers'' affairs causes a rift between Captain America and Iron Man.','2016','147 min',7.8,'Anthony Russo',663649),
('The Hateful Eight','Crime, Drama, Mystery','In the dead of a Wyoming winter, a bounty hunter and his prisoner find shelter in a cabin currently inhabited by a collection of nefarious characters.','2015','168 min',7.8,'Quentin Tarantino',517059),
('Little Women','Drama, Romance','Jo March reflects back and forth on her life, telling the beloved story of the March sisters - four young women, each determined to live life on her own terms.','2019','135 min',7.8,'Greta Gerwig',143250),
('Loving Vincent','Animation, Biography, Crime','In a story depicted in oil painted animation, a young man comes to the last hometown of painter Vincent van Gogh (Robert Gulaczyk) to deliver the troubled artist''s final letter and ends up investigating his final days there.','2017','94 min',7.8,'Dorota Kobiela',50778),
('Pride','Biography, Comedy, Drama','U.K. gay activists work to help miners during their lengthy strike of the National Union of Mineworkers in the summer of 1984.','2014','119 min',7.8,'Matthew Warchus',51841),
('Le passé','Drama, Mystery','An Iranian man deserts his French wife and her two children to return to his homeland. Meanwhile, his wife starts up a new relationship, a reality her husband confronts upon his wife''s request for a divorce.','2013','130 min',7.8,'Asghar Farhadi',45002),
('La grande bellezza','Drama','Jep Gambardella has seduced his way through the lavish nightlife of Rome for decades, but after his 65th birthday and a shock from the past, Jep looks past the nightclubs and parties to find a timeless landscape of absurd, exquisite beauty.','2013','141 min',7.8,'Paolo Sorrentino',81125);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('The Lunchbox','Drama, Romance','A mistaken delivery in Mumbai''s famously efficient lunchbox delivery system connects a young housewife to an older man in the dusk of his life as they build a fantasy world together through notes in the lunchbox.','2013','104 min',7.8,'Ritesh Batra',50523),
('Vicky Donor','Comedy, Romance','A man is brought in by an infertility doctor to supply him with his sperm, where he becomes the biggest sperm donor for his clinic.','2012','126 min',7.8,'Shoojit Sircar',39710),
('Big Hero 6','Animation, Action, Adventure','A special bond develops between plus-sized inflatable robot Baymax and prodigy Hiro Hamada, who together team up with a group of friends to form a band of high-tech heroes.','2014','102 min',7.8,'Don Hall',410983),
('About Time','Comedy, Drama, Fantasy','At the age of 21, Tim discovers he can travel in time and change what happens and has happened in his own life. His decision to make his world a better place by getting a girlfriend turns out not to be as easy as you might think.','2013','123 min',7.8,'Richard Curtis',303032),
('English Vinglish','Comedy, Drama, Family','A quiet, sweet tempered housewife endures small slights from her well-educated husband and daughter every day because of her inability to speak and understand English.','2012','134 min',7.8,'Gauri Shinde',33618),
('Kaze tachinu','Animation, Biography, Drama','A look at the life of Jiro Horikoshi, the man who designed Japanese fighter planes during World War II.','2013','126 min',7.8,'Hayao Miyazaki',73690),
('Toy Story 4','Animation, Adventure, Comedy','When a new toy called "Forky" joins Woody and the gang, a road trip alongside old and new friends reveals how big the world can be for a toy.','2019','100 min',7.8,'Josh Cooley',203177),
('La migliore offerta','Crime, Drama, Mystery','A lonely art expert working for a mysterious and reclusive heiress finds not only her art worth examining.','2013','131 min',7.8,'Giuseppe Tornatore',108399),
('Moonrise Kingdom','Comedy, Drama, Romance','A pair of young lovers flee their New England town, which causes a local search party to fan out to find them.','2012','94 min',7.8,'Wes Anderson',318789),
('How to Train Your Dragon 2','Animation, Action, Adventure','When Hiccup and Toothless discover an ice cave that is home to hundreds of new wild dragons and the mysterious Dragon Rider, the two friends find themselves at the center of a battle to protect the peace.','2014','102 min',7.8,'Dean DeBlois',305611);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('The Big Short','Biography, Comedy, Drama','In 2006-2007 a group of investors bet against the US mortgage market. In their research they discover how flawed and corrupt the market is.','2015','130 min',7.8,'Adam McKay',362942),
('Kokuhaku','Drama, Thriller','A psychological thriller of a grieving mother turned cold-blooded avenger with a twisty master plan to pay back those who were responsible for her daughter''s death.','2010','106 min',7.8,'Tetsuya Nakashima',35713),
('Ang-ma-reul bo-at-da','Action, Crime, Drama','A secret agent exacts revenge on a serial killer through a series of captures and releases.','2010','144 min',7.8,'Jee-woon Kim',111252),
('The Girl with the Dragon Tattoo','Crime, Drama, Mystery','Journalist Mikael Blomkvist is aided in his search for a woman who has been missing for forty years by Lisbeth Salander, a young computer hacker.','2011','158 min',7.8,'David Fincher',423010),
('Captain Phillips','Adventure, Biography, Crime','The true story of Captain Richard Phillips and the 2009 hijacking by Somali pirates of the U.S.-flagged MV Maersk Alabama, the first American cargo ship to be hijacked in two hundred years.','2013','134 min',7.8,'Paul Greengrass',421244),
('Ajeossi','Action, Crime, Drama','A quiet pawnshop keeper with a violent past takes on a drug-and-organ trafficking ring in hope of saving the child who is his only friend.','2010','119 min',7.8,'Jeong-beom Lee',62848),
('Straight Outta Compton','Biography, Drama, History','The rap group NWA emerges from the mean streets of Compton in Los Angeles, California, in the mid-1980s and revolutionizes Hip Hop culture with their music and tales about life in the hood.','2015','147 min',7.8,'F. Gary Gray',179264),
('Madeo','Crime, Drama, Mystery','A mother desperately searches for the killer who framed her son for a girl''s horrific murder.','2009','129 min',7.8,'Bong Joon Ho',52758),
('Chugyeokja','Action, Crime, Thriller','A disgraced ex-policeman who runs a small ring of prostitutes finds himself in a race against time when one of his women goes missing.','2008','125 min',7.8,'Hong-jin Na',58468),
('The Hobbit: The Desolation of Smaug','Adventure, Fantasy','The dwarves, along with Bilbo Baggins and Gandalf the Grey, continue their quest to reclaim Erebor, their homeland, from Smaug. Bilbo Baggins is in possession of a mysterious and magical ring.','2013','161 min',7.8,'Peter Jackson',601408);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Das weiße Band - Eine deutsche Kindergeschichte','Drama, History, Mystery','Strange events happen in a small village in the north of Germany during the years before World War I, which seem to be ritual punishment. Who is responsible?','2009','144 min',7.8,'Michael Haneke',68715),
('Män som hatar kvinnor','Crime, Drama, Mystery','A journalist is aided by a young female hacker in his search for the killer of a woman who has been dead for forty years.','2009','152 min',7.8,'Niels Arden Oplev',208994),
('The Trial of the Chicago 7','Drama, History, Thriller','The story of 7 people on trial stemming from various charges surrounding the uprising at the 1968 Democratic National Convention in Chicago, Illinois.','2020','129 min',7.8,'Aaron Sorkin',89896),
('Druk','Comedy, Drama','Four friends, all high school teachers, test a theory that they will improve their lives by maintaining a constant level of alcohol in their blood.','2020','117 min',7.8,'Thomas Vinterberg',33931),
('The Fighter','Biography, Drama, Sport','Based on the story of Micky Ward, a fledgling boxer who tries to escape the shadow of his more famous but troubled older boxing brother and get his own shot at greatness.','2010','116 min',7.8,'David O. Russell',340584),
('Taken','Action, Thriller','A retired CIA agent travels across Europe and relies on his old skills to save his estranged daughter, who has been kidnapped while on a trip to Paris.','2008','90 min',7.8,'Pierre Morel',564791),
('The Boy in the Striped Pyjamas','Drama, History, War','Through the innocent eyes of Bruno, the eight-year-old son of the commandant at a German concentration camp, a forbidden friendship with a Jewish boy on the other side of the camp fence has startling and unexpected consequences.','2008','94 min',7.8,'Mark Herman',190748),
('Once','Drama, Music, Romance','A modern-day musical about a busker and an immigrant and their eventful week in Dublin, as they write, rehearse and record songs that tell their love story.','2007','86 min',7.8,'John Carney',110656),
('The Hobbit: An Unexpected Journey','Adventure, Fantasy','A reluctant Hobbit, Bilbo Baggins, sets out to the Lonely Mountain with a spirited group of dwarves to reclaim their mountain home, and the gold within it from the dragon Smaug.','2012','169 min',7.8,'Peter Jackson',757377),
('Auf der anderen Seite','Drama','A Turkish man travels to Istanbul to find the daughter of his father''s former girlfriend.','2007','122 min',7.8,'Fatih Akin',30827);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Atonement','Drama, Mystery, Romance','Thirteen-year-old fledgling writer Briony Tallis irrevocably changes the course of several lives when she accuses her older sister''s lover of a crime he did not commit.','2007','123 min',7.8,'Joe Wright',251370),
('Drive','Crime, Drama','A mysterious Hollywood stuntman and mechanic moonlights as a getaway driver and finds himself in trouble when he helps out his neighbor.','2011','100 min',7.8,'Nicolas Winding Refn',571571),
('American Gangster','Biography, Crime, Drama','An outcast New York City cop is charged with bringing down Harlem drug lord Frank Lucas, whose real life inspired this partly biographical film.','2007','157 min',7.8,'Ridley Scott',392449),
('Avatar','Action, Adventure, Fantasy','A paraplegic Marine dispatched to the moon Pandora on a unique mission becomes torn between following his orders and protecting the world he feels is his home.','2009','162 min',7.8,'James Cameron',1118998),
('Mr. Nobody','Drama, Fantasy, Romance','A boy stands on a station platform as a train is about to leave. Should he go with his mother or stay with his father? Infinite possibilities arise from this decision. As long as he doesn''t choose, anything is possible.','2009','141 min',7.8,'Jaco Van Dormael',216421),
('Apocalypto','Action, Adventure, Drama','As the Mayan kingdom faces its decline, a young man is taken on a perilous journey to a world ruled by fear and oppression.','2006','139 min',7.8,'Mel Gibson',291018),
('Little Miss Sunshine','Comedy, Drama','A family determined to get their young daughter into the finals of a beauty pageant take a cross-country trip in their VW bus.','2006','101 min',7.8,'Jonathan Dayton',439856),
('Hot Fuzz','Action, Comedy, Mystery','A skilled London police officer is transferred to a small town with a dark secret.','2007','121 min',7.8,'Edgar Wright',463466),
('The Curious Case of Benjamin Button','Drama, Fantasy, Romance','Tells the story of Benjamin Button, a man who starts aging backwards with consequences.','2008','166 min',7.8,'David Fincher',589160),
('Veer-Zaara','Drama, Family, Musical','Veer-Zaara is a saga of love, separation, courage and sacrifice. A love story that is an inspiration and will remain a legend forever.','2004','192 min',7.8,'Yash Chopra',49050);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Adams æbler','Comedy, Crime, Drama','A neo-nazi sentenced to community service at a church clashes with the blindly devotional priest.','2005','94 min',7.8,'Anders Thomas Jensen',45717),
('Pride & Prejudice','Drama, Romance','Sparks fly when spirited Elizabeth Bennet meets single, rich, and proud Mr. Darcy. But Mr. Darcy reluctantly finds himself falling in love with a woman beneath his class. Can each overcome their own pride and prejudice?','2005','129 min',7.8,'Joe Wright',258924),
('The World''s Fastest Indian','Biography, Drama, Sport','The story of New Zealander Burt Munro, who spent years rebuilding a 1920 Indian motorcycle, which helped him set the land speed world record at Utah''s Bonneville Salt Flats in 1967.','2005','127 min',7.8,'Roger Donaldson',51980),
('Tôkyô goddofâzâzu','Animation, Adventure, Comedy','On Christmas Eve, three homeless people living on the streets of Tokyo discover a newborn baby among the trash and set out to find its parents.','2003','90 min',7.8,'Satoshi Kon',31658),
('Serenity','Action, Adventure, Sci-Fi','The crew of the ship Serenity try to evade an assassin sent to recapture one of their members who is telepathic.','2005','119 min',7.8,'Joss Whedon',283310),
('Walk the Line','Biography, Drama, Music','A chronicle of country music legend Johnny Cash''s life, from his early days on an Arkansas cotton farm to his rise to fame with Sun Records in Memphis, where he recorded alongside Elvis Presley, Jerry Lee Lewis, and Carl Perkins.','2005','136 min',7.8,'James Mangold',234207),
('Ondskan','Drama','A teenage boy expelled from school for fighting arrives at a boarding school where the systematic bullying of younger students is encouraged as a means to maintain discipline, and decides to fight back.','2003','113 min',7.8,'Mikael Håfström',35682),
('The Notebook','Drama, Romance','A poor yet passionate young man falls in love with a rich young woman, giving her a sense of freedom, but they are soon separated because of their social differences.','2004','123 min',7.8,'Nick Cassavetes',520284),
('Diarios de motocicleta','Adventure, Biography, Drama','The dramatization of a motorcycle road trip Che Guevara went on in his youth that showed him his life''s calling.','2004','126 min',7.8,'Walter Salles',96703),
('Lilja 4-ever','Crime, Drama','Sixteen-year-old Lilja and her only friend, the young boy Volodja, live in Russia, fantasizing about a better life. One day, Lilja falls in love with Andrej, who is going to Sweden, and invites Lilja to come along and start a new life.','2002','109 min',7.8,'Lukas Moodysson',42673);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Les triplettes de Belleville','Animation, Comedy, Drama','When her grandson is kidnapped during the Tour de France, Madame Souza and her beloved pooch Bruno team up with the Belleville Sisters--an aged song-and-dance team from the days of Fred Astaire--to rescue him.','2003','80 min',7.8,'Sylvain Chomet',50622),
('Gongdong gyeongbi guyeok JSA','Action, Drama, Thriller','After a shooting incident at the North/South Korean border/DMZ leaves 2 North Korean soldiers dead, a neutral Swiss/Swedish team investigates, what actually happened.','2000','110 min',7.8,'Chan-wook Park',26518),
('The Count of Monte Cristo','Action, Adventure, Drama','A young man, falsely imprisoned by his jealous "friend", escapes and uses a hidden treasure to exact his revenge.','2002','131 min',7.8,'Kevin Reynolds',129022),
('Waking Life','Animation, Drama, Fantasy','A man shuffles through a dream meeting various people and discussing the meanings and purposes of the universe.','2001','99 min',7.8,'Richard Linklater',60684),
('Remember the Titans','Biography, Drama, Sport','The true story of a newly appointed African-American coach and his high school team on their first season as a racially integrated unit.','2000','113 min',7.8,'Boaz Yakin',198089),
('Wo hu cang long','Action, Adventure, Fantasy','A young Chinese warrior steals a sword from a famed swordsman and then escapes into a world of romantic adventure with a mysterious man in the frontier of the nation.','2000','120 min',7.8,'Ang Lee',253228),
('Todo sobre mi madre','Drama','Young Esteban wants to become a writer and also to discover the identity of his second mother, a trans woman, carefully concealed by his mother Manuela.','1999','101 min',7.8,'Pedro Almodóvar',89058),
('Cast Away','Adventure, Drama, Romance','A FedEx executive undergoes a physical and emotional transformation after crash landing on a deserted island.','2000','143 min',7.8,'Robert Zemeckis',524235),
('The Boondock Saints','Action, Crime, Thriller','Two Irish Catholic brothers become vigilantes and wipe out Boston''s criminal underworld in the name of God.','1999','108 min',7.8,'Troy Duffy',227143),
('The Insider','Biography, Drama, Thriller','A research chemist comes under personal and professional attack when he decides to appear in a 60 Minutes exposé on Big Tobacco.','1999','157 min',7.8,'Michael Mann',159886);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('October Sky','Biography, Drama, Family','The true story of Homer Hickam, a coal miner''s son who was inspired by the first Sputnik launch to take up rocketry against his father''s wishes.','1999','108 min',7.8,'Joe Johnston',82855),
('Shrek','Animation, Adventure, Comedy','A mean lord exiles fairytale creatures to the swamp of a grumpy ogre, who must go on a quest and rescue a princess for the lord in order to get his land back.','2001','90 min',7.8,'Andrew Adamson',613941),
('Titanic','Drama, Romance','A seventeen-year-old aristocrat falls in love with a kind but poor artist aboard the luxurious, ill-fated R.M.S. Titanic.','1997','194 min',7.8,'James Cameron',1046089),
('Hana-bi','Crime, Drama, Romance','Nishi leaves the police in the face of harrowing personal and professional difficulties. Spiraling into depression, he makes questionable decisions.','1997','103 min',7.8,'Takeshi Kitano',27712),
('Gattaca','Drama, Sci-Fi, Thriller','A genetically inferior man assumes the identity of a superior one in order to pursue his lifelong dream of space travel.','1997','106 min',7.8,'Andrew Niccol',280845),
('The Game','Action, Drama, Mystery','After a wealthy banker is given an opportunity to participate in a mysterious game, his life is turned upside down when he becomes unable to distinguish between the game and reality.','1997','129 min',7.8,'David Fincher',345096),
('Breaking the Waves','Drama','Oilman Jan is paralyzed in an accident. His wife, who prayed for his return, feels guilty; even more, when Jan urges her to have sex with another.','1996','159 min',7.8,'Lars von Trier',62428),
('Ed Wood','Biography, Comedy, Drama','Ambitious but troubled movie director Edward D. Wood Jr. tries his best to fulfill his dreams, despite his lack of talent.','1994','127 min',7.8,'Tim Burton',164937),
('What''s Eating Gilbert Grape','Drama','A young man in a small Midwestern town struggles to care for his mentally-disabled younger brother and morbidly obese mother while attempting to pursue his own happiness.','1993','118 min',7.8,'Lasse Hallström',215034),
('Tombstone','Action, Biography, Drama','A successful lawman''s plans to retire anonymously in Tombstone, Arizona are disrupted by the kind of outlaws he was famous for eliminating.','1993','130 min',7.8,'George P. Cosmatos',126871);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('The Sandlot','Comedy, Drama, Family','In the summer of 1962, a new kid in town is taken under the wing of a young baseball prodigy and his rowdy team, resulting in many adventures.','1993','101 min',7.8,'David Mickey Evans',78963),
('The Remains of the Day','Drama, Romance','A butler who sacrificed body and soul to service in the years leading up to World War II realizes too late how misguided his loyalty was to his lordly employer.','1993','134 min',7.8,'James Ivory',66065),
('Naked','Comedy, Drama','Parallel tales of two sexually obsessed men, one hurting and annoying women physically and mentally, one wandering around the city talking to strangers and experiencing dimensions of life.','1993','132 min',7.8,'Mike Leigh',34635),
('The Fugitive','Action, Crime, Drama','Dr. Richard Kimble, unjustly accused of murdering his wife, must find the real killer while being the target of a nationwide manhunt led by a seasoned U.S. Marshal.','1993','130 min',7.8,'Andrew Davis',267684),
('A Bronx Tale','Crime, Drama, Romance','A father becomes worried when a local gangster befriends his son in the Bronx in the 1960s.','1993','121 min',7.8,'Robert De Niro',128171),
('Batman: Mask of the Phantasm','Animation, Action, Crime','Batman is wrongly implicated in a series of murders of mob bosses actually done by a new vigilante assassin.','1993','76 min',7.8,'Kevin Altieri',43690),
('Lat sau san taam','Action, Crime, Thriller','A tough-as-nails cop teams up with an undercover agent to shut down a sinister mobster and his crew.','1992','128 min',7.8,'John Woo',46700),
('Night on Earth','Comedy, Drama','An anthology of 5 different cab drivers in 5 American and European cities and their remarkable fares on the same eventful night.','1991','129 min',7.8,'Jim Jarmusch',55362),
('La double vie de Véronique','Drama, Fantasy, Music','Two parallel stories about two identical women; one living in Poland, the other in France. They don''t know each other, but their lives are nevertheless profoundly connected.','1991','98 min',7.8,'Krzysztof Kieslowski',42376),
('Boyz n the Hood','Crime, Drama','Follows the lives of three young males living in the Crenshaw ghetto of Los Angeles, dissecting questions of race, relationships, violence, and future prospects.','1991','112 min',7.8,'John Singleton',126082);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Misery','Drama, Thriller','After a famous author is rescued from a car crash by a fan of his novels, he comes to realize that the care he is receiving is only the beginning of a nightmare of captivity and abuse.','1990','107 min',7.8,'Rob Reiner',184740),
('Awakenings','Biography, Drama','The victims of an encephalitis epidemic many years ago have been catatonic ever since, but now a new drug offers the prospect of reviving them.','1990','121 min',7.8,'Penny Marshall',125276),
('Majo no takkyûbin','Animation, Adventure, Drama','A young witch, on her mandatory year of independent life, finds fitting into a new community difficult while she supports herself by running an air courier service.','1989','103 min',7.8,'Hayao Miyazaki',124193),
('Glory','Biography, Drama, History','Robert Gould Shaw leads the U.S. Civil War''s first all-black volunteer company, fighting prejudices from both his own Union Army, and the Confederates.','1989','122 min',7.8,'Edward Zwick',122779),
('Dip huet seung hung','Action, Crime, Drama','A disillusioned assassin accepts one last hit in hopes of using his earnings to restore vision to a singer he accidentally blinded.','1989','111 min',7.8,'John Woo',45624),
('Back to the Future Part II','Adventure, Comedy, Sci-Fi','After visiting 2015, Marty McFly must repeat his visit to 1955 to prevent disastrous changes to 1985...without interfering with his first trip.','1989','108 min',7.8,'Robert Zemeckis',481918),
('Mississippi Burning','Crime, Drama, History','Two F.B.I. Agents with wildly different styles arrive in Mississippi to investigate the disappearance of some civil rights activists.','1988','128 min',7.8,'Alan Parker',88214),
('Predator','Action, Adventure, Sci-Fi','A team of commandos on a mission in a Central American jungle find themselves hunted by an extraterrestrial warrior.','1987','107 min',7.8,'John McTiernan',371387),
('The Last Emperor','Biography, Drama, History','The story of the final Emperor of China.','1987','163 min',7.7,'Bernardo Bertolucci',94326),
('Evil Dead II','Action, Comedy, Fantasy','The lone survivor of an onslaught of flesh-possessing spirits holes up in a cabin with a group of strangers while the demons continue their attack.','1987','84 min',7.8,'Sam Raimi',148359);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Ferris Bueller''s Day Off','Comedy','A high school wise guy is determined to have a day off from school, despite what the Principal thinks of that.','1986','103 min',7.8,'John Hughes',321382),
('Down by Law','Comedy, Crime, Drama','Two men are framed and sent to jail, where they meet a murderer who helps them escape and leave the state.','1986','107 min',7.8,'Jim Jarmusch',47834),
('The Goonies','Adventure, Comedy, Family','A group of young misfits called The Goonies discover an ancient map and set out on an adventure to find a legendary pirate''s long-lost treasure.','1985','114 min',7.8,'Richard Donner',244430),
('The Color Purple','Drama','A black Southern woman struggles to find her identity after suffering abuse from her father and others over four decades.','1985','154 min',7.8,'Steven Spielberg',78321),
('The Breakfast Club','Comedy, Drama','Five high school students meet in Saturday detention and discover how they have a lot more in common than they thought.','1985','97 min',7.8,'John Hughes',357026),
('The Killing Fields','Biography, Drama, History','A journalist is trapped in Cambodia during tyrant Pol Pot''s bloody ''Year Zero'' cleansing campaign, which claimed the lives of two million ''undesirable'' civilians.','1984','141 min',7.8,'Roland Joffé',51585),
('Ghostbusters','Action, Comedy, Fantasy','Three former parapsychology professors set up shop as a unique ghost removal service.','1984','105 min',7.8,'Ivan Reitman',355413),
('The Right Stuff','Adventure, Biography, Drama','The story of the original Mercury 7 astronauts and their macho, seat-of-the-pants approach to the space program.','1983','193 min',7.8,'Philip Kaufman',56235),
('The King of Comedy','Comedy, Crime, Drama','Rupert Pupkin is a passionate yet unsuccessful comic who craves nothing more than to be in the spotlight and to achieve this, he stalks and kidnaps his idol to take the spotlight for himself.','1982','109 min',7.8,'Martin Scorsese',88511),
('E.T. the Extra-Terrestrial','Family, Sci-Fi','A troubled child summons the courage to help a friendly alien escape Earth and return to his home world.','1982','115 min',7.8,'Steven Spielberg',372490);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Kramer vs. Kramer','Drama','Ted Kramer''s wife leaves him, allowing for a lost bond to be rediscovered between Ted and his son, Billy. But a heated custody battle ensues over the divorced couple''s son, deepening the wounds left by the separation.','1979','105 min',7.8,'Robert Benton',133351),
('Days of Heaven','Drama, Romance','A hot-tempered farm laborer convinces the woman he loves to marry their rich but dying boss so that they can have a claim to his fortune.','1978','94 min',7.8,'Terrence Malick',52852),
('The Outlaw Josey Wales','Western','Missouri farmer Josey Wales joins a Confederate guerrilla unit and winds up on the run from the Union soldiers who murdered his family.','1976','135 min',7.8,'Clint Eastwood',65659),
('The Man Who Would Be King','Adventure, History, War','Two British former soldiers decide to set themselves up as Kings in Kafiristan, a land where no white man has set foot since Alexander the Great.','1975','129 min',7.8,'John Huston',44917),
('The Conversation','Drama, Mystery, Thriller','A paranoid, secretive surveillance expert has a crisis of conscience when he suspects that the couple he is spying on will be murdered.','1974','113 min',7.8,'Francis Ford Coppola',98611),
('La planète sauvage','Animation, Sci-Fi','On a faraway planet where blue giants rule, oppressed humanoids rebel against their machine-like leaders.','1973','72 min',7.8,'René Laloux',25229),
('The Day of the Jackal','Crime, Drama, Thriller','A professional assassin codenamed "Jackal" plots to kill Charles de Gaulle, the President of France.','1973','143 min',7.8,'Fred Zinnemann',37445),
('Badlands','Action, Crime, Drama','An impressionable teenage girl from a dead-end town and her older greaser boyfriend embark on a killing spree in the South Dakota badlands.','1973','94 min',7.8,'Terrence Malick',66009),
('Cabaret','Drama, Music, Musical','A female girlie club entertainer in Weimar Republic era Berlin romances two men while the Nazi Party rises to power around them.','1972','124 min',7.8,'Bob Fosse',48334),
('Willy Wonka & the Chocolate Factory','Family, Fantasy, Musical','A poor but hopeful boy seeks one of the five coveted golden tickets that will send him on a tour of Willy Wonka''s mysterious chocolate factory.','1971','100 min',7.8,'Mel Stuart',178731);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Midnight Cowboy','Drama','A naive hustler travels from Texas to New York City to seek personal fortune, finding a new friend in the process.','1969','113 min',7.8,'John Schlesinger',101124),
('Wait Until Dark','Thriller','A recently blinded woman is terrorized by a trio of thugs while they search for a heroin-stuffed doll they believe is in her apartment.','1967','108 min',7.8,'Terence Young',27733),
('Guess Who''s Coming to Dinner','Comedy, Drama','A couple''s attitudes are challenged when their daughter introduces them to her African-American fiancé.','1967','108 min',7.8,'Stanley Kramer',39642),
('Bonnie and Clyde','Action, Biography, Crime','Bored waitress Bonnie Parker falls in love with an ex-con named Clyde Barrow and together they start a violent crime spree through the country, stealing cars and robbing banks.','1967','111 min',7.8,'Arthur Penn',102415),
('My Fair Lady','Drama, Family, Musical','Snobbish phonetics Professor Henry Higgins agrees to a wager that he can make flower girl Eliza Doolittle presentable in high society.','1964','170 min',7.8,'George Cukor',86525),
('Mary Poppins','Comedy, Family, Fantasy','In turn of the century London, a magical nanny employs music and adventure to help two neglected children become closer to their father.','1964','139 min',7.8,'Robert Stevenson',158029),
('The Longest Day','Action, Drama, History','The events of D-Day, told on a grand scale from both the Allied and German points of view.','1962','178 min',7.8,'Ken Annakin',52141),
('Jules et Jim','Drama, Romance','Decades of a love triangle concerning two friends and an impulsive woman.','1962','105 min',7.8,'François Truffaut',37605),
('The Innocents','Horror','A young governess for two children becomes convinced that the house and grounds are haunted.','1961','100 min',7.8,'Jack Clayton',27007),
('À bout de souffle','Crime, Drama','A small-time thief steals a car and impulsively murders a motorcycle policeman. Wanted by the authorities, he reunites with a hip American journalism student and attempts to persuade her to run away with him to Italy.','1960','90 min',7.8,'Jean-Luc Godard',73251);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Red River','Action, Adventure, Drama','Dunson leads a cattle drive, the culmination of over 14 years of work, to its destination in Missouri. But his tyrannical behavior along the way causes a mutiny, led by his adopted son.','1948','133 min',7.8,'Howard Hawks',28167),
('Key Largo','Action, Crime, Drama','A man visits his war buddy''s family hotel and finds a gangster running things. As a hurricane approaches, the two end up confronting each other.','1948','100 min',7.8,'John Huston',36995),
('To Have and Have Not','Adventure, Comedy, Film-Noir','During World War II, American expatriate Harry Morgan helps transport a French Resistance leader and his beautiful wife to Martinique while romancing a sensuous lounge singer.','1944','100 min',7.8,'Howard Hawks',31053),
('Shadow of a Doubt','Film-Noir, Thriller','A young girl, overjoyed when her favorite uncle comes to visit the family, slowly begins to suspect that he is in fact the "Merry Widow" killer sought by the authorities.','1943','108 min',7.8,'Alfred Hitchcock',59556),
('Stagecoach','Adventure, Drama, Western','A group of people traveling on a stagecoach find their journey complicated by the threat of Geronimo and learn something about each other in the process.','1939','96 min',7.8,'John Ford',43621),
('The Lady Vanishes','Mystery, Thriller','While travelling in continental Europe, a rich young playgirl realizes that an elderly lady seems to have disappeared from the train.','1938','96 min',7.8,'Alfred Hitchcock',47400),
('Bringing Up Baby','Comedy, Family, Romance','While trying to secure a $1 million donation for his museum, a befuddled paleontologist is pursued by a flighty and often irritating heiress and her pet leopard, Baby.','1938','102 min',7.8,'Howard Hawks',55163),
('Bride of Frankenstein','Drama, Horror, Sci-Fi','Mary Shelley reveals the main characters of her novel survived: Dr. Frankenstein, goaded by an even madder scientist, builds his monster a mate.','1935','75 min',7.8,'James Whale',43542),
('Duck Soup','Comedy, Musical, War','Rufus T. Firefly is named president/dictator of bankrupt Freedonia and declares war on neighboring Sylvania over the love of wealthy Mrs. Teasdale.','1933','69 min',7.8,'Leo McCarey',55581),
('Scarface: The Shame of the Nation','Action, Crime, Drama','An ambitious and nearly insane violent gangster climbs the ladder of success in the mob, but his weaknesses prove to be his downfall.','1932','93 min',7.8,'Howard Hawks',25312);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Frankenstein','Drama, Horror, Sci-Fi','Dr. Frankenstein dares to tamper with life and death by creating a human monster out of lifeless body parts.','1931','70 min',7.8,'James Whale',65341),
('Roma','Drama','A year in the life of a middle-class family''s maid in Mexico City in the early 1970s.','2018','135 min',7.7,'Alfonso Cuarón',140375),
('God''s Own Country','Drama, Romance','Spring. Yorkshire. Young farmer Johnny Saxby numbs his daily frustrations with binge drinking and casual sex, until the arrival of a Romanian migrant worker for lambing season ignites an intense relationship that sets Johnny on a new path.','2017','104 min',7.7,'Francis Lee',25198),
('Deadpool 2','Action, Adventure, Comedy','Foul-mouthed mutant mercenary Wade Wilson (a.k.a. Deadpool), brings together a team of fellow mutant rogues to protect a young boy with supernatural abilities from the brutal, time-traveling cyborg Cable.','2018','119 min',7.7,'David Leitch',478586),
('Wind River','Crime, Drama, Mystery','A veteran hunter helps an FBI agent investigate the murder of a young woman on a Wyoming Native American reservation.','2017','107 min',7.7,'Taylor Sheridan',205444),
('Get Out','Horror, Mystery, Thriller','A young African-American visits his white girlfriend''s parents for the weekend, where his simmering uneasiness about their reception of him eventually reaches a boiling point.','2017','104 min',7.7,'Jordan Peele',492851),
('Mission: Impossible - Fallout','Action, Adventure, Thriller','Ethan Hunt and his IMF team, along with some familiar allies, race against time after a mission gone wrong.','2018','147 min',7.7,'Christopher McQuarrie',291257),
('En man som heter Ove','Comedy, Drama, Romance','Ove, an ill-tempered, isolated retiree who spends his days enforcing block association rules and visiting his wife''s grave, has finally given up on life just as an unlikely friendship develops with his boisterous new neighbors.','2015','116 min',7.7,'Hannes Holm',47444),
('What We Do in the Shadows','Comedy, Horror','Viago, Deacon and Vladislav are vampires who are finding that modern life has them struggling with the mundane - like paying rent, keeping up with the chore wheel, trying to get into nightclubs and overcoming flatmate conflicts.','2014','86 min',7.7,'Jemaine Clement',157498),
('Omoide no Mânî','Animation, Drama, Family','Due to 12 y.o. Anna''s asthma, she''s sent to stay with relatives of her guardian in the Japanese countryside. She likes to be alone, sketching. She befriends Marnie. Who is the mysterious, blonde Marnie.','2014','103 min',7.7,'James Simone',32798);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('The Theory of Everything','Biography, Drama, Romance','A look at the relationship between the famous physicist Stephen Hawking and his wife.','2014','123 min',7.7,'James Marsh',404182),
('Kingsman: The Secret Service','Action, Adventure, Comedy','A spy organisation recruits a promising street kid into the agency''s training program, while a global threat emerges from a twisted tech genius.','2014','129 min',7.7,'Matthew Vaughn',590440),
('The Fault in Our Stars','Drama, Romance','Two teenage cancer patients begin a life-affirming journey to visit a reclusive author in Amsterdam.','2014','126 min',7.7,'Josh Boone',344312),
('Me and Earl and the Dying Girl','Comedy, Drama','High schooler Greg, who spends most of his time making parodies of classic movies with his co-worker Earl, finds his outlook forever altered after befriending a classmate who has just been diagnosed with cancer.','2015','105 min',7.7,'Alfonso Gomez-Rejon',123210),
('Birdman or (The Unexpected Virtue of Ignorance)','Comedy, Drama','A washed-up superhero actor attempts to revive his fading career by writing, directing, and starring in a Broadway production.','2014','119 min',7.7,'Alejandro G. Iñárritu',580291),
('La vie d''Adèle','Drama, Romance','Adèle''s life is changed when she meets Emma, a young woman with blue hair, who will allow her to discover desire and to assert herself as a woman and as an adult. In front of others, Adèle grows, seeks herself, loses herself, and ultimately finds herself through love and loss.','2013','180 min',7.7,'Abdellatif Kechiche',138741),
('Kai po che!','Drama, Sport','Three friends growing up in India at the turn of the millennium set out to open a training academy to produce the country''s next cricket stars.','2013','130 min',7.7,'Abhishek Kapoor',32628),
('The Broken Circle Breakdown','Drama, Music, Romance','Elise and Didier fall in love at first sight, in spite of their differences. He talks, she listens. He''s a romantic atheist, she''s a religious realist. When their daughter becomes seriously ill, their love is put on trial.','2012','111 min',7.7,'Felix van Groeningen',39379),
('Captain America: The Winter Soldier','Action, Adventure, Sci-Fi','As Steve Rogers struggles to embrace his role in the modern world, he teams up with a fellow Avenger and S.H.I.E.L.D agent, Black Widow, to battle a new threat from history: an assassin known as the Winter Soldier.','2014','136 min',7.7,'Anthony Russo',736182),
('Rockstar','Drama, Music, Musical','Janardhan Jakhar chases his dreams of becoming a big Rock star, during which he falls in love with Heer.','2011','159 min',7.7,'Imtiaz Ali',39501);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Empire of the Sun','Action, Drama, History','A young English boy struggles to survive under Japanese occupation during World War II.','1987','153 min',7.7,'Steven Spielberg',115677),
('Nebraska','Adventure, Comedy, Drama','An aging, booze-addled father makes the trip from Montana to Nebraska with his estranged son in order to claim a million-dollar Mega Sweepstakes Marketing prize.','2013','115 min',7.7,'Alexander Payne',112298),
('Wreck-It Ralph','Animation, Adventure, Comedy','A video game villain wants to be a hero and sets out to fulfill his dream, but his quest brings havoc to the whole arcade where he lives.','2012','101 min',7.7,'Rich Moore',380195),
('Le Petit Prince','Animation, Adventure, Drama','A little girl lives in a very grown-up world with her mother, who tries to prepare her for it. Her neighbor, the Aviator, introduces the girl to an extraordinary world where anything is possible, the world of the Little Prince.','2015','108 min',7.7,'Mark Osborne',56720),
('Detachment','Drama','A substitute teacher who drifts from classroom to classroom finds a connection to the students and teachers during his latest assignment.','2011','98 min',7.7,'Tony Kaye',77071),
('Midnight in Paris','Comedy, Fantasy, Romance','While on a trip to Paris with his fiancée''s family, a nostalgic screenwriter finds himself mysteriously going back to the 1920s every day at midnight.','2011','96 min',7.7,'Woody Allen',388089),
('The Lego Movie','Animation, Action, Adventure','An ordinary LEGO construction worker, thought to be the prophesied as "special", is recruited to join a quest to stop an evil tyrant from gluing the LEGO universe into eternal stasis.','2014','100 min',7.7,'Christopher Miller',323982),
('Gravity','Drama, Sci-Fi, Thriller','Two astronauts work together to survive after an accident leaves them stranded in space.','2013','91 min',7.7,'Alfonso Cuarón',769145),
('Star Trek Into Darkness','Action, Adventure, Sci-Fi','After the crew of the Enterprise find an unstoppable force of terror from within their own organization, Captain Kirk leads a manhunt to a war-zone world to capture a one-man weapon of mass destruction.','2013','132 min',7.7,'J.J. Abrams',463188),
('Beasts of No Nation','Drama, War','A drama based on the experiences of Agu, a child soldier fighting in the civil war of an unnamed African country.','2015','137 min',7.7,'Cary Joji Fukunaga',73964);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('The Social Network','Biography, Drama','As Harvard student Mark Zuckerberg creates the social networking site that would become known as Facebook, he is sued by the twins who claimed he stole their idea, and by the co-founder who was later squeezed out of the business.','2010','120 min',7.7,'David Fincher',624982),
('X: First Class','Action, Adventure, Sci-Fi','In the 1960s, superpowered humans Charles Xavier and Erik Lensherr work together to find others like them, but Erik''s vengeful pursuit of an ambitious mutant who ruined his life causes a schism to divide them.','2011','131 min',7.7,'Matthew Vaughn',645512),
('The Hangover','Comedy','Three buddies wake up from a bachelor party in Las Vegas, with no memory of the previous night and the bachelor missing. They make their way around the city in order to find their friend before his wedding.','2009','100 min',7.7,'Todd Phillips',717559),
('Skyfall','Action, Adventure, Thriller','James Bond''s loyalty to M is tested when her past comes back to haunt her. When MI6 comes under attack, 007 must track down and destroy the threat, no matter how personal the cost.','2012','143 min',7.7,'Sam Mendes',630614),
('Silver Linings Playbook','Comedy, Drama, Romance','After a stint in a mental institution, former teacher Pat Solitano moves back in with his parents and tries to reconcile with his ex-wife. Things get more challenging when Pat meets Tiffany, a mysterious girl with problems of her own.','2012','122 min',7.7,'David O. Russell',661871),
('Argo','Biography, Drama, Thriller','Acting under the cover of a Hollywood producer scouting a location for a science fiction film, a CIA agent launches a dangerous operation to rescue six Americans in Tehran during the U.S. hostage crisis in Iran in 1979.','2012','120 min',7.7,'Ben Affleck',572581),
('(500) Days of Summer','Comedy, Drama, Romance','An offbeat romantic comedy about a woman who doesn''t believe true love exists, and the young man who falls for her.','2009','95 min',7.7,'Marc Webb',472242),
('Harry Potter and the Deathly Hallows: Part 1','Adventure, Family, Fantasy','As Harry, Ron, and Hermione race against time and evil to destroy the Horcruxes, they uncover the existence of the three most powerful objects in the wizarding world: the Deathly Hallows.','2010','146 min',7.7,'David Yates',479120),
('Gake no ue no Ponyo','Animation, Adventure, Comedy','A five-year-old boy develops a relationship with Ponyo, a young goldfish princess who longs to become a human after falling in love with him.','2008','101 min',7.7,'Hayao Miyazaki',125317),
('Frost/Nixon','Biography, Drama, History','A dramatic retelling of the post-Watergate television interviews between British talk-show host David Frost and former president Richard Nixon.','2008','122 min',7.7,'Ron Howard',103330);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Papurika','Animation, Drama, Fantasy','When a machine that allows therapists to enter their patients'' dreams is stolen, all Hell breaks loose. Only a young female therapist, Paprika, can stop it.','2006','90 min',7.7,'Satoshi Kon',71379),
('Changeling','Biography, Crime, Drama','Grief-stricken mother Christine Collins (Angelina Jolie) takes on the L.A.P.D. to her own detriment when it tries to pass off an obvious impostor as her missing child.','2008','141 min',7.7,'Clint Eastwood',239203),
('Flipped','Comedy, Drama, Romance','Two eighth-graders start to have feelings for each other despite being total opposites.','2010','90 min',7.7,'Rob Reiner',81446),
('Toki o kakeru shôjo','Animation, Adventure, Comedy','A high-school girl named Makoto acquires the power to travel back in time, and decides to use it for her own personal benefits. Little does she know that she is affecting the lives of others just as much as she is her own.','2006','98 min',7.7,'Mamoru Hosoda',60368),
('Death Note: Desu nôto','Crime, Drama, Fantasy','A battle between the world''s two greatest minds begins when Light Yagami finds the Death Note, a notebook with the power to kill, and decides to rid the world of criminals.','2006','126 min',7.7,'Shûsuke Kaneko',28630),
('This Is England','Crime, Drama','A young boy becomes friends with a gang of skinheads. Friends soon become like family, and relationships will be pushed to the very limit.','2006','101 min',7.7,'Shane Meadows',115576),
('Ex Machina','Drama, Sci-Fi, Thriller','A young programmer is selected to participate in a ground-breaking experiment in synthetic intelligence by evaluating the human qualities of a highly advanced humanoid A.I.','2014','108 min',7.7,'Alex Garland',474141),
('Efter brylluppet','Drama','A manager of an orphanage in India is sent to Copenhagen, Denmark, where he discovers a life-altering family secret.','2006','120 min',7.7,'Susanne Bier',32001),
('The Last King of Scotland','Biography, Drama, History','Based on the events of the brutal Ugandan dictator Idi Amin''s regime as seen by his personal physician during the 1970s.','2006','123 min',7.7,'Kevin Macdonald',175355),
('Der Name der Rose','Crime, Drama, Mystery','An intellectually nonconformist friar investigates a series of mysterious deaths in an isolated abbey.','1986','130 min',7.7,'Jean-Jacques Annaud',102031);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Zodiac','Crime, Drama, Mystery','In the late 1960s/early 1970s, a San Francisco cartoonist becomes an amateur detective obsessed with tracking down the Zodiac Killer, an unidentified individual who terrorizes Northern California with a killing spree.','2007','157 min',7.7,'David Fincher',466080),
('Lucky Number Slevin','Action, Crime, Drama','A case of mistaken identity lands Slevin into the middle of a war being plotted by two of the city''s most rival crime bosses. Under constant surveillance by Detective Brikowski and assassin Goodkat, he must get them before they get him.','2006','110 min',7.7,'Paul McGuigan',299524),
('Joyeux Noël','Drama, History, Music','In December 1914, an unofficial Christmas truce on the Western Front allows soldiers from opposing sides of the First World War to gain insight into each other''s way of life.','2005','116 min',7.7,'Christian Carion',28003),
('Control','Biography, Drama, Music','A profile of Ian Curtis, the enigmatic singer of Joy Division whose personal, professional, and romantic troubles led him to commit suicide at the age of 23.','2007','122 min',7.7,'Anton Corbijn',61609),
('Tangled','Animation, Adventure, Comedy','The magically long-haired Rapunzel has spent her entire life in a tower, but now that a runaway thief has stumbled upon her, she is about to discover the world for the first time, and who she really is.','2010','100 min',7.7,'Nathan Greno',405922),
('Zwartboek','Drama, Thriller, War','In the Nazi-occupied Netherlands during World War II, a Jewish singer infiltrates the regional Gestapo headquarters for the Dutch resistance.','2006','145 min',7.7,'Paul Verhoeven',72643),
('Brokeback Mountain','Drama, Romance','The story of a forbidden and secretive relationship between two cowboys, and their lives over the years.','2005','134 min',7.7,'Ang Lee',323103),
('3:10 to Yuma','Action, Crime, Drama','A small-time rancher agrees to hold a captured outlaw who''s awaiting a train to go to court in Yuma. A battle of wills ensues as the outlaw tries to psych out the rancher.','2007','122 min',7.7,'James Mangold',288797),
('Crash','Crime, Drama, Thriller','Los Angeles citizens with vastly separate lives collide in interweaving stories of race, loss and redemption.','2004','112 min',7.7,'Paul Haggis',419483),
('Kung fu','Action, Comedy, Fantasy','In Shanghai, China in the 1940s, a wannabe gangster aspires to join the notorious "Axe Gang" while residents of a housing complex exhibit extraordinary powers in defending their turf.','2004','99 min',7.7,'Stephen Chow',127250);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('The Bourne Supremacy','Action, Mystery, Thriller','When Jason Bourne is framed for a CIA operation gone awry, he is forced to resume his former life as a trained assassin to survive.','2004','108 min',7.7,'Paul Greengrass',434841),
('The Machinist','Drama, Thriller','An industrial worker who hasn''t slept in a year begins to doubt his own sanity.','2004','101 min',7.7,'Brad Anderson',358432),
('Ray','Biography, Drama, Music','The story of the life and career of the legendary rhythm and blues musician Ray Charles, from his humble beginnings in the South, where he went blind at age seven, to his meteoric rise to stardom during the 1950s and 1960s.','2004','152 min',7.7,'Taylor Hackford',138356),
('Lost in Translation','Comedy, Drama','A faded movie star and a neglected young woman form an unlikely bond after crossing paths in Tokyo.','2003','102 min',7.7,'Sofia Coppola',415074),
('Harry Potter and the Goblet of Fire','Adventure, Family, Fantasy','Harry Potter finds himself competing in a hazardous tournament between rival schools of magic, but he is distracted by recurring nightmares.','2005','157 min',7.7,'Mike Newell',548619),
('Man on Fire','Action, Crime, Drama','In Mexico City, a former CIA operative swears vengeance on those who committed an unspeakable act against the family he was hired to protect.','2004','146 min',7.7,'Tony Scott',329592),
('Coraline','Animation, Drama, Family','An adventurous 11-year-old girl finds another world that is a strangely idealized version of her frustrating home, but it has sinister secrets.','2009','100 min',7.7,'Henry Selick',197761),
('The Last Samurai','Action, Drama','An American military advisor embraces the Samurai culture he was hired to destroy after he is captured in battle.','2003','154 min',7.7,'Edward Zwick',400049),
('The Magdalene Sisters','Drama','Three young Irish women struggle to maintain their spirits while they endure dehumanizing abuse as inmates of a Magdalene Sisters Asylum.','2002','114 min',7.7,'Peter Mullan',25938),
('Good Bye Lenin!','Comedy, Drama, Romance','In 1990, to protect his fragile mother from a fatal shock after a long coma, a young man must keep her from learning that her beloved nation of East Germany as she knew it has disappeared.','2003','121 min',7.7,'Wolfgang Becker',137981);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('In America','Drama','A family of Irish immigrants adjust to life on the mean streets of Hell''s Kitchen while also grieving the death of a child.','2002','105 min',7.7,'Jim Sheridan',40403),
('I Am Sam','Drama','A mentally handicapped man fights for custody of his 7-year-old daughter and in the process teaches his cold-hearted lawyer the value of love and family.','2001','132 min',7.7,'Jessie Nelson',142863),
('Adaptation.','Comedy, Drama','A lovelorn screenwriter becomes desperate as he tries and fails to adapt ''The Orchid Thief'' by Susan Orlean for the screen.','2002','115 min',7.7,'Spike Jonze',178565),
('Black Hawk Down','Drama, History, War','160 elite U.S. soldiers drop into Somalia to capture two top lieutenants of a renegade warlord and find themselves in a desperate battle with a large force of heavily-armed Somalis.','2001','144 min',7.7,'Ridley Scott',364254),
('Road to Perdition','Crime, Drama, Thriller','A mob enforcer''s son witnesses a murder, forcing him and his father to take to the road, and his father down a path of redemption and revenge.','2002','117 min',7.7,'Sam Mendes',246840),
('Das Experiment','Drama, Thriller','For two weeks, 20 male participants are hired to play prisoners and guards in a prison. The "prisoners" have to follow seemingly mild rules, and the "guards" are told to retain order without using physical violence.','2001','120 min',7.7,'Oliver Hirschbiegel',90842),
('Billy Elliot','Drama, Music','A talented young boy becomes torn between his unexpected love of dance and the disintegration of his family.','2000','110 min',7.7,'Stephen Daldry',126770),
('Hedwig and the Angry Inch','Comedy, Drama, Music','A gender-queer punk-rock singer from East Berlin tours the U.S. with her band as she tells her life story and follows the former lover/band-mate who stole her songs.','2001','95 min',7.7,'John Cameron Mitchell',31957),
('Ocean''s Eleven','Crime, Thriller','Danny Ocean and his ten accomplices plan to rob three Las Vegas casinos simultaneously.','2001','116 min',7.7,'Steven Soderbergh',516372),
('Vampire Hunter D: Bloodlust','Animation, Action, Fantasy','When a girl is abducted by a vampire, a legendary bounty hunter is hired to bring her back.','2000','103 min',7.7,'Yoshiaki Kawajiri',29210);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('O Brother, Where Art Thou?','Adventure, Comedy, Crime','In the deep south during the 1930s, three escaped convicts search for hidden treasure while a relentless lawman pursues them.','2000','107 min',7.7,'Joel Coen',286742),
('Interstate 60: Episodes of the Road','Adventure, Comedy, Drama','Neal Oliver, a very confused young man and an artist, takes a journey of a lifetime on a highway I60 that doesn''t exist on any of the maps, going to the places he never even heard of, searching for an answer and his dreamgirl.','2002','116 min',7.7,'Bob Gale',29999),
('South Park: Bigger, Longer & Uncut','Animation, Comedy, Fantasy','When Stan Marsh and his friends go see an R-rated movie, they start cursing and their parents think that Canada is to blame.','1999','81 min',7.7,'Trey Parker',192112),
('Office Space','Comedy','Three company workers who hate their jobs decide to rebel against their greedy boss.','1999','89 min',7.7,'Mike Judge',241575),
('Happiness','Comedy, Drama','The lives of several individuals intertwine as they go about their lives in their own unique ways, engaging in acts society as a whole might find disturbing in a desperate search for human connection.','1998','134 min',7.7,'Todd Solondz',66408),
('Training Day','Crime, Drama, Thriller','A rookie cop spends his first day as a Los Angeles narcotics officer with a rogue detective who isn''t what he appears to be.','2001','122 min',7.7,'Antoine Fuqua',390247),
('Rushmore','Comedy, Drama, Romance','The extracurricular king of Rushmore Preparatory School is put on academic probation.','1998','93 min',7.7,'Wes Anderson',169229),
('Abre los ojos','Drama, Mystery, Sci-Fi','A very handsome man finds the love of his life, but he suffers an accident and needs to have his face rebuilt by surgery after it is severely disfigured.','1997','119 min',7.7,'Alejandro Amenábar',64082),
('Being John Malkovich','Comedy, Drama, Fantasy','A puppeteer discovers a portal that leads literally into the head of movie star John Malkovich.','1999','113 min',7.7,'Spike Jonze',312542),
('As Good as It Gets','Comedy, Drama, Romance','A single mother and waitress, a misanthropic author, and a gay artist form an unlikely friendship after the artist is assaulted in a robbery.','1997','139 min',7.7,'James L. Brooks',275755);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('The Fifth Element','Action, Adventure, Sci-Fi','In the colorful future, a cab driver unwittingly becomes the central figure in the search for a legendary cosmic weapon to keep Evil and Mr. Zorg at bay.','1997','126 min',7.7,'Luc Besson',434125),
('Le dîner de cons','Comedy','A few friends have a weekly fools'' dinner, where each brings a fool along. Pierre finds a champion fool for next dinner. Surprise.','1998','80 min',7.7,'Francis Veber',37424),
('Donnie Brasco','Biography, Crime, Drama','An FBI undercover agent infiltrates the mob and finds himself identifying more with the mafia life, at the expense of his regular one.','1997','127 min',7.7,'Mike Newell',279318),
('Shine','Biography, Drama, Music','Pianist David Helfgott, driven by his father and teachers, has a breakdown. Years later he returns to the piano, to popular if not critical acclaim.','1996','105 min',7.7,'Scott Hicks',51350),
('Primal Fear','Crime, Drama, Mystery','An altar boy is accused of murdering a priest, and the truth is buried several layers deep.','1996','129 min',7.7,'Gregory Hoblit',189716),
('Hamlet','Drama','Hamlet, Prince of Denmark, returns home to find his father murdered and his mother remarrying the murderer, his uncle. Meanwhile, war is brewing.','1996','242 min',7.7,'Kenneth Branagh',35991),
('A Little Princess','Drama, Family, Fantasy','A young girl is relegated to servitude at a boarding school when her father goes missing and is presumed dead.','1995','97 min',7.7,'Alfonso Cuarón',32236),
('Do lok tin si','Comedy, Crime, Drama','This Hong Kong-set crime drama follows the lives of a hitman, hoping to get out of the business, and his elusive female partner.','1995','99 min',7.7,'Kar-Wai Wong',26429),
('Il postino','Biography, Comedy, Drama','A simple Italian postman learns to love poetry while delivering mail to a famous poet, and then uses this to woo local beauty Beatrice.','1994','108 min',7.7,'Michael Radford',33600),
('Clerks','Comedy','A day in the lives of two convenience clerks named Dante and Randal as they annoy customers, discuss movies, and play hockey on the store roof.','1994','92 min',7.7,'Kevin Smith',211450);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Short Cuts','Comedy, Drama','The day-to-day lives of several suburban Los Angeles residents.','1993','188 min',7.7,'Robert Altman',42275),
('Philadelphia','Drama','When a man with HIV is fired by his law firm because of his condition, he hires a homophobic small time lawyer as the only willing advocate for a wrongful dismissal suit.','1993','125 min',7.7,'Jonathan Demme',224169),
('The Muppet Christmas Carol','Comedy, Drama, Family','The Muppet characters tell their version of the classic tale of an old and bitter miser''s redemption on Christmas Eve.','1992','85 min',7.7,'Brian Henson',50298),
('Malcolm X','Biography, Drama, History','Biographical epic of the controversial and influential Black Nationalist leader, from his early life and career as a small-time gangster, to his ministry as a member of the Nation of Islam.','1992','202 min',7.7,'Spike Lee',85819),
('The Last of the Mohicans','Action, Adventure, Drama','Three trappers protect the daughters of a British Colonel in the midst of the French and Indian War.','1992','112 min',7.7,'Michael Mann',150409),
('Kurenai no buta','Animation, Adventure, Comedy','In 1930s Italy, a veteran World War I pilot is cursed to look like an anthropomorphic pig.','1992','94 min',7.7,'Hayao Miyazaki',77798),
('Glengarry Glen Ross','Crime, Drama, Mystery','An examination of the machinations behind the scenes at a real estate office.','1992','100 min',7.7,'James Foley',95826),
('A Few Good Men','Drama, Thriller','Military lawyer Lieutenant Daniel Kaffee defends Marines accused of murder. They contend they were acting under orders.','1992','138 min',7.7,'Rob Reiner',235388),
('Fried Green Tomatoes','Drama','A housewife who is unhappy with her life befriends an old lady in a nursing home and is enthralled by the tales she tells of people she used to know.','1991','130 min',7.7,'Jon Avnet',66941),
('Barton Fink','Comedy, Drama, Thriller','A renowned New York playwright is enticed to California to write for the movies and discovers the hellish truth of Hollywood.','1991','116 min',7.7,'Joel Coen',113240);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Miller''s Crossing','Crime, Drama, Thriller','Tom Reagan, an advisor to a Prohibition-era crime boss, tries to keep the peace between warring mobs but gets caught in divided loyalties.','1990','115 min',7.7,'Joel Coen',125822),
('Who Framed Roger Rabbit','Animation, Adventure, Comedy','A toon-hating detective is a cartoon rabbit''s only hope to prove his innocence when he is accused of murder.','1988','104 min',7.7,'Robert Zemeckis',182009),
('Spoorloos','Mystery, Thriller','Rex and Saskia, a young couple in love, are on vacation. They stop at a busy service station and Saskia is abducted. After three years and no sign of Saskia, Rex begins receiving letters from the abductor.','1988','107 min',7.7,'George Sluizer',33982),
('Withnail & I','Comedy, Drama','In 1969, two substance-abusing, unemployed actors retreat to the countryside for a holiday that proves disastrous.','1987','107 min',7.7,'Bruce Robinson',40396),
('Blue Velvet','Drama, Mystery, Thriller','The discovery of a severed human ear found in a field leads a young man on an investigation related to a beautiful, mysterious nightclub singer and a group of psychopathic criminals who have kidnapped her child.','1986','120 min',7.7,'David Lynch',181285),
('The Purple Rose of Cairo','Comedy, Fantasy, Romance','In New Jersey in 1935, a movie character walks off the screen and into the real world.','1985','82 min',7.7,'Woody Allen',47102),
('After Hours','Comedy, Crime, Drama','An ordinary word processor has the worst night of his life after he agrees to visit a girl in Soho who he met that evening at a coffee shop.','1985','97 min',7.7,'Martin Scorsese',59635),
('Zelig','Comedy','"Documentary" about a man who can look and act like whoever he''s around, and meets various famous people.','1983','79 min',7.7,'Woody Allen',39881),
('The Verdict','Drama','A lawyer sees the chance to salvage his career and self-respect by taking a medical malpractice case to trial rather than settling.','1982','129 min',7.7,'Sidney Lumet',36096),
('Star Trek II: The Wrath of Khan','Action, Adventure, Sci-Fi','With the assistance of the Enterprise crew, Admiral Kirk must stop an old nemesis, Khan Noonien Singh, from using the life-generating Genesis Device as the ultimate weapon.','1982','113 min',7.7,'Nicholas Meyer',112704);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('First Blood','Action, Adventure','A veteran Green Beret is forced by a cruel Sheriff and his deputies to flee into the mountains and wage an escalating one-man war against his pursuers.','1982','93 min',7.7,'Ted Kotcheff',226541),
('Ordinary People','Drama','The accidental death of the older son of an affluent family deeply strains the relationships among the bitter mother, the good-natured father, and the guilt-ridden younger son.','1980','124 min',7.7,'Robert Redford',47099),
('Airplane!','Comedy','A man afraid to fly must ensure that a plane lands safely after the pilots become sick.','1980','88 min',7.7,'Jim Abrahams',214882),
('Rupan sansei: Kariosutoro no shiro','Animation, Adventure, Family','A dashing thief, his gang of desperadoes and an intrepid policeman struggle to free a princess from an evil count''s clutches, and learn the hidden secret to a fabulous treasure that she holds part of a key to.','1979','100 min',7.7,'Hayao Miyazaki',27014),
('Halloween','Horror, Thriller','Fifteen years after murdering his sister on Halloween night 1963, Michael Myers escapes from a mental hospital and returns to the small town of Haddonfield, Illinois to kill again.','1978','91 min',7.7,'John Carpenter',233106),
('Le locataire','Drama, Thriller','A bureaucrat rents a Paris apartment where he finds himself drawn into a rabbit hole of dangerous paranoia.','1976','126 min',7.7,'Roman Polanski',39889),
('Love and Death','Comedy, War','In czarist Russia, a neurotic soldier and his distant cousin formulate a plot to assassinate Napoleon.','1975','85 min',7.7,'Woody Allen',36037),
('The Taking of Pelham One Two Three','Action, Crime, Thriller','In New York, armed men hijack a subway car and demand a ransom for the passengers. Even if it''s paid, how could they get away?','1974','104 min',7.7,'Joseph Sargent',26729),
('Blazing Saddles','Comedy, Western','In order to ruin a western town, a corrupt politician appoints a black Sheriff, who promptly becomes his most formidable adversary.','1974','93 min',7.7,'Mel Brooks',125993),
('Serpico','Biography, Crime, Drama','An honest New York cop named Frank Serpico blows the whistle on rampant corruption in the force only to have his comrades turn against him.','1973','130 min',7.7,'Sidney Lumet',109941);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Enter the Dragon','Action, Crime, Drama','A secret agent comes to an opium lord''s island fortress with other fighters for a martial-arts tournament.','1973','102 min',7.7,'Robert Clouse',96561),
('Deliverance','Adventure, Drama, Thriller','Intent on seeing the Cahulawassee River before it''s dammed and turned into a lake, outdoor fanatic Lewis Medlock takes his friends on a canoeing trip they''ll never forget into the dangerous American back-country.','1972','109 min',7.7,'John Boorman',98740),
('The French Connection','Action, Crime, Drama','A pair of NYC cops in the Narcotics Bureau stumble onto a drug smuggling job with a French connection.','1971','104 min',7.7,'William Friedkin',110075),
('Dirty Harry','Action, Crime, Thriller','When a madman calling himself "the Scorpio Killer" menaces the city, tough-as-nails San Francisco Police Inspector "Dirty" Harry Callahan is assigned to track down and ferret out the crazed psychopath.','1971','102 min',7.7,'Don Siegel',143292),
('Where Eagles Dare','Action, Adventure, War','Allied agents stage a daring raid on a castle where the Nazis are holding American brigadier general George Carnaby prisoner, but that''s not all that''s really going on.','1968','158 min',7.7,'Brian G. Hutton',51913),
('The Odd Couple','Comedy','Two friends try sharing an apartment, but their ideas of housekeeping and lifestyles are as different as night and day.','1968','105 min',7.7,'Gene Saks',31572),
('The Dirty Dozen','Action, Adventure, War','During World War II, a rebellious U.S. Army Major is assigned a dozen convicted murderers to train and lead them into a mass assassination mission of German officers.','1967','150 min',7.7,'Robert Aldrich',67183),
('Belle de jour','Drama, Romance','A frigid young housewife decides to spend her midweek afternoons as a prostitute.','1967','100 min',7.7,'Luis Buñuel',40274),
('A Man for All Seasons','Biography, Drama, History','The story of Sir Thomas More, who stood up to King Henry VIII when the King rejected the Roman Catholic Church to obtain a divorce and remarry.','1966','120 min',7.7,'Fred Zinnemann',31222),
('Repulsion','Drama, Horror, Thriller','A sex-repulsed woman who disapproves of her sister''s boyfriend sinks into depression and has horrific visions of rape and violence.','1965','105 min',7.7,'Roman Polanski',48883);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Zulu','Drama, History, War','Outnumbered British soldiers do battle with Zulu warriors at Rorke''s Drift.','1964','138 min',7.7,'Cy Endfield',35999),
('Goldfinger','Action, Adventure, Thriller','While investigating a gold magnate''s smuggling, James Bond uncovers a plot to contaminate the Fort Knox gold reserve.','1964','110 min',7.7,'Guy Hamilton',174119),
('The Birds','Drama, Horror, Mystery','A wealthy San Francisco socialite pursues a potential boyfriend to a small Northern California town that slowly takes a turn for the bizarre when birds of all kinds suddenly begin to attack people.','1963','119 min',7.7,'Alfred Hitchcock',171739),
('Cape Fear','Drama, Thriller','A lawyer''s family is stalked by a man he once helped put in jail.','1962','106 min',7.7,'J. Lee Thompson',26457),
('Peeping Tom','Drama, Horror, Thriller','A young man murders women, using a movie camera to film their dying expressions of terror.','1960','101 min',7.7,'Michael Powell',31354),
('The Magnificent Seven','Action, Adventure, Western','Seven gunfighters are hired by Mexican peasants to liberate their village from oppressive bandits.','1960','128 min',7.7,'John Sturges',87719),
('Les yeux sans visage','Drama, Horror','A surgeon causes an accident which leaves his daughter disfigured, and goes to extremes to give her a new face.','1960','90 min',7.7,'Georges Franju',27620),
('Invasion of the Body Snatchers','Drama, Horror, Sci-Fi','A small-town doctor learns that the population of his community is being replaced by emotionless alien duplicates.','1956','80 min',7.7,'Don Siegel',44839),
('Rebel Without a Cause','Drama','A rebellious young man with a troubled past comes to a new town, finding friends and enemies.','1955','111 min',7.7,'Nicholas Ray',83363),
('The Ladykillers','Comedy, Crime','Five oddball criminals planning a bank robbery rent rooms on a cul-de-sac from an octogenarian widow under the pretext that they are classical musicians.','1955','91 min',7.7,'Alexander Mackendrick',26464);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Sabrina','Comedy, Drama, Romance','A playboy becomes interested in the daughter of his family''s chauffeur, but it''s his more serious brother who would be the better man for her.','1954','113 min',7.7,'Billy Wilder',59415),
('The Quiet Man','Comedy, Drama, Romance','A retired American boxer returns to the village of his birth in Ireland, where he falls for a spirited redhead whose brother is contemptuous of their union.','1952','129 min',7.7,'John Ford',34677),
('The Day the Earth Stood Still','Drama, Sci-Fi','An alien lands and tells the people of Earth that they must live peacefully or be destroyed as a danger to other planets.','1951','92 min',7.7,'Robert Wise',76315),
('The African Queen','Adventure, Drama, Romance','In WWI Africa, a gin-swilling riverboat captain is persuaded by a strait-laced missionary to use his boat to attack an enemy warship.','1951','105 min',7.7,'John Huston',71481),
('Gilda','Drama, Film-Noir, Romance','A small-time gambler hired to work in a Buenos Aires casino discovers his employer''s new wife is his former lover.','1946','110 min',7.7,'Charles Vidor',27991),
('Fantasia','Animation, Family, Fantasy','A collection of animated interpretations of great works of Western classical music.','1940','125 min',7.7,'James Algar',88662),
('The Invisible Man','Horror, Sci-Fi','A scientist finds a way of becoming invisible, but in doing so, he becomes murderously insane.','1933','71 min',7.7,'James Whale',30683),
('Dark Waters','Biography, Drama, History','A corporate defense attorney takes on an environmental lawsuit against a chemical company that exposes a lengthy history of pollution.','2019','126 min',7.6,'Todd Haynes',60408),
('Searching','Drama, Mystery, Thriller','After his teenage daughter goes missing, a desperate father tries to find clues on her laptop.','2018','102 min',7.6,'Aneesh Chaganty',140840),
('Once Upon a Time... in Hollywood','Comedy, Drama','A faded television actor and his stunt double strive to achieve fame and success in the final years of Hollywood''s Golden Age in 1969 Los Angeles.','2019','161 min',7.6,'Quentin Tarantino',551309);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Nelyubov','Drama','A couple going through a divorce must team up to find their son who has disappeared during one of their bitter arguments.','2017','127 min',7.6,'Andrey Zvyagintsev',29765),
('The Florida Project','Drama','Set over one summer, the film follows precocious six-year-old Moonee as she courts mischief and adventure with her ragtag playmates and bonds with her rebellious but caring mother, all while living in the shadows of Walt Disney World.','2017','111 min',7.6,'Sean Baker',95181),
('Just Mercy','Biography, Crime, Drama','World-renowned civil rights defense attorney Bryan Stevenson works to free a wrongly condemned death row prisoner.','2019','137 min',7.6,'Destin Daniel Cretton',46739),
('Gifted','Drama','Frank, a single man raising his child prodigy niece Mary, is drawn into a custody battle with his mother.','2017','101 min',7.6,'Marc Webb',99643),
('The Peanut Butter Falcon','Adventure, Comedy, Drama','Zak runs away from his care home to make his dream of becoming a wrestler come true.','2019','97 min',7.6,'Tyler Nilson',66346),
('Victoria','Crime, Drama, Romance','A young Spanish woman who has recently moved to Berlin finds her flirtation with a local guy turn potentially deadly as their night out with his friends reveals a dangerous secret.','2015','138 min',7.6,'Sebastian Schipper',52903),
('Mustang','Drama','When five orphan girls are seen innocently playing with boys on a beach, their scandalized conservative guardians confine them while forced marriages are arranged.','2015','97 min',7.6,'Deniz Gamze Ergüven',35785),
('Guardians of the Galaxy Vol. 2','Action, Adventure, Comedy','The Guardians struggle to keep together as a team while dealing with their personal family issues, notably Star-Lord''s encounter with his father the ambitious celestial being Ego.','2017','136 min',7.6,'James Gunn',569974),
('Baby Driver','Action, Crime, Drama','After being coerced into working for a crime boss, a young getaway driver finds himself taking part in a heist doomed to fail.','2017','113 min',7.6,'Edgar Wright',439406),
('Only the Brave','Action, Biography, Drama','Based on the true story of the Granite Mountain Hotshots, a group of elite firefighters who risk everything to protect a town from a historic wildfire.','2017','134 min',7.6,'Joseph Kosinski',58371);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Bridge of Spies','Drama, History, Thriller','During the Cold War, an American lawyer is recruited to defend an arrested Soviet spy in court, and then help the CIA facilitate an exchange of the spy for the Soviet captured American U2 spy plane pilot, Francis Gary Powers.','2015','142 min',7.6,'Steven Spielberg',287659),
('Incredibles 2','Animation, Action, Adventure','The Incredibles family takes on a new mission which involves a change in family roles: Bob Parr (Mr. Incredible) must manage the house while his wife Helen (Elastigirl) goes out to save the world.','2018','118 min',7.6,'Brad Bird',250057),
('Moana','Animation, Adventure, Comedy','In Ancient Polynesia, when a terrible curse incurred by the Demigod Maui reaches Moana''s island, she answers the Ocean''s call to seek out the Demigod to set things right.','2016','107 min',7.6,'Ron Clements',272784),
('Sicario','Action, Crime, Drama','An idealistic FBI agent is enlisted by a government task force to aid in the escalating war against drugs at the border area between the U.S. and Mexico.','2015','121 min',7.6,'Denis Villeneuve',371291),
('Creed','Drama, Sport','The former World Heavyweight Champion Rocky Balboa serves as a trainer and mentor to Adonis Johnson, the son of his late friend and former rival Apollo Creed.','2015','133 min',7.6,'Ryan Coogler',247666),
('Leviafan','Crime, Drama','In a Russian coastal town, Kolya is forced to fight the corrupt mayor when he is told that his house will be demolished. He recruits a lawyer friend to help, but the man''s arrival brings further misfortune for Kolya and his family.','2014','140 min',7.6,'Andrey Zvyagintsev',49397),
('Hell or High Water','Action, Crime, Drama','A divorced father and his ex-con older brother resort to a desperate scheme in order to save their family''s ranch in West Texas.','2016','102 min',7.6,'David Mackenzie',204175),
('Philomena','Biography, Comedy, Drama','A world-weary political journalist picks up the story of a woman''s search for her son, who was taken away from her decades ago after she became pregnant and was forced to live in a convent.','2013','98 min',7.6,'Stephen Frears',94212),
('Dawn of the Planet of the Apes','Action, Adventure, Drama','A growing nation of genetically evolved apes led by Caesar is threatened by a band of human survivors of the devastating virus unleashed a decade earlier.','2014','130 min',7.6,'Matt Reeves',411599),
('El cuerpo','Mystery, Thriller','A detective searches for the body of a femme fatale which has gone missing from a morgue.','2012','112 min',7.6,'Oriol Paulo',57549);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Serbuan maut','Action, Thriller','A S.W.A.T. team becomes trapped in a tenement run by a ruthless mobster and his army of killers and thugs.','2011','101 min',7.6,'Gareth Evans',190531),
('End of Watch','Action, Crime, Drama','Shot documentary-style, this film follows the daily grind of two young police officers in LA who are partners and friends, and what happens when they meet criminal forces greater than themselves.','2012','109 min',7.6,'David Ayer',228132),
('Kari-gurashi no Arietti','Animation, Adventure, Family','The Clock family are four-inch-tall people who live anonymously in another family''s residence, borrowing simple items to make their home. Life changes for the Clocks when their teenage daughter, Arrietty, is discovered.','2010','94 min',7.6,'Hiromasa Yonebayashi',80939),
('A Star Is Born','Drama, Music, Romance','A musician helps a young singer find fame as age and alcoholism send his own career into a downward spiral.','2018','136 min',7.6,'Bradley Cooper',334312),
('True Grit','Drama, Western','A stubborn teenager enlists the help of a tough U.S. Marshal to track down her father''s murderer.','2010','110 min',7.6,'Ethan Coen',311822),
('Hævnen','Drama, Romance','The lives of two Danish families cross each other, and an extraordinary but risky friendship comes into bud. But loneliness, frailty and sorrow lie in wait.','2010','118 min',7.6,'Susanne Bier',38491),
('Despicable Me','Animation, Comedy, Crime','When a criminal mastermind uses a trio of orphan girls as pawns for a grand scheme, he finds their love is profoundly changing him for the better.','2010','95 min',7.6,'Pierre Coffin',500851),
('50/50','Comedy, Drama, Romance','Inspired by a true story, a comedy centered on a 27-year-old guy who learns of his cancer diagnosis and his subsequent struggle to beat the disease.','2011','100 min',7.6,'Jonathan Levine',315426),
('Kick-Ass','Action, Comedy, Crime','Dave Lizewski is an unnoticed high school student and comic book fan who one day decides to become a superhero, even though he has no powers, training or meaningful reason to do so.','2010','117 min',7.6,'Matthew Vaughn',524081),
('Celda 211','Action, Adventure, Crime','The story of two men on different sides of a prison riot -- the inmate leading the rebellion and the young guard trapped in the revolt, who poses as a prisoner in a desperate attempt to survive the ordeal.','2009','113 min',7.6,'Daniel Monzón',63882);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Moneyball','Biography, Drama, Sport','Oakland A''s general manager Billy Beane''s successful attempt to assemble a baseball team on a lean budget by employing computer-generated analysis to acquire new players.','2011','133 min',7.6,'Bennett Miller',369529),
('La piel que habito','Drama, Horror, Thriller','A brilliant plastic surgeon, haunted by past tragedies, creates a type of synthetic skin that withstands any kind of damage. His guinea pig: a mysterious and volatile woman who holds the key to his obsession.','2011','120 min',7.6,'Pedro Almodóvar',138959),
('Zombieland','Adventure, Comedy, Fantasy','A shy student trying to reach his family in Ohio, a gun-toting tough guy trying to find the last Twinkie, and a pair of sisters trying to get to an amusement park join forces to travel across a zombie-filled America.','2009','88 min',7.6,'Ruben Fleischer',520041),
('Die Welle','Drama, Thriller','A high school teacher''s experiment to demonstrate to his students what life is like under a dictatorship spins horribly out of control when he forms a social unit with a life of its own.','2008','107 min',7.6,'Dennis Gansel',102742),
('Sherlock Holmes','Action, Adventure, Mystery','Detective Sherlock Holmes and his stalwart partner Watson engage in a battle of wits and brawn with a nemesis whose plot is a threat to all of England.','2009','128 min',7.6,'Guy Ritchie',583158),
('The Blind Side','Biography, Drama, Sport','The story of Michael Oher, a homeless and traumatized boy who became an All-American football player and first-round NFL draft pick with the help of a caring woman and her family.','2009','129 min',7.6,'John Lee Hancock',293266),
('The Visitor','Drama','A college professor travels to New York City to attend a conference and finds a young couple living in his apartment.','2007','104 min',7.6,'Tom McCarthy',41544),
('Seven Pounds','Drama','A man with a fateful secret embarks on an extraordinary journey of redemption by forever changing the lives of seven strangers.','2008','123 min',7.6,'Gabriele Muccino',286770),
('Eastern Promises','Action, Crime, Drama','A teenager who dies during childbirth leaves clues in her journal that could tie her child to a rape involving a violent Russian mob family.','2007','100 min',7.6,'David Cronenberg',227760),
('Stardust','Adventure, Family, Fantasy','In a countryside town bordering on a magical land, a young man makes a promise to his beloved that he''ll retrieve a fallen star by venturing into the magical realm.','2007','127 min',7.6,'Matthew Vaughn',255036);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('The Secret of Kells','Animation, Adventure, Family','A young boy in a remote medieval outpost under siege from barbarian raids is beckoned to adventure when a celebrated master illuminator arrives with an ancient book, brimming with secret wisdom and powers.','2009','71 min',7.6,'Tomm Moore',31779),
('Inside Man','Crime, Drama, Mystery','A police detective, a bank robber, and a high-power broker enter high-stakes negotiations after the criminal''s brilliant heist spirals into a hostage situation.','2006','129 min',7.6,'Spike Lee',339757),
('Gone Baby Gone','Crime, Drama, Mystery','Two Boston area detectives investigate a little girl''s kidnapping, which ultimately turns into a crisis both professionally and personally.','2007','114 min',7.6,'Ben Affleck',250590),
('La Vie En Rose','Biography, Drama, Music','Biopic of the iconic French singer Édith Piaf. Raised by her grandmother in a brothel, she was discovered while singing on a street corner at the age of 19. Despite her success, Piaf''s life was filled with tragedy.','2007','140 min',7.6,'Olivier Dahan',82781),
('Huo Yuan Jia','Action, Biography, Drama','A biography of Chinese Martial Arts Master Huo Yuanjia, who is the founder and spiritual guru of the Jin Wu Sports Federation.','2006','104 min',7.6,'Ronny Yu',72863),
('The Illusionist','Drama, Fantasy, Mystery','In turn-of-the-century Vienna, a magician uses his abilities to secure the love of a woman far above his social standing.','2006','110 min',7.6,'Neil Burger',354728),
('Dead Man''s Shoes','Crime, Drama, Thriller','A disaffected soldier returns to his hometown to get even with the thugs who brutalized his mentally-challenged brother years ago.','2004','90 min',7.6,'Shane Meadows',49728),
('Funny Games','Crime, Drama, Thriller','Two violent young men take a mother, father, and son hostage in their vacation cabin and force them to play sadistic "games" with one another for their own amusement.','1997','108 min',7.6,'Michael Haneke',65058),
('Harry Potter and the Half-Blood Prince','Action, Adventure, Family','As Harry Potter begins his sixth year at Hogwarts, he discovers an old book marked as "the property of the Half-Blood Prince" and begins to learn more about Lord Voldemort''s dark past.','2009','153 min',7.6,'David Yates',474827),
('300','Action, Drama','King Leonidas of Sparta and a force of 300 men fight the Persians at Thermopylae in 480 B.C.','2006','117 min',7.6,'Zack Snyder',732876);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Match Point','Drama, Romance, Thriller','At a turning point in his life, a former tennis pro falls for an actress who happens to be dating his friend and soon-to-be brother-in-law.','2005','124 min',7.6,'Woody Allen',206294),
('Watchmen','Action, Drama, Mystery','In 1985 where former superheroes exist, the murder of a colleague sends active vigilante Rorschach into his own sprawling investigation, uncovering something that could completely change the course of history as we know it.','2009','162 min',7.6,'Zack Snyder',500799),
('Lord of War','Action, Crime, Drama','An arms dealer confronts the morality of his work as he is being chased by an INTERPOL Agent.','2005','122 min',7.6,'Andrew Niccol',294140),
('Saw','Horror, Mystery, Thriller','Two strangers awaken in a room with no recollection of how they got there, and soon discover they''re pawns in a deadly game perpetrated by a notorious serial killer.','2004','103 min',7.6,'James Wan',379020),
('Synecdoche, New York','Drama','A theatre director struggles with his work, and the women in his life, as he creates a life-size replica of New York City inside a warehouse as part of his new play.','2008','124 min',7.6,'Charlie Kaufman',83158),
('Mysterious Skin','Drama','A teenage hustler and a young man obsessed with alien abductions cross paths, together discovering a horrible, liberating truth.','2004','105 min',7.6,'Gregg Araki',65939),
('Jeux d''enfants','Comedy, Drama, Romance','As adults, best friends Julien and Sophie continue the odd game they started as children -- a fearless competition to outdo one another with daring and outrageous stunts. While they often act out to relieve one another''s pain, their game might be a way to avoid the fact that they are truly meant for one another.','2003','93 min',7.6,'Yann Samuell',67360),
('Un long dimanche de fiançailles','Drama, Mystery, Romance','Tells the story of a young woman''s relentless search for her fiancé, who has disappeared from the trenches of the Somme during World War One.','2004','133 min',7.6,'Jean-Pierre Jeunet',70925),
('The Station Agent','Comedy, Drama','When his only friend dies, a man born with dwarfism moves to rural New Jersey to live a life of solitude, only to meet a chatty hot dog vendor and a woman dealing with her own personal loss.','2003','89 min',7.6,'Tom McCarthy',67370),
('21 Grams','Crime, Drama, Thriller','A freak accident brings together a critically ill mathematician, a grieving mother, and a born-again ex-con.','2003','124 min',7.6,'Alejandro G. Iñárritu',224545);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Boksuneun naui geot','Crime, Drama, Thriller','A recently laid off factory worker kidnaps his former boss'' friend''s daughter, hoping to use the ransom money to pay for his sister''s kidney transplant.','2002','129 min',7.6,'Chan-wook Park',62659),
('Finding Neverland','Biography, Drama, Family','The story of Sir J.M. Barrie''s friendship with a family who inspired him to create Peter Pan.','2004','106 min',7.6,'Marc Forster',198677),
('25th Hour','Drama','Cornered by the DEA, convicted New York drug dealer Montgomery Brogan reevaluates his life in the 24 remaining hours before facing a seven-year jail term.','2002','135 min',7.6,'Spike Lee',169708),
('The Butterfly Effect','Drama, Sci-Fi, Thriller','Evan Treborn suffers blackouts during significant events of his life. As he grows up, he finds a way to remember these lost memories and a supernatural way to alter his life by reading his journal.','2004','113 min',7.6,'Eric Bress',451479),
('28 Days Later...','Drama, Horror, Sci-Fi','Four weeks after a mysterious, incurable virus spreads throughout the UK, a handful of survivors try to find sanctuary.','2002','113 min',7.6,'Danny Boyle',376853),
('Batoru rowaiaru','Action, Adventure, Drama','In the future, the Japanese government captures a class of ninth-grade students and forces them to kill each other under the revolutionary "Battle Royale" act.','2000','114 min',7.6,'Kinji Fukasaku',169091),
('The Royal Tenenbaums','Comedy, Drama','The eccentric members of a dysfunctional family reluctantly gather under the same roof for various reasons.','2001','110 min',7.6,'Wes Anderson',266842),
('Y tu mamá también','Drama','In Mexico, two teenage boys and an attractive older woman embark on a road trip and learn a thing or two about life, friendship, sex, and each other.','2001','106 min',7.6,'Alfonso Cuarón',115827),
('Harry Potter and the Sorcerer''s Stone','Adventure, Family, Fantasy','An orphaned boy enrolls in a school of wizardry, where he learns the truth about himself, his family and the terrible evil that haunts the magical world.','2001','152 min',7.6,'Chris Columbus',658185),
('The Others','Horror, Mystery, Thriller','A woman who lives in her darkened old family house with her two photosensitive children becomes convinced that the home is haunted.','2001','101 min',7.6,'Alejandro Amenábar',337651);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Blow','Biography, Crime, Drama','The story of how George Jung, along with the Medellín Cartel headed by Pablo Escobar, established the American cocaine market in the 1970s in the United States.','2001','124 min',7.6,'Ted Demme',240714),
('Enemy at the Gates','Drama, History, War','A Russian and a German sniper play a game of cat-and-mouse during the Battle of Stalingrad.','2001','131 min',7.6,'Jean-Jacques Annaud',243729),
('Minority Report','Action, Crime, Mystery','In a future where a special police unit is able to arrest murderers before they commit their crimes, an officer from that unit is himself accused of a future murder.','2002','145 min',7.6,'Steven Spielberg',508417),
('The Hurricane','Biography, Drama, Sport','The story of Rubin ''Hurricane'' Carter, a boxer wrongly imprisoned for murder, and the people who aided in his fight to prove his innocence.','1999','146 min',7.6,'Norman Jewison',91557),
('American Psycho','Comedy, Crime, Drama','A wealthy New York City investment banking executive, Patrick Bateman, hides his alternate psychopathic ego from his co-workers and friends as he delves deeper into his violent, hedonistic fantasies.','2000','101 min',7.6,'Mary Harron',490062),
('Lola rennt','Crime, Drama, Thriller','After a botched money delivery, Lola has 20 minutes to come up with 100,000 Deutschmarks.','1998','81 min',7.6,'Tom Tykwer',188317),
('The Thin Red Line','Drama, War','Adaptation of James Jones'' autobiographical 1962 novel, focusing on the conflict at Guadalcanal during the second World War.','1998','170 min',7.6,'Terrence Malick',172710),
('Mulan','Animation, Adventure, Family','To save her father from death in the army, a young maiden secretly goes in his place and becomes one of China''s greatest heroines in the process.','1998','88 min',7.6,'Tony Bancroft',256906),
('Fear and Loathing in Las Vegas','Adventure, Comedy, Drama','An oddball journalist and his psychopathic lawyer travel to Las Vegas for a series of psychedelic escapades.','1998','118 min',7.6,'Terry Gilliam',259753),
('Dark City','Mystery, Sci-Fi, Thriller','A man struggles with memories of his past, which include a wife he cannot remember and a nightmarish world no one else ever seems to wake up from.','1998','100 min',7.6,'Alex Proyas',187927);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Sleepers','Crime, Drama, Thriller','After a prank goes disastrously wrong, a group of boys are sent to a detention center where they are brutalized. Thirteen years later, an unexpected random encounter with a former guard gives them a chance for revenge.','1996','147 min',7.6,'Barry Levinson',186734),
('Lost Highway','Mystery, Thriller','Anonymous videotapes presage a musician''s murder conviction, and a gangster''s girlfriend leads a mechanic astray.','1997','134 min',7.6,'David Lynch',131101),
('Sense and Sensibility','Drama, Romance','Rich Mr. Dashwood dies, leaving his second wife and her three daughters poor by the rules of inheritance. The two eldest daughters are the title opposites.','1995','136 min',7.6,'Ang Lee',102598),
('Die Hard: With a Vengeance','Action, Adventure, Thriller','John McClane and a Harlem store owner are targeted by German terrorist Simon in New York City, where he plans to rob the Federal Reserve Building.','1995','128 min',7.6,'John McTiernan',364420),
('Dead Man','Adventure, Drama, Fantasy','On the run after murdering a man, accountant William Blake encounters a strange aboriginal American man named Nobody who prepares him for his journey into the spiritual world.','1995','121 min',7.6,'Jim Jarmusch',90442),
('The Bridges of Madison County','Drama, Romance','Photographer Robert Kincaid wanders into the life of housewife Francesca Johnson for four days in the 1960s.','1995','135 min',7.6,'Clint Eastwood',73172),
('Apollo 13','Adventure, Drama, History','NASA must devise a strategy to return Apollo 13 to Earth safely after the spacecraft undergoes massive internal damage putting the lives of the three astronauts on board in jeopardy.','PG','140 min',7.6,'Ron Howard',269197),
('Trois couleurs: Blanc','Comedy, Drama, Romance','After his wife divorces him, a Polish immigrant plots to get even with her.','1994','92 min',7.6,'Krzysztof Kieslowski',64390),
('Falling Down','Action, Crime, Drama','An ordinary man frustrated with the various flaws he sees in society begins to psychotically and violently lash out against them.','1993','113 min',7.6,'Joel Schumacher',171640),
('Dazed and Confused','Comedy','The adventures of high school and junior high students on the last day of school in May 1976.','1993','102 min',7.6,'Richard Linklater',165465);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('My Cousin Vinny','Comedy, Crime','Two New Yorkers accused of murder in rural Alabama while on their way back to college call in the help of one of their cousins, a loudmouth lawyer with no trial experience.','1992','120 min',7.6,'Jonathan Lynn',107325),
('Omohide poro poro','Animation, Drama, Romance','A twenty-seven-year-old office worker travels to the countryside while reminiscing about her childhood in Tokyo.','1991','118 min',7.6,'Isao Takahata',27071),
('Delicatessen','Comedy, Crime','Post-apocalyptic surrealist black comedy about the landlord of an apartment building who occasionally prepares a delicacy for his odd tenants.','1991','99 min',7.6,'Marc Caro',80487),
('Home Alone','Comedy, Family','An eight-year-old troublemaker must protect his house from a pair of burglars when he is accidentally left home alone by his family during Christmas vacation.','1990','103 min',7.6,'Chris Columbus',488817),
('The Godfather: Part III','Crime, Drama','Follows Michael Corleone, now in his 60s, as he seeks to free his family from crime and find a suitable successor to his empire.','1990','162 min',7.6,'Francis Ford Coppola',359809),
('When Harry Met Sally...','Comedy, Drama, Romance','Harry and Sally have known each other for years, and are very good friends, but they fear sex would ruin the friendship.','1989','95 min',7.6,'Rob Reiner',195663),
('The Little Mermaid','Animation, Family, Fantasy','A mermaid princess makes a Faustian bargain in an attempt to become human and win a prince''s love.','1989','83 min',7.6,'Ron Clements',237696),
('The Naked Gun: From the Files of Police Squad!','Comedy, Crime','Incompetent police Detective Frank Drebin must foil an attempt to assassinate Queen Elizabeth II.','1988','85 min',7.6,'David Zucker',152871),
('Planes, Trains & Automobiles','Comedy, Drama','A man must struggle to travel home for Thanksgiving with a lovable oaf of a shower curtain ring salesman as his only companion.','1987','93 min',7.6,'John Hughes',124773),
('Lethal Weapon','Action, Crime, Thriller','Two newly paired cops who are complete opposites must put aside their differences in order to catch a gang of drug smugglers.','1987','109 min',7.6,'Richard Donner',236894);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Blood Simple','Crime, Drama, Thriller','The owner of a seedy small-town Texas bar discovers that one of his employees is having an affair with his wife. A chaotic chain of misunderstandings, lies and mischief ensues after he devises a plot to have them murdered.','1984','99 min',7.6,'Joel Coen',87745),
('On Golden Pond','Drama','Norman is a curmudgeon with an estranged relationship with his daughter Chelsea. At Golden Pond, he and his wife nevertheless agree to care for Billy, the son of Chelsea''s new boyfriend, and a most unexpected relationship blooms.','1981','109 min',7.6,'Mark Rydell',27650),
('Mad Max 2','Action, Adventure, Sci-Fi','In the post-apocalyptic Australian wasteland, a cynical drifter agrees to help a small, gasoline-rich community escape a horde of bandits.','1981','96 min',7.6,'George Miller',166588),
('The Warriors','Action, Crime, Thriller','In the near future, a charismatic leader summons the street gangs of New York City in a bid to take it over. When he is killed, The Warriors are falsely blamed and now must fight their way home while every other gang is hunting them down.','1979','92 min',7.6,'Walter Hill',93878),
('The Muppet Movie','Adventure, Comedy, Family','Kermit and his newfound friends trek across America to find success in Hollywood, but a frog legs merchant is after Kermit.','1979','95 min',7.6,'James Frawley',32802),
('Escape from Alcatraz','Action, Biography, Crime','Alcatraz is the most secure prison of its time. It is believed that no one can ever escape from it, until three daring men make a possible successful attempt at escaping from one of the most infamous prisons in the world.','1979','112 min',7.6,'Don Siegel',121731),
('Watership Down','Animation, Adventure, Drama','Hoping to escape destruction by human developers and save their community, a colony of rabbits, led by Hazel and Fiver, seek out a safe place to set up a new warren.','1978','91 min',7.6,'Martin Rosen',33656),
('Midnight Express','Biography, Crime, Drama','Billy Hayes, an American college student, is caught smuggling drugs out of Turkey and thrown into prison.','1978','121 min',7.6,'Alan Parker',73662),
('Close Encounters of the Third Kind','Drama, Sci-Fi','Roy Neary, an electric lineman, watches how his quiet and ordinary daily life turns upside down after a close encounter with a UFO.','1977','138 min',7.6,'Steven Spielberg',184966),
('The Long Goodbye','Comedy, Crime, Drama','Private investigator Philip Marlowe helps a friend out of a jam, but in doing so gets implicated in his wife''s murder.','1973','112 min',7.6,'Robert Altman',26337);
INSERT INTO mldb.movie (title,genre,overview,released_year,runtime,imdb_rating,director,no_of_votes) VALUES
('Giù la testa','Drama, War, Western','A low-life bandit and an I.R.A. explosives expert rebel against the government and become heroes of the Mexican Revolution.','1971','157 min',7.6,'Sergio Leone',30144),
('Kelly''s Heroes','Adventure, Comedy, War','A group of U.S. soldiers sneaks across enemy lines to get their hands on a secret stash of Nazi treasure.','1970','144 min',7.6,'Brian G. Hutton',45338),
('The Jungle Book','Animation, Adventure, Family','Bagheera the Panther and Baloo the Bear have a difficult time trying to convince a boy to leave the jungle for human civilization.','1967','78 min',7.6,'Wolfgang Reitherman',166409),
('Blowup','Drama, Mystery, Thriller','A fashion photographer unknowingly captures a death on film after following two lovers in a park.','1966','111 min',7.6,'Michelangelo Antonioni',56513),
('A Hard Day''s Night','Comedy, Music, Musical','Over two "typical" days in the life of The Beatles, the boys struggle to keep themselves and Sir Paul McCartney''s mischievous grandfather in check while preparing for a live television performance.','1964','87 min',7.6,'Richard Lester',40351),
('Breakfast at Tiffany''s','Comedy, Drama, Romance','A young New York socialite becomes interested in a young man who has moved into her apartment building, but her past threatens to get in the way.','1961','115 min',7.6,'Blake Edwards',166544),
('Giant','Drama, Western','Sprawling epic covering the life of a Texas cattle rancher and his family and associates.','1956','201 min',7.6,'George Stevens',34075),
('From Here to Eternity','Drama, Romance, War','In Hawaii in 1941, a private is cruelly punished for not boxing on his unit''s team, while his captain''s wife and second-in-command are falling in love.','1953','118 min',7.6,'Fred Zinnemann',43374),
('Lifeboat','Drama, War','Several survivors of a torpedoed merchant ship in World War II find themselves in the same lifeboat with one of the crew members of the U-boat that sank their ship.','1944','97 min',7.6,'Alfred Hitchcock',26471),
('The 39 Steps','Crime, Mystery, Thriller','A man in London tries to help a counter-espionage Agent. But when the Agent is killed, and the man stands accused, he must go on the run to save himself and stop a spy ring which is trying to steal top secret information.','1935','86 min',7.6,'Alfred Hitchcock',51853);
5. Performing semantic search on ML table
SELECT mldb.movie._id, mldb.movie.title, mldb.movie.overview, predictions.score
FROM mldb.movie
JOIN model.semantic_search
ON model.semantic_search.inputs = mldb.movie.overview
WHERE mldb.movie._id < 20
AND model.semantic_search.similar = 'gangster'
ORDER BY predictions.score DESC
| _id | title | overview | score |
|---|---|---|---|
| 7 | Pulp Fiction | The lives of two mob hitmen, a boxer, a gangster and his wife, and a pair of diner bandits intertwine in four tales of violence and redemption. | 0.61 |
| 16 | Goodfellas | The story of Henry Hill and his life in the mob, covering his relationship with his wife Karen Hill and his mob partners Jimmy Conway and Tommy DeVito in the Italian-American crime syndicate. | 0.39 |
| 10 | Fight Club | An insomniac office worker and a devil-may-care soapmaker form an underground fight club that evolves into something much, much more. | 0.39 |
6. Try More
As you can tell, semantic search allows us to search content in our data using the meaning of the word. Standard SQL queries are also supported so you can perform additional filtering using operators such as = and LIKE.
If you like to learn more machine learning database operations, please continue our guide for Predict Operations