ssarwar7's Movies

Moviecount: 527
Wasted Time 39 days 17 hours 32 min
Average Rating 6,829032
Average Length 110,45min

Seriescount: 19
Total Episodes: 1064
Wasted Time 27 days 19 hours 23 min
Average Rating 8,445455

Total Time Wasted 67 days 12 hours 55 min

Rating >= 8.5: 23
{ Rating = 9,2, Year = 1994, Title = The Shawshank Redemption }
{ Rating = 9,1, Year = 1972, Title = The Godfather }
{ Rating = 9,0, Year = 2008, Title = The Dark Knight }
{ Rating = 8,9, Year = 1994, Title = Pulp Fiction }
{ Rating = 8,8, Year = 2002, Title = Cidade de Deus }
{ Rating = 8,8, Year = 1990, Title = Goodfellas }
{ Rating = 8,8, Year = 1999, Title = Fight Club }
{ Rating = 8,7, Year = 1995, Title = The Usual Suspects }
{ Rating = 8,7, Year = 2000, Title = Memento }
{ Rating = 8,7, Year = 1999, Title = The Matrix }
{ Rating = 8,7, Year = 2001, Title = The Lord of the Rings: The Fellowship of the Ring }
{ Rating = 8,6, Year = 1994, Title = Léon }
{ Rating = 8,6, Year = 1998, Title = American History X }
{ Rating = 8,6, Year = 1995, Title = Se7en }
{ Rating = 8,6, Year = 1999, Title = American Beauty }
{ Rating = 8,6, Year = 1976, Title = Taxi Driver }
{ Rating = 8,6, Year = 2008, Title = WALL·E }
{ Rating = 8,5, Year = 2006, Title = Das Leben der Anderen }
{ Rating = 8,5, Year = 2006, Title = El laberinto del fauno }
{ Rating = 8,5, Year = 1998, Title = Saving Private Ryan }
{ Rating = 8,5, Year = 2006, Title = The Departed }
{ Rating = 8,5, Year = 2002, Title = The Pianist }
{ Rating = 8,5, Year = 2000, Title = Requiem for a Dream }

Rating <= 3.5: 11
{ Rating = 1,6, Year = 2002, Title = Ben & Arthur }
{ Rating = 1,6, Year = 2007, Title = Who's Your Caddy? }
{ Rating = 1,7, Year = 2008, Title = The Hottie & the Nottie }
{ Rating = 1,9, Year = 2006, Title = Surf School }
{ Rating = 2,2, Year = 2007, Title = Epic Movie }
{ Rating = 2,4, Year = 2007, Title = Seed }
{ Rating = 2,6, Year = 2006, Title = Date Movie }
{ Rating = 2,7, Year = 2007, Title = Bratz }
{ Rating = 3,0, Year = 2007, Title = Are We Done Yet? }
{ Rating = 3,4, Year = 2006, Title = Little Man }
{ Rating = 3,5, Year = 2006, Title = The Wicker Man }

Moviecount each year
{ Year = 2007, Count = 111, Example = The Bourne Ultimatum }
{ Year = 2006, Count = 93, Example = Apocalypto }
{ Year = 2005, Count = 62, Example = Revolver }
{ Year = 2008, Count = 59, Example = Chris Rock: Kill the Messenger - London, New
York, Johannesburg }
{ Year = 2004, Count = 55, Example = Chris Rock: Never Scared }
{ Year = 2003, Count = 32, Example = Oldboy }
{ Year = 2002, Count = 25, Example = Catch Me If You Can }
{ Year = 2000, Count = 16, Example = Memento }
{ Year = 2001, Count = 15, Example = Training Day }
{ Year = 1999, Count = 11, Example = Chris Rock: Bigger & Blacker }
{ Year = 1997, Count = 10, Example = L.A. Confidential }
{ Year = 1998, Count = 9, Example = American History X }
{ Year = 1995, Count = 7, Example = The Usual Suspects }
{ Year = 1996, Count = 5, Example = Chris Rock: Bring the Pain }
{ Year = 1994, Count = 4, Example = Léon }
{ Year = 1990, Count = 3, Example = Goodfellas }
{ Year = 1992, Count = 3, Example = Reservoir Dogs }
{ Year = 1993, Count = 3, Example = Carlito's Way }
{ Year = 1972, Count = 1, Example = The Godfather }
{ Year = 1976, Count = 1, Example = Taxi Driver }
{ Year = 1983, Count = 1, Example = Scarface }
{ Year = 1987, Count = 1, Example = Lethal Weapon }

Actor with most movies
{ Movies = 13, Actor = Samuel L. Jackson, Example = True Romance }
{ Movies = 12, Actor = Morgan Freeman, Example = The Dark Knight }
{ Movies = 11, Actor = Jason Statham, Example = Revolver }
{ Movies = 11, Actor = Will Smith, Example = The Pursuit of Happyness }
{ Movies = 10, Actor = Brad Pitt, Example = Ocean's Eleven }
{ Movies = 9, Actor = Al Pacino, Example = Carlito's Way }
{ Movies = 9, Actor = Leonardo DiCaprio, Example = Catch Me If You Can }
{ Movies = 9, Actor = Matt Damon, Example = The Bourne Identity }
{ Movies = 9, Actor = Bruce Willis, Example = 16 Blocks }
{ Movies = 9, Actor = Eugene Levy, Example = American Pie }
{ Movies = 9, Actor = Eddie Marsan, Example = Gangster No. 1 }
{ Movies = 8, Actor = Tom Hanks, Example = Catch Me If You Can }
{ Movies = 8, Actor = Tom Cruise, Example = Collateral }
{ Movies = 8, Actor = Christian Bale, Example = El maquinista }
{ Movies = 8, Actor = Denzel Washington, Example = Inside Man }
{ Movies = 8, Actor = George Clooney, Example = Ocean's Eleven }
{ Movies = 7, Actor = Chris Rock, Example = Chris Rock: Bigger & Blacker }
{ Movies = 7, Actor = Willem Dafoe, Example = Inside Man }
{ Movies = 7, Actor = Chiwetel Ejiofor, Example = Inside Man }
{ Movies = 7, Actor = Robert De Niro, Example = Casino }

Movies with Samuel L. Jackson
{ Year = 1994, Rating = 8,9, Title = Pulp Fiction }
{ Year = 2004, Rating = 8,1, Title = The Incredibles }
{ Year = 2004, Rating = 8,0, Title = Kill Bill: Vol. 2 }
{ Year = 1993, Rating = 7,9, Title = True Romance }
{ Year = 2006, Rating = 7,2, Title = Black Snake Moan }
{ Year = 1996, Rating = 7,2, Title = Sydney }
{ Year = 2005, Rating = 7,1, Title = Coach Carter }
{ Year = 2007, Rating = 7,1, Title = Resurrecting the Champ }
{ Year = 2007, Rating = 6,9, Title = 1408 }
{ Year = 2003, Rating = 5,9, Title = S.W.A.T. }
{ Year = 2008, Rating = 5,9, Title = Jumper }
{ Year = 2005, Rating = 5,4, Title = The Man }
{ Year = 2005, Rating = 4,1, Title = xXx: State of the Union }

Top 10 directors
{ Movies = 6, Director = Steven Spielberg, Example = Catch Me If You Can }
{ Movies = 6, Director = Martin Scorsese, Example = Casino }
{ Movies = 5, Director = Quentin Tarantino, Example = Kill Bill: Vol. 1 }
{ Movies = 4, Director = Michael Mann, Example = Collateral }
{ Movies = 4, Director = Guy Ritchie, Example = Revolver }
{ Movies = 4, Director = Robert Rodriguez, Example = Sin City }
{ Movies = 4, Director = Christopher Nolan, Example = The Dark Knight }
{ Movies = 4, Director = Joel Coen, Example = No Country for Old Men }
{ Movies = 4, Director = David Fincher, Example = Se7en }
{ Movies = 4, Director = Ridley Scott, Example = American Gangster }

Movies directed by Steven Spielberg
{ Year = 1998, Rating = 8,5, Title = Saving Private Ryan }
{ Year = 2002, Rating = 7,7, Title = Catch Me If You Can }
{ Year = 2002, Rating = 7,7, Title = Minority Report }
{ Year = 2004, Rating = 7,1, Title = The Terminal }
{ Year = 2008, Rating = 6,7, Title = Indiana Jones and the Kingdom of the Crystal Skull
}
{ Year = 2005, Rating = 6,6, Title = War of the Worlds }

Top 5 Genres
{ Count = 261, Genre = Drama, Example = Apocalypto }
{ Count = 225, Genre = Thriller, Example = Carlito's Way }
{ Count = 188, Genre = Crime, Example = Carlito's Way }
{ Count = 187, Genre = Comedy, Example = Chris Rock: Bigger & Blacker }
{ Count = 162, Genre = Action, Example = Apocalypto }

Runtime >= 2.5h: 27
{ Length = 194 min, Title = Titanic }
{ Length = 191 min, Title = Grindhouse }
{ Length = 188 min, Title = The Green Mile }
{ Length = 187 min, Title = King Kong }
{ Length = 178 min, Title = Casino }
{ Length = 178 min, Title = The Lord of the Rings: The Fellowship of the Ring }
{ Length = 175 min, Title = The Godfather }
{ Length = 171 min, Title = Heat }
{ Length = 170 min, Title = Saving Private Ryan }
{ Length = 170 min, Title = Scarface }
{ Length = 170 min, Title = The Aviator }
{ Length = 167 min, Title = Gangs of New York }
{ Length = 162 min, Title = Om Shanti Om }
{ Length = 160 min, Title = The Assassination of Jesse James by the Coward Robert
Ford }
{ Length = 158 min, Title = There Will Be Blood }
{ Length = 157 min, Title = Ali }
{ Length = 157 min, Title = American Gangster }
{ Length = 157 min, Title = Zodiac }
{ Length = 155 min, Title = Gladiator }
{ Length = 155 min, Title = Partner }
{ Length = 154 min, Title = Pulp Fiction }
{ Length = 154 min, Title = The Last Samurai }
{ Length = 153 min, Title = Chak De! India }
{ Length = 152 min, Title = The Dark Knight }
{ Length = 152 min, Title = Harry Potter and the Sorcerer's Stone }
{ Length = 151 min, Title = The Departed }
{ Length = 150 min, Title = The Pianist }

Non USA movies: 92
{ Countries = Australia, Title = Chopper }
{ Countries = Australia, UK, Title = The Proposition }
{ Countries = Austria, Germany, Title = Die Fälscher }
{ Countries = Brazil, Title = Cidade dos Homens }
{ Countries = Brazil, France, Title = Cidade de Deus }
{ Countries = Canada, Title = Pigs }
{ Countries = Canada, Title = Seed }
{ Countries = China, HongKong, Title = Kung fu }
{ Countries = Finland, Russia, Ukraine, Title = 9 rota }
{ Countries = France, Title = Léon }
{ Countries = France, Title = Taken }
{ Countries = France, Title = De battre mon coeur s'est arrêté }
{ Countries = France, Title = Taxi }
{ Countries = France, Title = 36 Quai des Orfèvres }
{ Countries = France, Title = Banlieue 13 }
{ Countries = France, Title = Naissance des pieuvres }
{ Countries = France, Title = Taxi 2 }
{ Countries = France, Title = Taxi 3 }
{ Countries = France, Title = Taxi 4 }
{ Countries = France, Title = Dobermann }
{ Countries = France, Austria, Germany, Italy, Title = Caché }
{ Countries = France, Germany, UK, Poland, Title = The Pianist }
{ Countries = France, UK, Title = Revolver }
{ Countries = France, UK, Germany, Title = Ali G Indahouse }
{ Countries = France, UK, Germany, Title = Son of Rambow }
{ Countries = Germany, Title = Das Leben der Anderen }
{ Countries = Germany, Title = Lola rennt }
{ Countries = Germany, Ireland, UK, Title = True North }
{ Countries = HongKong, China, Title = Ying xiong }
{ Countries = India, Title = Munnabhai M.B.B.S. }
{ Countries = India, Title = Race }
{ Countries = India, Title = Krazzy 4 }
{ Countries = India, Title = No Smoking }
{ Countries = India, Title = Awarapan }
{ Countries = India, Title = Chak De! India }
{ Countries = India, Title = Jhoom Barabar Jhoom }
{ Countries = India, Title = Om Shanti Om }
{ Countries = India, Title = Partner }
{ Countries = Iran, Title = Offside }
{ Countries = Italy, Title = Le conseguenze dell'amore }
{ Countries = Italy, Title = Gomorra }
{ Countries = Japan, Title = Ao no hono-o }
{ Countries = Japan, Title = Azumi }
{ Countries = Japan, Title = Azumi 2: Death or Love }
{ Countries = Japan, Title = Dare mo shiranai }
{ Countries = Kazakhstan, Russia, Mongolia, Germany, Title = Mongol }
{ Countries = Mexico, Spain, Title = El orfanato }
{ Countries = SouthKorea, Title = Oldboy }
{ Countries = SouthKorea, Title = Chinjeolhan geumjassi }
{ Countries = SouthKorea, Title = Dalkomhan insaeng }
{ Countries = SouthKorea, Title = Taegukgi hwinalrimyeo }
{ Countries = SouthKorea, Title = Salinui chueok }
{ Countries = SouthKorea, Title = Chugyeogja }
{ Countries = SouthKorea, Title = Mubangbi-dosi }
{ Countries = Spain, Title = El maquinista }
{ Countries = Spain, Title = Volver }
{ Countries = Sweden, Title = Låt den rätte komma in }
{ Countries = UK, Title = Layer Cake }
{ Countries = UK, Title = Lock, Stock and Two Smoking Barrels }
{ Countries = UK, Title = The Last King of Scotland }
{ Countries = UK, Title = This Is England }
{ Countries = UK, Title = Adulthood }
{ Countries = UK, Title = Bullet Boy }
{ Countries = UK, Title = Cashback }
{ Countries = UK, Title = Dead Man's Shoes }
{ Countries = UK, Title = Outlaw }
{ Countries = UK, Title = The Bank Job }
{ Countries = UK, Title = The Football Factory }
{ Countries = UK, Title = Boy A }
{ Countries = UK, Title = Kidulthood }
{ Countries = UK, Title = Notes on a Scandal }
{ Countries = UK, Title = RocknRolla }
{ Countries = UK, Title = Dirty Pretty Things }
{ Countries = UK, Title = Goal II: Living the Dream }
{ Countries = UK, Title = Harry Potter and the Sorcerer's Stone }
{ Countries = UK, Title = I Want Candy }
{ Countries = UK, Title = Life and Lyrics }
{ Countries = UK, Title = Run Fatboy Run }
{ Countries = UK, Title = Rise of the Footsoldier }
{ Countries = UK, Title = W Delta Z }
{ Countries = UK, France, Title = Atonement }
{ Countries = UK, France, Title = Hot Fuzz }
{ Countries = UK, France, Title = Shaun of the Dead }
{ Countries = UK, France, Germany, Title = Mr. Bean's Holiday }
{ Countries = UK, France, Italy, Title = The Queen }
{ Countries = UK, Germany, Title = The Constant Gardener }
{ Countries = UK, Germany, France, Title = Resident Evil }
{ Countries = UK, Germany, Ireland, Title = Gangster No. 1 }
{ Countries = UK, Germany, Spain, Lithuania, Title = Transsiberian }
{ Countries = UK, Ireland, Title = The Escapist }
{ Countries = UK, SouthAfrica, Title = Tsotsi }
{ Countries = UK, Spain, Title = The Business }

Top 10 countries
{ Count = 435, Country = USA, Example = Apocalypto }
{ Count = 86, Country = UK, Example = Revolver }
{ Count = 71, Country = Germany, Example = Crash }
{ Count = 41, Country = France, Example = Léon }
{ Count = 35, Country = Canada, Example = Eastern Promises }
{ Count = 16, Country = Australia, Example = Training Day }
{ Count = 12, Country = India, Example = Munnabhai M.B.B.S. }
{ Count = 7, Country = Spain, Example = El maquinista }
{ Count = 7, Country = SouthKorea, Example = Oldboy }
{ Count = 7, Country = Japan, Example = Ao no hono-o }

Top 10 languages
{ Count = 485, Language = English, Example = Carlito's Way }
{ Count = 60, Language = French, Example = Catch Me If You Can }
{ Count = 54, Language = Spanish, Example = Carlito's Way }
{ Count = 33, Language = German, Example = The Bourne Identity }
{ Count = 31, Language = Russian, Example = The Bourne Supremacy }
{ Count = 28, Language = Italian, Example = The Bourne Identity }
{ Count = 23, Language = Japanese, Example = Letters from Iwo Jima }
{ Count = 19, Language = Mandarin, Example = Crash }
{ Count = 14, Language = Hindi, Example = Harold & Kumar Go to White Castle }
{ Count = 13, Language = Korean, Example = Crash }

Top Movie of each year: 22
{ Year = 1972, Best = { Rating = 9,1, Title = The Godfather } }
{ Year = 1976, Best = { Rating = 8,6, Title = Taxi Driver } }
{ Year = 1983, Best = { Rating = 8,2, Title = Scarface } }
{ Year = 1987, Best = { Rating = 7,6, Title = Lethal Weapon } }
{ Year = 1990, Best = { Rating = 8,8, Title = Goodfellas } }
{ Year = 1992, Best = { Rating = 8,4, Title = Reservoir Dogs } }
{ Year = 1993, Best = { Rating = 7,9, Title = True Romance } }
{ Year = 1994, Best = { Rating = 9,2, Title = The Shawshank Redemption } }
{ Year = 1995, Best = { Rating = 8,7, Title = The Usual Suspects } }
{ Year = 1996, Best = { Rating = 8,3, Title = Chris Rock: Bring the Pain } }
{ Year = 1997, Best = { Rating = 8,4, Title = L.A. Confidential } }
{ Year = 1998, Best = { Rating = 8,6, Title = American History X } }
{ Year = 1999, Best = { Rating = 8,8, Title = Fight Club } }
{ Year = 2000, Best = { Rating = 8,7, Title = Memento } }
{ Year = 2001, Best = { Rating = 8,7, Title = The Lord of the Rings: The Fellowship of
the Ring } }
{ Year = 2002, Best = { Rating = 8,8, Title = Cidade de Deus } }
{ Year = 2003, Best = { Rating = 8,3, Title = Oldboy } }
{ Year = 2004, Best = { Rating = 8,4, Title = Hotel Rwanda } }
{ Year = 2005, Best = { Rating = 8,4, Title = Sin City } }
{ Year = 2006, Best = { Rating = 8,5, Title = Das Leben der Anderen } }
{ Year = 2007, Best = { Rating = 8,3, Title = No Country for Old Men } }
{ Year = 2008, Best = { Rating = 9,0, Title = The Dark Knight } }

SELECT Rating, Title FROM movies WHERE country = 'de' AND genre = 'comedy' ORDER
BY rating DESC
{ Rating = 7,3, Title = Tropic Thunder }
{ Rating = 7,3, Title = Team America: World Police }
{ Rating = 7,3, Title = Son of Rambow }
{ Rating = 7,2, Title = Harold & Kumar Go to White Castle }
{ Rating = 7,2, Title = Monsoon Wedding }
{ Rating = 7,1, Title = Find Me Guilty }
{ Rating = 7,0, Title = The Matador }
{ Rating = 6,8, Title = In Her Shoes }
{ Rating = 6,6, Title = Dodgeball: A True Underdog Story }
{ Rating = 6,3, Title = Just Friends }
{ Rating = 6,2, Title = American Wedding }
{ Rating = 6,1, Title = Van Wilder }
{ Rating = 6,1, Title = Mr. Bean's Holiday }
{ Rating = 6,0, Title = Shallow Hal }
{ Rating = 5,9, Title = Ali G Indahouse }
{ Rating = 5,4, Title = The Man }
{ Rating = 4,7, Title = Big Momma's House }
{ Rating = 4,6, Title = Boat Trip }

TV Series: 19
{ Year = 1997, Rating = 0,0, Episodes = 183, Title = "South Park" }
{ Year = 2004, Rating = 0,0, Episodes = 113, Title = "Desperate Housewives" }
{ Year = 2004, Rating = 0,0, Episodes = 96, Title = "Lost" }
{ Year = 2005, Rating = 8,1, Episodes = 91, Title = "Everybody Hates Chris" }
{ Year = 1999, Rating = 9,5, Episodes = 86, Title = "The Sopranos" }
{ Year = 2005, Rating = 0,0, Episodes = 79, Title = "Prison Break" }
{ Year = 2004, Rating = 0,0, Episodes = 66, Title = "Entourage" }
{ Year = 2000, Rating = 0,0, Episodes = 61, Title = "Curb Your Enthusiasm" }
{ Year = 2006, Rating = 0,0, Episodes = 60, Title = "Heroes" }
{ Year = 2006, Rating = 8,4, Episodes = 58, Title = "The Real Hustle" }
{ Year = 2004, Rating = 9,0, Episodes = 30, Title = "Hustle" }
{ Year = 2007, Rating = 8,8, Episodes = 26, Title = "Mad Men" }
{ Year = 2007, Rating = 9,0, Episodes = 22, Title = "The Flight of the Conchords" }
{ Year = 2002, Rating = 8,6, Episodes = 20, Title = "Cidade dos Homens" }
{ Year = 2005, Rating = 7,6, Episodes = 19, Title = "Balls of Steel" }
{ Year = 2006, Rating = 0,0, Episodes = 18, Title = "The IT Crowd" }
{ Year = 2007, Rating = 8,2, Episodes = 13, Title = "Fonejacker" }
{ Year = 2006, Rating = 8,2, Episodes = 13, Title = "Lucky Louie" }
{ Year = 2007, Rating = 7,5, Episodes = 10, Title = "Tell Me You Love Me" }

John_Robie's Movies

Moviecount: 183
Wasted Time 15 days 7 hours 2 min
Average Rating 7,457923
Average Length 120,34min

Total Time Wasted 15 days 7 hours 2 min

Rating >= 8.5: 25
{ Rating = 9,1, Year = 1972, Title = The Godfather }
{ Rating = 9,0, Year = 2008, Title = The Dark Knight }
{ Rating = 8,9, Year = 1975, Title = One Flew Over the Cuckoo's Nest }
{ Rating = 8,9, Year = 1994, Title = Pulp Fiction }
{ Rating = 8,9, Year = 1993, Title = Schindler's List }
{ Rating = 8,8, Year = 1942, Title = Casablanca }
{ Rating = 8,8, Year = 1999, Title = Fight Club }
{ Rating = 8,8, Year = 1954, Title = Rear Window }
{ Rating = 8,7, Year = 2000, Title = Memento }
{ Rating = 8,7, Year = 1960, Title = Psycho }
{ Rating = 8,7, Year = 1999, Title = The Matrix }
{ Rating = 8,7, Year = 1995, Title = The Usual Suspects }
{ Rating = 8,6, Year = 1999, Title = American Beauty }
{ Rating = 8,6, Year = 1979, Title = Apocalypse Now }
{ Rating = 8,6, Year = 1994, Title = Léon }
{ Rating = 8,6, Year = 1959, Title = North by Northwest }
{ Rating = 8,6, Year = 1995, Title = Se7en }
{ Rating = 8,6, Year = 2008, Title = Slumdog Millionaire }
{ Rating = 8,6, Year = 1958, Title = Vertigo }
{ Rating = 8,6, Year = 2008, Title = WALL·E }
{ Rating = 8,5, Year = 2006, Title = Das Leben der Anderen }
{ Rating = 8,5, Year = 2000, Title = Requiem for a Dream }
{ Rating = 8,5, Year = 1998, Title = Saving Private Ryan }
{ Rating = 8,5, Year = 2006, Title = The Departed }
{ Rating = 8,5, Year = 2002, Title = The Pianist }


Moviecount each year
{ Year = 2007, Count = 23, Example = 3:10 to Yuma }
{ Year = 2008, Count = 23, Example = 21 }
{ Year = 2005, Count = 14, Example = Batman Begins }
{ Year = 2006, Count = 14, Example = 16 Blocks }
{ Year = 2004, Count = 13, Example = Collateral }
{ Year = 2002, Count = 12, Example = Austin Powers in Goldmember }
{ Year = 2003, Count = 10, Example = 11:14 }
{ Year = 1997, Count = 9, Example = As Good as It Gets }
{ Year = 2000, Count = 8, Example = Almost Famous }
{ Year = 1995, Count = 6, Example = Casino }
{ Year = 2001, Count = 6, Example = American Pie 2 }
{ Year = 1996, Count = 5, Example = Fargo }
{ Year = 1999, Count = 4, Example = American Beauty }
{ Year = 1993, Count = 3, Example = In the Line of Fire }
{ Year = 1994, Count = 3, Example = Léon }
{ Year = 1954, Count = 2, Example = Dial M for Murder }
{ Year = 1955, Count = 2, Example = The Trouble with Harry }
{ Year = 1972, Count = 2, Example = Frenzy }
{ Year = 1979, Count = 2, Example = Apocalypse Now }
{ Year = 1998, Count = 2, Example = Armageddon }
{ Year = 2009, Count = 2, Example = The International }
{ Year = 1940, Count = 1, Example = Rebecca }
{ Year = 1942, Count = 1, Example = Casablanca }
{ Year = 1944, Count = 1, Example = Lifeboat }
{ Year = 1951, Count = 1, Example = Strangers on a Train }
{ Year = 1958, Count = 1, Example = Vertigo }
{ Year = 1959, Count = 1, Example = North by Northwest }
{ Year = 1960, Count = 1, Example = Psycho }
{ Year = 1963, Count = 1, Example = The Birds }
{ Year = 1964, Count = 1, Example = Marnie }
{ Year = 1966, Count = 1, Example = Torn Curtain }
{ Year = 1969, Count = 1, Example = Topaz }
{ Year = 1971, Count = 1, Example = Dirty Harry }
{ Year = 1975, Count = 1, Example = One Flew Over the Cuckoo's Nest }
{ Year = 1976, Count = 1, Example = Family Plot }
{ Year = 1980, Count = 1, Example = Flash Gordon }
{ Year = 1983, Count = 1, Example = Scarface }
{ Year = 1987, Count = 1, Example = Wall Street }
{ Year = 1992, Count = 1, Example = Reservoir Dogs }

Actor with most movies
{ Movies = 8, Actor = Tom Cruise, Example = Collateral }
{ Movies = 6, Actor = Brad Pitt, Example = Burn After Reading }
{ Movies = 5, Actor = Bruce Willis, Example = 16 Blocks }
{ Movies = 5, Actor = Laurence Fishburne, Example = 21 }
{ Movies = 5, Actor = Morgan Freeman, Example = Batman Begins }
{ Movies = 5, Actor = Leonardo DiCaprio, Example = Blood Diamond }
{ Movies = 5, Actor = Tom Hanks, Example = Catch Me If You Can }
{ Movies = 5, Actor = Al Pacino, Example = Heat }
{ Movies = 5, Actor = Matt Damon, Example = Saving Private Ryan }
{ Movies = 4, Actor = Christian Bale, Example = 3:10 to Yuma }
{ Movies = 4, Actor = Philip Seymour Hoffman, Example = Almost Famous }
{ Movies = 4, Actor = Josh Brolin, Example = American Gangster }
{ Movies = 4, Actor = Martin Sheen, Example = Apocalypse Now }
{ Movies = 4, Actor = Michael Caine, Example = Austin Powers in Goldmember }
{ Movies = 4, Actor = Mark Wahlberg, Example = Boogie Nights }
{ Movies = 4, Actor = George Clooney, Example = Burn After Reading }
{ Movies = 4, Actor = Judi Dench, Example = Casino Royale }
{ Movies = 4, Actor = Michael Madsen, Example = Die Another Day }
{ Movies = 4, Actor = Michelle Monaghan, Example = Gone Baby Gone }
{ Movies = 4, Actor = Clive Owen, Example = Inside Man }

Movies with Tom Cruise
{ Year = 2004, Rating = 7,8, Title = Collateral }
{ Year = 2002, Rating = 7,7, Title = Minority Report }
{ Year = 2008, Rating = 7,3, Title = Tropic Thunder }
{ Year = 2006, Rating = 6,9, Title = Mission: Impossible III }
{ Year = 1996, Rating = 6,8, Title = Mission: Impossible }
{ Year = 1993, Rating = 6,6, Title = The Firm }
{ Year = 2005, Rating = 6,6, Title = War of the Worlds }
{ Year = 2000, Rating = 5,7, Title = Mission: Impossible II }

Top 10 directors
{ Movies = 16, Director = Alfred Hitchcock, Example = Dial M for Murder }
{ Movies = 7, Director = Steven Spielberg, Example = Catch Me If You Can }
{ Movies = 6, Director = David Fincher, Example = Fight Club }
{ Movies = 4, Director = Christopher Nolan, Example = Batman Begins }
{ Movies = 4, Director = Quentin Tarantino, Example = Kill Bill: Vol. 1 }
{ Movies = 3, Director = Ridley Scott, Example = American Gangster }
{ Movies = 3, Director = Joel Coen, Example = Burn After Reading }
{ Movies = 3, Director = Wes Craven, Example = Scream }
{ Movies = 3, Director = Andy Wachowski, Example = The Matrix }
{ Movies = 3, Director = Larry Wachowski, Example = The Matrix }

Movies directed by Alfred Hitchcock
{ Year = 1954, Rating = 8,8, Title = Rear Window }
{ Year = 1960, Rating = 8,7, Title = Psycho }
{ Year = 1959, Rating = 8,6, Title = North by Northwest }
{ Year = 1958, Rating = 8,6, Title = Vertigo }
{ Year = 1940, Rating = 8,4, Title = Rebecca }
{ Year = 1951, Rating = 8,3, Title = Strangers on a Train }
{ Year = 1954, Rating = 8,1, Title = Dial M for Murder }
{ Year = 1944, Rating = 7,9, Title = Lifeboat }
{ Year = 1963, Rating = 7,9, Title = The Birds }
{ Year = 1972, Rating = 7,5, Title = Frenzy }
{ Year = 1955, Rating = 7,5, Title = To Catch a Thief }
{ Year = 1964, Rating = 7,3, Title = Marnie }
{ Year = 1955, Rating = 7,2, Title = The Trouble with Harry }
{ Year = 1976, Rating = 6,7, Title = Family Plot }
{ Year = 1966, Rating = 6,6, Title = Torn Curtain }
{ Year = 1969, Rating = 6,2, Title = Topaz }

Top 5 Genres
{ Count = 113, Genre = Thriller, Example = 11:14 }
{ Count = 86, Genre = Drama, Example = 11:14 }
{ Count = 68, Genre = Crime, Example = 11:14 }
{ Count = 60, Genre = Action, Example = 16 Blocks }
{ Count = 43, Genre = Comedy, Example = 11:14 }

Runtime >= 2.5h: 24
{ Length = 195 min, Title = Schindler's List }
{ Length = 194 min, Title = Titanic }
{ Length = 191 min, Title = Grindhouse }
{ Length = 187 min, Title = King Kong }
{ Length = 178 min, Title = Casino }
{ Length = 175 min, Title = The Godfather }
{ Length = 171 min, Title = Heat }
{ Length = 170 min, Title = Saving Private Ryan }
{ Length = 170 min, Title = Scarface }
{ Length = 166 min, Title = The Curious Case of Benjamin Button }
{ Length = 162 min, Title = Watchmen }
{ Length = 158 min, Title = There Will Be Blood }
{ Length = 157 min, Title = American Gangster }
{ Length = 157 min, Title = Zodiac }
{ Length = 156 min, Title = Der Untergang }
{ Length = 155 min, Title = Boogie Nights }
{ Length = 155 min, Title = Gladiator }
{ Length = 154 min, Title = Pulp Fiction }
{ Length = 154 min, Title = The Firm }
{ Length = 153 min, Title = Apocalypse Now }
{ Length = 152 min, Title = The Dark Knight }
{ Length = 151 min, Title = The Departed }
{ Length = 150 min, Title = Armageddon }
{ Length = 150 min, Title = The Pianist }

Non USA movies: 13
{ Countries = France, Title = Léon }
{ Countries = France, Austria, Germany, Italy, Title = Caché }
{ Countries = France, Germany, UK, Poland, Title = The Pianist }
{ Countries = Germany, Title = Das Leben der Anderen }
{ Countries = Germany, Italy, Austria, Title = Der Untergang }
{ Countries = Italy, Title = La vita è bella }
{ Countries = SouthKorea, Title = Oldboy }
{ Countries = UK, Title = Frenzy }
{ Countries = UK, Title = Life of Brian }
{ Countries = UK, Title = Slumdog Millionaire }
{ Countries = UK, Title = The Bank Job }
{ Countries = UK, France, Italy, Title = The Queen }
{ Countries = UK, Spain, Title = Sexy Beast }

Top 10 countries
{ Count = 170, Country = USA, Example = 11:14 }
{ Count = 28, Country = Germany, Example = 16 Blocks }
{ Count = 22, Country = UK, Example = Burn After Reading }
{ Count = 9, Country = France, Example = Burn After Reading }
{ Count = 8, Country = Australia, Example = Gran Torino }
{ Count = 5, Country = Canada, Example = 11:14 }
{ Count = 4, Country = Italy, Example = Caché }
{ Count = 2, Country = Austria, Example = Caché }
{ Count = 2, Country = CzechRepublic, Example = Casino Royale }
{ Count = 2, Country = Spain, Example = Perfume: The Story of a Murderer }

Top 10 languages
{ Count = 179, Language = English, Example = 11:14 }
{ Count = 30, Language = French, Example = Apocalypse Now }
{ Count = 26, Language = German, Example = Austin Powers in Goldmember }
{ Count = 21, Language = Spanish, Example = Collateral }
{ Count = 13, Language = Italian, Example = Die Another Day }
{ Count = 12, Language = Russian, Example = Armageddon }
{ Count = 9, Language = Mandarin, Example = Batman Begins }
{ Count = 7, Language = Cantonese, Example = Die Another Day }
{ Count = 4, Language = Japanese, Example = Austin Powers in Goldmember }
{ Count = 4, Language = Latin, Example = Face/Off }

Top Movie of each year: 39
{ Year = 1940, Best = { Rating = 8,4, Title = Rebecca } }
{ Year = 1942, Best = { Rating = 8,8, Title = Casablanca } }
{ Year = 1944, Best = { Rating = 7,9, Title = Lifeboat } }
{ Year = 1951, Best = { Rating = 8,3, Title = Strangers on a Train } }
{ Year = 1954, Best = { Rating = 8,8, Title = Rear Window } }
{ Year = 1955, Best = { Rating = 7,5, Title = To Catch a Thief } }
{ Year = 1958, Best = { Rating = 8,6, Title = Vertigo } }
{ Year = 1959, Best = { Rating = 8,6, Title = North by Northwest } }
{ Year = 1960, Best = { Rating = 8,7, Title = Psycho } }
{ Year = 1963, Best = { Rating = 7,9, Title = The Birds } }
{ Year = 1964, Best = { Rating = 7,3, Title = Marnie } }
{ Year = 1966, Best = { Rating = 6,6, Title = Torn Curtain } }
{ Year = 1969, Best = { Rating = 6,2, Title = Topaz } }
{ Year = 1971, Best = { Rating = 7,9, Title = Dirty Harry } }
{ Year = 1972, Best = { Rating = 9,1, Title = The Godfather } }
{ Year = 1975, Best = { Rating = 8,9, Title = One Flew Over the Cuckoo's Nest } }
{ Year = 1976, Best = { Rating = 6,7, Title = Family Plot } }
{ Year = 1979, Best = { Rating = 8,6, Title = Apocalypse Now } }
{ Year = 1980, Best = { Rating = 6,2, Title = Flash Gordon } }
{ Year = 1983, Best = { Rating = 8,2, Title = Scarface } }
{ Year = 1987, Best = { Rating = 7,3, Title = Wall Street } }
{ Year = 1992, Best = { Rating = 8,4, Title = Reservoir Dogs } }
{ Year = 1993, Best = { Rating = 8,9, Title = Schindler's List } }
{ Year = 1994, Best = { Rating = 8,9, Title = Pulp Fiction } }
{ Year = 1995, Best = { Rating = 8,7, Title = The Usual Suspects } }
{ Year = 1996, Best = { Rating = 8,3, Title = Fargo } }
{ Year = 1997, Best = { Rating = 8,4, Title = La vita è bella } }
{ Year = 1998, Best = { Rating = 8,5, Title = Saving Private Ryan } }
{ Year = 1999, Best = { Rating = 8,8, Title = Fight Club } }
{ Year = 2000, Best = { Rating = 8,7, Title = Memento } }
{ Year = 2001, Best = { Rating = 8,0, Title = Shrek } }
{ Year = 2002, Best = { Rating = 8,5, Title = The Pianist } }
{ Year = 2003, Best = { Rating = 8,3, Title = Oldboy } }
{ Year = 2004, Best = { Rating = 8,4, Title = Der Untergang } }
{ Year = 2005, Best = { Rating = 8,4, Title = Batman Begins } }
{ Year = 2006, Best = { Rating = 8,5, Title = Das Leben der Anderen } }
{ Year = 2007, Best = { Rating = 8,3, Title = No Country for Old Men } }
{ Year = 2008, Best = { Rating = 9,0, Title = The Dark Knight } }
{ Year = 2009, Best = { Rating = 8,1, Title = Watchmen } }

SELECT Rating, Title FROM movies WHERE country = 'de' AND genre = 'comedy' ORDER
BY rating DESC
{ Rating = 7,3, Title = Bad Santa }
{ Rating = 7,3, Title = Death at a Funeral }
{ Rating = 7,3, Title = Tropic Thunder }
{ Rating = 7,0, Title = The Matador }
{ Rating = 6,2, Title = American Wedding }