diff options
Diffstat (limited to 'users/wpcarro/todo-lists/imdb')
| -rw-r--r-- | users/wpcarro/todo-lists/imdb/db.sqlite3 | bin | 0 -> 24576 bytes | |||
| -rw-r--r-- | users/wpcarro/todo-lists/imdb/imdb-top-250.org | 256 | ||||
| -rw-r--r-- | users/wpcarro/todo-lists/imdb/scratch.sql | 65 |
3 files changed, 321 insertions, 0 deletions
diff --git a/users/wpcarro/todo-lists/imdb/db.sqlite3 b/users/wpcarro/todo-lists/imdb/db.sqlite3 new file mode 100644 index 000000000000..bb893387ecd3 --- /dev/null +++ b/users/wpcarro/todo-lists/imdb/db.sqlite3 Binary files differdiff --git a/users/wpcarro/todo-lists/imdb/imdb-top-250.org b/users/wpcarro/todo-lists/imdb/imdb-top-250.org new file mode 100644 index 000000000000..58a52392cae0 --- /dev/null +++ b/users/wpcarro/todo-lists/imdb/imdb-top-250.org @@ -0,0 +1,256 @@ +# A few years ago, I set a goal to watch every movie on IMDb.com's "Top 250" +# movies list. The list changes frequently, so I took a snapshot of it so that +# I wouldn't be trying to hit a moving target. +# +# Here is my progress thus far: +* IMDB Top 250 +** DONE The Shawshank Redemption +** DONE The Godfather +** DONE The Dark Knight +** DONE The Godfather: Part II +** DONE The Lord of the Rings: The Return of the King +** DONE Pulp Fiction +** DONE Schindler's List +** DONE The Good, the Bad and the Ugly +** DONE 12 Angry Men +** DONE Inception +** DONE Fight Club +** DONE The Lord of the Rings: The Fellowship of the Ring +** DONE Forrest Gump +** DONE The Lord of the Rings: The Two Towers +** DONE The Matrix +** DONE Goodfellas +** TODO Star Wars: Episode V - The Empire Strikes Back +** DONE One Flew Over the Cuckoo's Nest +** DONE Seven Samurai +** DONE Interstellar +** DONE City of God +** TODO Spirited Away +** DONE Saving Private Ryan +** DONE The Green Mile +** DONE Life Is Beautiful +** DONE The Usual Suspects +** DONE Se7en +** DONE Leon +** DONE The Silence of the Lambs +** TODO Star Wars: Episode IV - A New Hope +** DONE It's a Wonderful Life +** DONE Andhadhun +** DONE Dangal +** DONE Spider-Man: Into the Spider-Verse +** TODO Avengers: Infinity War +** DONE Whiplash +** DONE Untouchable +** DONE The Prestige +** DONE The Departed +** DONE The Pianist +** DONE Memento +** DONE Gladiator +** DONE American History X +** DONE The Lion King +** DONE Terminator 2: Judgment Day +** DONE Cinema Paradiso +** DONE Grave of the Fireflies +** DONE Back to the Future +** DONE Indiana Jones and the Raiders of the Lost Ark +** DONE Apocalypse Now +** TODO Alien +** DONE Once Upon a Time in the West +** DONE Psycho +** DONE Rear Window +** DONE Casablanca +** TODO The Great Dictator +** TODO Modern Times +** TODO City Lights +** TODO Kimi no na wa. +** DONE Coco +** DONE Django Unchained +** DONE The Dark Knight Rises +** DONE 3 Idiots +** TODO Taare Zameen Par +** DONE WALL·E +** TODO Babam ve Oglum +** DONE The Lives of Others +** DONE Old boy +** DONE American Beauty +** DONE Princess Mononoke +** DONE Braveheart +** TODO Aliens +** DONE Once Upon a Time in America +** TODO Das Boot +** DONE The Shining +** DONE Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb +** TODO Witness for the Prosecution +** DONE Paths of Glory +** TODO Sunset Blvd. +** DONE Green Book +** DONE The Hunt +** DONE Jodaeiye Nader az Simin +** DONE Incendies +** DONE Toy Story 3 +** DONE Inglourious Basterds +** DONE Eternal Sunshine of the Spotless Mind +** DONE Amelie +** DONE Snatch +** DONE Requiem for a Dream +** TODO Neon Genesis Evangelion: The End of Evangelion +** DONE L.A. Confidential +** DONE Good Will Hunting +** TODO Bacheha-Ye aseman +** TODO Eskiya +** DONE Toy Story +** DONE Reservoir Dogs +** DONE Full Metal Jacket +** DONE Amadeus +** DONE Scarface +** TODO Star Wars: Episode VI - Return of the Jedi +** DONE Taxi Driver +** DONE Monty Python and the Holy Grail +** DONE The Sting +** DONE A Clockwork Orange +** DONE 2001: A Space Odyssey +** TODO For a Few Dollars More +** TODO To Kill a Mockingbird +** TODO Lawrence of Arabia +** TODO Yojimbo +** DONE The Apartment +** TODO North by Northwest +** DONE Vertigo +** TODO Singin' in the Rain +** TODO Ikiru +** TODO Rashomon +** TODO All About Eve +** TODO Bicycle Thieves +** TODO Double Indemnity +** TODO Citizen Kane +** TODO M +** TODO Metropolis +** TODO The Kid +** DONE Three Billboards Outside Ebbing, Missouri +** DONE Room +** TODO PK +** DONE Inside Out +** DONE El secreto de sus ojos +** DONE Warrior +** DONE Up +** DONE The Wolf of Wall Street +** DONE There Will Be Blood +** DONE Pan's Labyrinth +** DONE V for Vendetta +** TODO Rang De Basanti +** DONE Batman Begins +** DONE Downfall +** TODO Howl's Moving Castle +** DONE A Beautiful Mind +** DONE Lock, Stock and Two Smoking Barrels +** DONE Trainspotting +** DONE Heat +** DONE Casino +** DONE Unforgiven +** TODO Indiana Jones and the Last Crusade +** DONE My Neighbour Totoro +** DONE Die Hard +** TODO Come and See +** TODO Ran +** DONE Blade Runner +** DONE Raging Bull +** TODO The Elephant Man +** DONE Chinatown +** TODO Andrei Rublev +** DONE The Great Escape +** TODO Judgment at Nuremberg +** TODO Some Like It Hot +** TODO Wild Strawberries +** TODO The Seventh Seal +** TODO The Bridge on the River Kwai +** TODO On the Waterfront +** TODO Dial M for Murder +** TODO Tokyo Story +** TODO The Third Man +** TODO The Treasure of the Sierra Madre +** TODO Mr. Smith Goes to Washington +** TODO Gone with the Wind +** TODO Sunrise: A Song of Two Humans +** TODO The General +** TODO The Gold Rush +** TODO Sherlock Jr. +** DONE The Handmaiden +** DONE Logan +** TODO Relatos salvajes +** DONE The Grand Budapest Hotel +** DONE Gone Girl +** DONE Hacksaw Ridge +** TODO 12 Years a Slave +** DONE Guardians of the Galaxy +** DONE Rush +** DONE Spotlight +** TODO Song of the Sea +** TODO The Help +** DONE Prisoners +** DONE Mad Max: Fury Road +** DONE Gran Torino +** TODO Harry Potter and the Deathly Hallows: Part 2 +** DONE Shutter Island +** DONE Hachi: A Dog's Tale +** DONE Mary and Max +** DONE How to Train Your Dragon +** DONE Into the Wild +** DONE No Country for Old Men +** DONE Million Dollar Baby +** DONE Hotel Rwanda +** TODO Before Sunset +** TODO Memories of Murder +** DONE Kill Bill: Vol. 1 +** DONE Finding Nemo +** DONE Catch Me If You Can +** TODO Donnie Darko +** DONE Amores Perros +** DONE Monsters, Inc. +** DONE The Sixth Sense +** DONE The Truman Show +** DONE The Big Lebowski +** TODO In the Mood for Love +** DONE Fargo +** TODO La Haine +** TODO Before Sunrise +** TODO Three Colours: Red +** DONE Jurassic Park +** DONE In the Name of the Father +** DONE Dead Poets Society +** TODO Akira +** DONE The Princess Bride +** TODO Laputa: Castle in the Sky +** DONE Stand by Me +** DONE Platoon +** TODO Paris, Texas +** TODO Nausicaa of the Valley of the Wind +** DONE The Thing +** TODO Gandhi +** TODO Fanny and Alexander +** TODO Stalker +** DONE Life of Brian +** DONE The Deer Hunter +** TODO Rocky +** TODO Network +** TODO Barry Lyndon +** TODO Butch Cassidy and the Sundance Kid +** DONE Cool Hand Luke +** TODO Persona +** TODO The 400 Blows +** TODO Ben-Hur +** TODO The Nights of Cabiria +** TODO Les Diaboliques +** TODO The Wages of Fear +** TODO The Best Years of Our Lives +** TODO The Maltese Falcon +** TODO Rebecca +** TODO The Grapes of Wrath +** TODO It Happened One Night +** TODO La passion de Jeanne d'Arc +** DONE Pirates of the Caribbean: The Curse of the Black Pearl +** DONE Groundhog Day +** DONE Beauty and the Beast +** DONE The Terminator +** DONE Jaws +** DONE The Exorcist +** DONE The Wizard of Oz diff --git a/users/wpcarro/todo-lists/imdb/scratch.sql b/users/wpcarro/todo-lists/imdb/scratch.sql new file mode 100644 index 000000000000..6835c73bd87c --- /dev/null +++ b/users/wpcarro/todo-lists/imdb/scratch.sql @@ -0,0 +1,65 @@ +-- which directors appear most often +SELECT director, COUNT(*) +FROM Movies +GROUP BY director +ORDER BY COUNT(*) DESC +LIMIT 10; + +-- top-rated, most recent movies +SELECT * +FROM ( + SELECT * + FROM Movies + ORDER BY rating DESC + LIMIT 20 +) +ORDER BY YEAR DESC; + +-- top-rated, most recent movies (ignore foreign) +SELECT * +FROM ( + SELECT * + FROM Movies + WHERE requiresSubtitles = 0 + ORDER BY rating DESC + LIMIT 20 +) +ORDER BY YEAR DESC; + +-- most recent movies +SELECT * +FROM Movies +ORDER BY YEAR DESC +LIMIT 15; + +-- most recent movies (ignore foreign) +SELECT * +FROM Movies +WHERE requiresSubtitles = 0 +ORDER BY YEAR DESC +LIMIT 10; + +-- only cartoons +SELECT * +FROM Movies +WHERE isCartoon = true; + +-- only cartoons (ignore foreign) +SELECT * +FROM Movies +WHERE isCartoon = true AND requiresSubtitles = false; + +-- show the movies from the directors that show up on the list more than once. +SELECT * +FROM Movies +WHERE director in ( + SELECT director + FROM ( + SELECT director, COUNT(*) as num + FROM Movies + GROUP BY director + HAVING num > 1 + ORDER BY num DESC + ) +) +ORDER BY director, rating DESC, year DESC; |