Kmeilak Week 6

Movies from Text File to Tables

1. What movies were released before 1915?

"D.W. Griffith: Years of Discovery 1909-1913"
"Lumiere Brothers' First Films"
"Tillie's Punctured Romance"
"Cabiria"

command

select * from movie where year < 1915;

2. What movies from the 1980s had 4-digit numbers in their titles?

"Cherry 2000"
"2010: The Year We Make Contact"
"1984"
"Cold Summer of 1953"
"Butthole Surfers: Blind Eye See All: Live 1985"
"Transylvania 6-5000"
"Hong Kong 1941"
"1969"
"Eric Clapton & Friends: Live 1986"
"The 2000 Year Old Man"
"Teenage Mutant Ninja Turtles (1980s)"

command

select * from movie where (year >= 1980 and year < 1989) and title ~ '[0123456789][0123456789][0123456789][0123456789]';

3. What movies have apostrophes in their titles?

"Paula Abdul's Get Up & Dance" "Class of Nuke 'Em High 2" "By Dawn's Early Light" "Clifford: Clifford Saves the Day! / Clifford's Fluffiest Friend Cleo" "Sesame Street: Elmo's World: The Street We Live On" "Something's Gotta Give" "ABC Primetime: Mel Gibson's The Passion of the Christ" "Ashtanga Yoga: Beginner's Practice with Nicki Doane" "Zatoichi's Conspiracy" "We're Not Married" "Ken Burns' America: Empire of the Air" "ECW: Cyberslam '99" "Bruce Lee: A Warrior's Journey" "The Devil's Brigade" "Ruby's Bucket of Blood" "That '70s Show: Season 1" "Chappelle's Show: Season 1" "Chato's Land" "Michael Moore's The Awful Truth: Season 2" "Midsomer Murders: Strangler's Wood" "Charlotte's Web" "The Devil's Own" "Bridget Jones's Diary" "Mother's Boys" "Bizet's Carmen" "Danielle Steel's Heartbeat" "Agatha Christie's Poirot: Sad Cypress" "Recess: School's Out" "Barney: Barney's Colorful World: Live" "Extreme Engineering: Tokyo's Sky City" "Isaac Stern: Life's Virtuoso" "VeggieTales Classics: Where's God When I'm Scared?" "Danielle Steel's Jewels" "The Avengers '67" "Monty Python's The Meaning of Life: Special Edition" "Broadway's Lost Treasures" "Blank Generation / Dancin' Barefoot" "Blue's Clues: Blue's Room: It's Hug Day" "E's Otherwise" "The Hitchhiker's Guide to the Galaxy" "You're Invited to Mary-Kate and Ashley's Vacation Parties" "What's Up, Tiger Lily?" "Walt Disney's Timeless Tales: Vol. 2" "Talkin' Dirty After Dark" "Shaft's Big Score!" "Elvira's Haunted Hills" "Marvin's Room" "Gilligan's Island: Season 2" "Rugrats All Grown Up: O' Brother!" "Angel's Dance" "Caillou: Caillou's Treasure Hunt and Other Adventures" "Todd McFarlane's Spawn" "Africans in America: America's Journey Through Slavery" "Abigail's Party" "Ken Burns' America: The Congress" "Widows' Peak" "Pooh's Heffalump Movie" "Gloria Estefan: Don't Stop!" "Foyle's War: Set 2" "Dr. Seuss's The 5,000 Fingers of Dr. T" "Logan's Run" "C'est La Vie, Mon Cheri" "Wes Craven's Invitation to Hell" "Sharpe 4: Sharpe's Enemy" "Zakk Wylde's Black Label Society: Boozed, Broozed & Broken-Boned" "Blue's Clues: Classic Clues" "A Hard Day's Night: Collector's Series" "Satanis: The Devil's Mass / Sinthia: The Devil's Doll: Double Feature" "Don't Bother to Knock" "Danielle Steel's Changes" "Backyardigans: It's Great to Be a Ghost" "Dave Chappelle: For What It's Worth" "Rescue from Gilligan's Island" "America's Dream" "Ken Burns' The West" "Thomas & Friends: Thomas's Snowy Surprise" "King's Ransom" "Flood: A River's Rampage" "Winning Strategies: Texas Hold 'Em Poker with Mike Caro" "Hell's Angels" "Clive Barker's Salome / The Forbidden" "Sweet Sweetback's Baadasssss Song" "Artie Lange: It's the Whiskey Talkin'" "Wolf's Rain" "I Do (But I Don't)" "Krippendorf's Tribe" "The Devil's Backbone" "Masters of Poker: Phil Hellmuth's Million Dollar Texas Hold'em Tournament Strategies" "The Cat O'Nine Tails" "National Lampoon's Vacation" "The Andy Griffith Show: Vol 3: Andy Discovers America / Andy's English Valet" "Dragon Tales: Let's Share! Let's Play!" "Summer of '42" "The Carol Burnett Show: Let's Bump Up the Lights!" "Warren Miller's Impact" "Dead Men Don't Wear Plaid" "Blind Spot: Hitler's Secretary" "Inch' Allah Dimanche" "Look Who's Talking Too" "Hitler's Lost Sub: Nova" "Jammin' with the Blues Greats" "Yosemite: The World's Most Spectacular Valley" "Mother's Day" "Fat Albert's Easter Special" "Play'd: A Hip-Hop Story" "Greaser's Palace" "The Halfway House: Special Edition (Unrated Director's Cut)" "Children of the Corn 666: Isaac's Return" "Overhaulin': Season 1" "Girls Can't Swim" "Colin's Sleazy Friends Rocks" "Appalachian Journey: Yo-Yo Ma/Edgar Meyer/Mark O'Connor" "National Lampoon's Van Wilder" "Blue's Clues: Blue's Room: Beyond Your Wildest Dreams!" "Mo' Money" "Thomas & Friends: Thomas' Sodor Celebration" "Pooh's Heffalump Halloween Movie" "The Devil's Rain" "AFI's 100 Years, 100 Movies" "To Grandmother's House We Go" "School's Out" "Muddy Waters Can't Be Satisfied" "Stephen King's It!" "Dead Kennedys: DMPO's On Broadway" "Zhou Yu's Train" "Aliens: Collector's Edition" "Spike & Mike's Sick & Twisted Festival of Animation: Caught in the Act" "Agatha Christie's Marple: Series 1" "Outfoxed: Rupert Murdoch's War on Journalism" "Tony Bennett's Wonderful World: Live in San Francisco" "One Man's Justice" "Beast From Haunted Cave/The Brain That Wouldn't Die" "L'Ennui" "It's Me, the Thief" "Flipper's New Adventure" "The Horse's Mouth" "Alien: Resurrection: Collector's Edition" "Men's Mix 1: Gay Shorts Collection" "L'Age D'Or" "Rosemary's Baby" "The Caveman's Valentine" "Yasujiro Ozu's Good Morning" "Grand Canyon: The World's Great Natural Wonder" "Captain Corelli's Mandolin" "Live from Shiva's Dance Floor" "Cheech & Chong's Up in Smoke" "Pee-Wee's Playhouse: Vol. 1" "What's the Matter with Helen? / Whoever Slew Auntie Roo? (Double Feature)" "Diff'rent Strokes: Season 1" "Jay Jay the Jet Plane: Learning Life's Lessons" "Alien: Resurrection: Collector's Edition: Bonus Material" "There's a Girl in My Soup" "The Courtship of Eddie's Father" "Extreme Engineering: Holland's Barriers to the Sea" "'N Sync: PopOdyssey Live" "Darrin's Dance Grooves" "Two's Company: Series 1" "Pete's Meteor" "America's Next Top Model: Cycle 1" "Buffalo '66" "Rory O'Shea Was Here" "The Hitchhiker's Guide to the Galaxy" "Pippi's Adventures on the South Seas" "Wes Craven's Chiller" "Ken Burns' America: Thomas Hart Benton" "Dracula's Curse" "Don't Look in the Basement" "Danielle Steel's Fine Things" "Bram Stoker's Dracula" "Bill's Run: A Political Journey in Rural Kansas: POV" "Liar's Moon" "Father's Little Dividend" "Heck's Way Home" "Singin' in the Rain" "Alien: Collector's Edition" "Jane Goodall's Wild Chimpanzees: IMAX" "Burnzy's Last Call" "Wayne's World" "Sharpe 8: Sharpe's Sword" "America's Sweethearts" "Mama Flora's Family" "The Spirit of '76" "Things to Do in Denver When You're Dead" "Fairly Oddparents: Timmy's Top Wishes" "Sullivan's Travels" "The Greatest '70s Cop Shows" "Look Who's Talking" "WWE: Mick Foley's Greatest Hits and Misses" "Don't Say a Word" "America's Most Haunted Town" "The President's Analyst" "Alice's Adventures in Wonderland" "Rick Steves' Europe: Ireland" "Devil's Nightmare" "Heaven's Gate" "The Emperor's New Groove" "Jackie's Back" "It's All Gone Pete Tong" "Murder at Devil's Glen" "The Politician's Wife" "Bob the Builder: Bob's Big Plan" "The Sex Pistols: The Great Rock 'n' Roll Swindle" "Cinema's Dark Side: Impact/ Second Woman/ They Made Me a Criminal" "Pink Floyd: Live at Pompeii: Director's Cut" "Dr. Seuss' The Cat in the Hat" "Johnny Cash: Ridin' the Rails: The Great American Train Story" "Mr. Rice's Secret" "The President's Man" "Sherman's March" "Blue's Clues: Blue's Room Snacktime Playdate" "'N Sync: 'N the Mix" "The Slugger's Wife" "Quick Tips from Golf's Greats" "Frosty's Winter Wonderland / 'Twas the Night Before Christmas" "L'Enfer" "Bobby's World: The Signature Episodes" "Danielle Steel's Kaleidoscope" "The Ocean's 11 Story" "Virginia's Run" "Rugrats All Grown Up: Dude, Where's My Horse?" "Dr. Seuss' The Cat in the Hat" "L'Argent" "Richard Pryor: I Ain't Dead Yet #*%$#@!! Uncensored" "Midsomer Murders: Murder on St. Malley's Day" "There's Something About Mary: Special Edition: Bonus Material" "Cadfael: The Potter's Field" "Warren Miller's Journey" "Hogan's Heroes: Season 1" "Here's Lucy" "At the Earth's Core" "I'm Not Scared" "Murphy's Romance" "Beyond the Mind's Eye" "Dante's Peak" "The Powerpuff Girls: Down 'n' Dirty" "For Pete's Sake" "King Solomon's Mines" "Pokemon Master Quest: Collector's Box: Quest 2" "George Carlin: George's Best Stuff" "C'est la Vie" "Gray's Anatomy" "Muriel's Wedding" "Everybody's All American" "Cadfael: Monk's Hood" "Tsui Hark's Vampire Hunters" "Howard Zinn: You Can't Be Neutral on a Moving Train" "Ozzy Osbourne: Don't Blame Me" "Scooby-Doo's Original Mysteries" "Spike and Mike's Sick & Twisted Festival of Animation" "The Living Edens: The Lost World: Venezuela's Ancient Tepuis" "National Geographic: Nature's Fury" "Queer Eye for the Straight Guy: Carson's Style" "Flash Gordon's Trip to Mars" "Sharpe 12: Sharpe's Revenge" "Family Guy: Freakin' Sweet Collection" "You're Invited to Mary-Kate and Ashley's School Dance Party" "In the Face of Evil: Reagan's War in Word and Deed" "Noah's Ark" "The Rat Pack's Las Vegas" "Pete's Dragon" "Catherine Cookson's: The Secret" "The Wizard of Oz: Collector's Edition" "Predator: Collector's Edition: Bonus Material" "Ed McBain's 87th Precinct" "Von Ryan's Express" "Sesame Street: Let's Make Music" "Scooby-Doo's Spookiest Tales" "Ripley's Game" "The Miracle of Morgan's Creek" "Christina's House" "Spencer's Mountain" "Every Mother's Son: POV" "I Know Where I'm Going!" "Salsa & Merengue: Cal Pozo's Learn to Dance in Minutes" "Winnie the Pooh: Un-Valentine's Day / A Valentine for You" "I'll Be There" "Avant-Garde: Experimental Cinema of the 1920s and '30s" "L'Eclisse" "I Can't Marry You" "Elvira's Horror Classics" "Charlie's Angels: Season 2" "It's a Gift" "Sharpe 10: Sharpe's Siege" "Milton Berle's Buick Hour #1" "Powerpuff Girls: 'Twas The Fight Before Christmas" "101 Dalmatians II: Patch's London Adventure" "ECW: Heatwave '98" "My Teacher's Wife" "Hangman's Curse" "Sesame Street: Cookie Monster's Best Bites" "The Private Navy of Sgt. O' Farrell" "Little House on the Prairie: I'll Be Waving as You Drive Away" "All the Queen's Men" "Last Flight of Noah's Ark" "Bram Stoker's Shadowbuilder" "Trippin'" "Santa Claus Is Comin' to Town" "Harrison's Flowers" "She's Having A Baby" "Dead Man's Walk" "Mickey's House of Villains" "Don't Drink the Water" "Warren Miller's: The Power of Snow: Cold Fusion" "Alfred Hitchcock: Rich and Strange/The Sorcerer's Apprentice" "Hofmann's Potion" "Oliver's Travels" "Footloose: Special Collector's Edition" "National Geographic: Vietnam's Unseen War: Pictures from the Other Side" "April Fool's Day" "Gregory's Girl" "Eden's Curve" "Dragon Tales: Let's Start a Band" "Ed Sullivan: Rock 'n' Roll Revolution" "Emily Bronte's Wuthering Heights" "I've Been Waiting for You" "Bram Stoker's: To Die For" "Porky's" "Sharpe 9: Sharpe's Regiment" "Sharpe 5: Sharpe's Honour" "MTV: Punk'd: Season 2" "I'm No Angel" "Disney's Learning Adventures: Mickey's Around the World in 80 Days: Seeing the World" "Nothin' 2 Lose" "National Geographic: Volcano: Nature's Inferno" "Cats Don't Dance" "Blue's Clues: Blue Talks" "Kermit's Swamp Years" "The Best of Beakman's World" "Breakfast at Tiffany's" "Carly Simon: Live from Martha's Vineyard" "Independent's Day" "How's Your News?" "China O'Brien" "But I'm a Cheerleader" "UFC 47: Ultimate Fighting Championship: It's On!" "Bob Dylan: Don't Look Back" "The Biggest Lil' Star in Hollywood" "Blood From the Mummy's Tomb" "George Carlin: Jammin' in New York / Doin' It Again" "What's New Pussycat?" "Snoop Dogg's Hustlaz: Diary of a Pimp" "The President's Man 2" "Mackenna's Gold" "The Strangler's Wife" "The Go-Go's: Live in Central Park" "The Legend of Zelda: Ganon's Evil Tower" "My Husband's Double Life" "It's Alive" "Sharpe 7: Sharpe's Battle" "Tina Turner: Rio '88" "Child's Play 2: Chucky's Back" "Dario Argento's Trauma" "Lady and the Tramp II: Scamp's Adventure" "Let's Dance Salsa: Beginning Lessons 1" "Danielle Steel's Vanished" "Chinese Odyssey 1: Pandora's Box" "Satan's Brew" "Caillou: Caillou's Train Trip and Other Adventures" "W.C. Fields: You Can't Cheat an Honest Man" "Mask: Director's Cut" "Max Keeble's Big Move" "Atlantis: Milo's Return" "Colin's Sleazy Friends" "Hogan's Heroes: Season 2" "'N Sync: Making of the Tour" "ECW: Anarchy Rulz '99" "Lover's Prayer" "Dein Perry's: Tap Dogs" "Grass: A Nation's Battle for Life" "Miss Spider's Sunny Patch Kids" "City Slickers II: The Legend of Curly's Gold" "Ken Burns' Civil War" "Beach Boys: An American Band / Brian Wilson: I Just Wasn't Made for These Times" "Bear in the Big Blue House: Everybody's Special" "Elmo's World: Families, Mail & Bath Time" "The Butcher's Wife" "Mo' Better Blues" "Dawson's Creek: Season 2" "Hell's Highway: The True Story of Highway Safety Films" "Agatha Christie's Poirot: Death on the Nile" "Teddy Bears' Picnic" "Emperor's Shadow" "Clara's Summer" "Where's Poppa?" "Wacky Babies & Tender Times: Marty Stouffer's Wild America" "Michael Palin's Personal Best" "Tess of the D'Urbervilles" "The Grateful Dead: Truckin' Up to Buffalo" "Just Can't Get Enough" "Check and Double Check with Amos 'n' Andy" "Salem's Lot" "Charlie's Angels: Angels Under Covers" "Boy's Choir" "The Best of Rowan & Martin's Laugh-In 2" "Monty Python's Life of Brian" "Sesame Street's 25th Birthday: A Musical Celebration" "Richard Pryor: Live & Smokin'" "Dora the Explorer: It's a Party!" "Sing Faster: The Stagehands' Ring Cycle" "The Firemen's Ball" "Alien 3: Collector's Edition: Bonus Material" "Blue's Clues: Blue Takes You to School" "Danielle Steel's A Perfect Stranger" "Tough Guys Don't Dance" "Blue's Big Musical Movie: Blue's Clues" "Twelve O'Clock High" "The Cat's Meow" "Extreme Engineering: Boston's Big Dig" "Deanna Durbin: It Started with Eve / Can't Help Singing" "Dude, Where's My Car?" "Devil's Pond" "You Can't Take It With You" "The Aviator's Wife" "Dawson's Creek: Season 5" "Jackie Chan's Project A" "Who's Your Daddy" "Jupiter's Wife" "Dario Argento's The Card Player" "Superstars of '70s Soul Live" "My Boyfriend's Back" "Stephen Sondheim's Putting It Together" "The Emperor's New Clothes" "The Forgetting: A Portrait of Alzheimer's" "The Worst Witch: Miss Cackle's Birthday Surprise" "Good Rockin' Tonight: The Legacy of Sun Records" "Willie Nelson: Live at Billy Bob's Texas" "Long Day's Journey into Night" "Ocean's Eleven" "Coffin Joe: At Midnight I'll Take Your Soul" "Dora the Explorer: Dora's Halloween" "Navy Seals: America's Secret Warriors" "Children Shouldn't Play with Dead Things" "Thrashin'" "St. Elmo's Fire" "Devil's Prey" "Eve's Bayou" "John Lee Hooker: That's My Story" "Neil Gaiman's A Short Film About John Bolton" "It's a Mad, Mad, Mad, Mad World" "Don't Raise the Bridge, Lower the River" "Mary Shelley's Frankenstein" "Brother's Keeper" "Sesame Street: What's the Name of That Song" "Donovan's Reef" "Betsy's Wedding" "All the President's Men" "You'll Get Over It" "Masters of Poker: Vol. 2: Phil Hellmuth's Million Dollar Secrets to Bluffing and Tells" "You're Invited to Mary-Kate and Ashley's Favorite Parties" "A Nightmare on Elm Street 2: Freddy's Revenge" "Operation "Y" and Other Shurik's Adventures" "America's Funniest Home Videos: Vol. 1" "Sharpe 11: Sharpe's Mission" "Secrets of the Warrior's Power: Kung Fu" "The Handmaid's Tale" "Rock 'n' Roll High School" "King Solomon's Mines" "Midsomer Murders: Dead Man's Eleven" "The Crying Game: Collector's Edition" "Big Momma's House" "What's Happening!!: Season 2" "Baby's Day Out" "King Solomon's Mines" "Yana's Friends" "Barney's Outdoor Fun!" "Devil's Playground" "Paul Rodriguez's Latin All-Stars of Comedy: Vol. 1" "Smokey Joe's Café" "Poirot: Hercule Poirot's Christmas" "Alice's Restaurant" "Spike and Mike's Sick & Twisted Festival of Animation: Full Frontal" "A Bug's Life" "Adam's Rib" "Red Green's Duct Tape Forever" "Rana's Wedding" "Three's Company: Season 1" "Charlie's Angels" "Hell's Gate 11:11" "Red Green's Hindsight is 20-20" "The Rich Man's Wife" "Fraggle Rock: Doin' Things That Doozers Do" "Arna's Children" "Foyle's War: Series 1" "Coogan's Bluff" "Life's Greatest Miracle: Nova" "Babette's Feast" "Spike & Mike's Cutting Edge Classics" "WWE: 'Cause Stone Cold Said So" "Breakin' 2: Electric Boogaloo" "National Lampoon's Mr. Wong" "Jojo's Circus: Animal a Go-Go" "Lady Chatterley's Lover" "Dorf on Golf / Dorf's Golf Bible" "Li'l Abner" "National Lampoon's Last Resort" "Hello Kitty's Paradise" "'N Sync: Unauthorized Biography" "Tony Hawk's Trick Tips: Vol. 1: Skateboarding Basics" "Jesus' Son" "The Mummy an' the Armadillo" "Timothy Leary's Last Trip" "Versus: Director's Cut" "From Dusk Till Dawn 3: The Hangman's Daughter" "Losin' It" "The 1964 World's Fair" "Killer's Kiss" "Sesame Street: Elmo's Sing-Along Guessing Game" "When the Party's Over" "Lawnmower Man 2: Jobe's War" "Please Don't Eat the Daisies" "It's the Pied Piper, Charlie Brown" "Jazz on a Summer's Day" "Agatha Christie's The Pale Horse" "Ferris Bueller's Day Off" "Varian's War" "Raging Bull: Collector's Edition: Bonus Material" "Dawson's Creek: Series Finale" "James Cameron's Expedition: Bismarck" "Masters of Poker: Vol. 1: Phil Hellmuth's Million Dollar Poker System" "Charlie's Angels: Full Throttle" "Eric Idle's Personal Best" "Yellowstone: The World's First National Park" "Island of Dr. Moreau: Director's Cut" "Violet's Visit" "Max Fleischer's Superman" "Dave Chappelle: Killin' Them Softly" "The Avengers '68" "Tony Hawk's Trick Tips: Vol. 3: Secrets of Skateboarding" "Hitman's Code" "America's Atomic Bomb Tests" "Metallica: Cliff 'Em All" "A Midsummer Night's Dream" "Monty Python's Flying Circus" "My Sister's Keeper" "History of Rock 'N' Roll" "Hitler's Fixer" "Piglet's Big Movie" "Jojo's Circus: Take a Bow" "Monster's Ball" "Antonia's Line" "Mystery Science Theater 3000: Merlin's Shop of Mystical Wonders" "The '70s" "I'll Do Anything" "Jennifer Lopez: Feelin' So Good" "Odyssey into the Mind's Eye" "Carmen Electra's Advanced Aerobic Striptease" "Gone with the Wind: Collector's Edition" "Jewel: Live at Humphrey's by the Bay" "Sgt. Pepper's Lonely Hearts Club Band" "God's Army" "The Children's Hour" "Seven Signs of Christ's Return" "Jackie Brown: Collector's Series" "Masters of Poker: Annie Duke's Advanced Texas Hold 'em Secrets: How to Beat the Big Boys" "Sharpe 3: Sharpe's Company" "National Lampoon's Gold Diggers" "Three O'Clock High" "Who's the Boss?: Season 1" "UFC 50: Ultimate Fighting Championship: The War of '04" "It's Pat: The Movie" "Ken Burns' America: The Shakers" "Can't Hardly Wait" "Sister Wendy's American Collection" "Isn't She Great" "Lumiere Brothers' First Films" "Ken Burns' America: Huey Long" "Donnie Darko: Director's Cut: Bonus Material" "Danielle Steel's The Ring" "Billy Rose's Jumbo" "Cinema Paradiso: Director's Cut" "Someday's Dreamers" "Bratz: The Video: Starrin' & Stylin'" "Don't Answer the Phone" "Barney's Super Singing Circus" "The Astronaut's Wife" "Millionaire's Express" "Monty Python's The Meaning of Life: Special Edition: Bonus Material" "National Lampoon's Christmas Vacation: Special Edition" "Miss Evers' Boys" "My Boss's Daughter" "The Party's Over" "Cadfael: St. Peter's Fair" "L'Avventura" "Satan's Sadists" "Agatha Christie's Poirot: Five Little Pigs" "Thomas & Friends: It's Great to be an Engine" "This Girl's Life" "Carmen Electra's The Lap Dance" "Why Didn't They Ask Evans?" "Ken Burns' America: The Statue of Liberty" "Bebe's Kids" "Blackbeard's Ghost" "Emmanuelle's Intimate Encounters" "Ax 'Em" "My Mother's Castle" "M. Hulot's Holiday" "Predator: Collector's Edition" "Stephen King's Cat's Eye" "Depeche Mode: The Videos '86-'98" "Helter Skelter: Director's Cut" "He's a Woman, She's a Man" "Blue's Clues: Bluestock" "Lassie: The 50th TV Anniversary Collector's Edition" "Sharpe 2: Sharpe's Eagle" "National Lampoon's Van Wilder: Bonus Material" "Jean Cocteau's Orphic Trilogy" "Warren Miller's: Storm" "Beethoven's 2nd" "National Lampoon's Class Reunion" "Blowin' Smoke" "Jackie Chan's Who Am I" "One Flew Over the Cuckoo's Nest" "Airport '77 / The Concorde: Airport '79: Double Feature" "Trading Spaces: Viewer's Choice" "Shogun's Samurai" "Gulliver's Travels" "Felicia's Journey" "Surfin' Shorts" "Gulliver's Travels" "Hallelujah, I'm a Bum" "White Man's Burden" "One Man's Hero" "Finder's Fee" "Bill & Ted's Bogus Journey" "Gundam: The 08th MS Team: The Movie: Miller's Report" "Shakespeare Comedies: A Midsummer Night's Dream" "Winnie the Pooh: ABC's" "Egypt's Golden Empire" "What Your Eyes Don't See" "Hollywood Musicals of the '40s" "Big Shot's Funeral" "She's So Lovely" "Billy's Hollywood Screen Kiss" "The Emperor's Club" "Brown's Requiem" "Pee-Wee's Big Adventure" "A Woman's Guide to Adultery" "Beethoven's 4th" "Cleopatra's Second Husband" "It's the Great Pumpkin, Charlie Brown" "Dawson's Creek: Season 1" "The Best of Charlie's Angels" "Monty Python's And Now for Something Completely Different" "Wesley's Mysterious Files" "Agatha Christie's Evil Under the Sun" "Ghost Talker's Daydream" "Rustler's Rhapsody" "Daddy's Dyin' ... Who's Got the Will?" "That's So Raven: Disguise the Limit" "Sesame Street: Elmo's World: Great Outdoors" "Penn & Teller's Magic and Mystery Tour" "The Gun in Betty Lou's Handbag" "God is Great, I'm Not" "Frank Sinatra: Ol' Blue Eyes Is Back" "Bram Stoker's The Mummy" "Sheryl Crow: C'mon America 2003" "Bill Engvall: Here's Your Sign" "Hill "Halfon" Doesn't Answer" "Chaplin's Essanay Comedies: Vol. 3" "Dora the Explorer: Dora's Fairytale Adventure" "A Midsummer Night's Dream" "Brewster's Millions" "The Boston Red Sox: 2004 World Series Collector's Edition" "It's Alive 2: It Lives Again / It's Alive 3: Island of the Alive" "Tony Hawk's Secret Skatepark Tour" "Kiki's Delivery Service: Bonus Material" "Tillie's Punctured Romance" "Handel: The Messiah: Choir of King's College" "Pokemon: Journey to the Johto League Champion: Vol. 7: Journey's End" "Sharpe 14: Sharpe's Waterloo" "Hittin' It!" "Gilligan's Island: Season 1" "George Carlin: Doin' It Again" "It Happened at the World's Fair" "Laurence Olivier's Hamlet" "Cheech & Chong's Nice Dreams" "Kangaroo Jack: G'Day USA" "Boys' Shorts: The New Queer Cinema" "Jancis Robinson's Wine Course" "I'm Still Here . . . Damn It!" "Man's Best Friend" "Teacher's Pet" "Magic User's Club" "Violence in a Women's Prison" "Knocking On Death's Door" "I'll Remember April" "Lana's Rain" "Don's Party" "Three's Company: Season 4" "We're No Angels" "Jumpin' Jack Flash" "Danielle Steel's Daddy" "Elvis: That's the Way It Is" "Substitute 2: School's Out" "World's Most Astounding Undercover Stings" "Satan's Little Helper" "Hallow's End" "I'm Gonna Git You Sucka" "I'll Sleep When I'm Dead" "The Butterfly Effect: Director's Cut" "Ken Burns' America: Brooklyn Bridge" "National Lampoon's Christmas Vacation 2: Cousin Eddie's Island Adventure" "Chisholm '72: Unbought and Unbossed" "The Hidden Fuhrer: Hitler's Sexuality" "A Knight's Tale" "There's Something About Mary: Special Edition" "Agatha Christie's The Mirror Crack'd" "Mr. Bill's Classics" "Since You've Been Gone" "The Serpent's Kiss" "Red Green's: We Can't Help It -- We're Men" "Dean Martin: That's Amore" "The Farmer's Wife" "By Dawn's Early Light" "Caroline Myss, Ph.D.: Why People Don't Heal / Three Levels of Power" "A Kid in Aladdin's Palace" "Doobie Brothers: Rockin' Down the Highway: The Wildlife Concert" "Guns N' Roses: Use Your Illusion I" "National Lampoon's Senior Trip" "My Baby's Daddy" "America's Most Haunted Inns" "Winchester '73" "Darby O'Gill and the Little People" "We'll Meet Again" "Madeline's Best Manners" "Jackie Chan's First Strike" "Wes Craven Presents: Don't Look Down" "Fathers' Day" "Elmo's World: Elmo Has Two! Hands, Ears & Feet" "Who's Harry Crumb?" "Tom and Jerry's Greatest Chases" "Comedy's Dirtiest Dozen / Heavyweights Of Comedy" "Charlie's Angels: Season 1" "Lady Audley's Secret" "Nina's Tragedies" "Angela's Ashes" "Dawson's Creek: Season 4" "Dude, Where's the Party?" "Jason's Lyric" "'N Sync: Live at Madison Square Garden" "Kelly's Heroes" "A Kid in King Arthur's Court" "Weekend at Bernie's" "Colosseum: A Gladiator's Story" "Rudolph and Frosty's Christmas in July" "The Avengers '65" "Noam Chomsky: Distorted Morality: America's War on Terror?" "L'Atalante" "Ocean's Twelve" "My Best Friend's Wedding" "Jack O'Lantern" "Gridlock'd" "The World's Greatest Athlete" "MTV: Punk'd: Season 1" "Carlito's Way" "Fred Rogers: America's Favorite Neighbor" "Blue's Clues: Blue's Room: Alphabet Power" "Who's the Man?" "Let's Dance Salsa: Beginning Lessons 2" "Arthur's Quest" "Bustin' Loose" "The Howlin' Wolf Story" "Bulldog Drummond Escapes/ Bulldog Drummond's Secret Police" "McHale's Navy" "Night Warriors #1: Darkstalker's Revenge: Alpha" "Hellion: The Devil's Playground" "ECW: Wrestlepalooza '97" "Rock: The People's Champ: WWF" "National Lampoon's Loaded Weapon" "To': Day of Days: White Knuckle Extreme" "Chappelle's Show: Season 2" "A Soldier's Story" "Beethoven's 5th" "Live and Swingin': The Ultimate Rat Pack Collection" "MTV's Wuthering Heights" "Joe Gould's Secret" "Bolshoi Ballet '67" "Carlita's Secret" "She's Out of Control" "Gimme Some Truth: The Making of John Lennon's 'Imagine' Album" "Rolie Polie Olie: The Baby 'Bot Chase" "Max and Ruby's Halloween" "Can't Buy Me Love" "The Hitchhiker's Guide to the Galaxy: Bonus Material" "Alexander: Director's Cut" "A Gentleman's Game" "The Mummy's Hand / The Mummy's Tomb" "Brother's Keeper: 10th Anniversary Edition" "Dragnet '67: Season 1" "Don't Touch the White Woman!" "Masters of Poker: Phil Hellmuth's Million Dollar Online Poker Secrets" "National Lampoon's Blackball" "Alien: Collector's Edition: Bonus Material" "Errol Morris' First Person: The Complete Series" "Mystery Science Theater 3000: The Brain That Wouldn't Die" "Hell's Kitchen" "Heaven's Prisoners" "Gov't Mule: Rising Low" "Thieves' Highway" "Hart's War" "Walt Disney's Timeless Tales: Vol. 1" "Countess Dracula's Orgy of Blood" "A Midsummer Night's Sex Comedy" "Tanner '88" "Sophie's Choice" "Entertainer's Basketball Classic at Rucker Park: The Second Season" "Class of Nuke 'Em High" "Joseph Campbell: The Hero's Journey" "VH1 Divas Live '99" "Squanto: A Warrior's Tale" "Snake in the Eagle's Shadow" "Can't Stop the Music" "Menno's Mind" "Alexander's Ragtime Band" "The Mummy's Ghost / The Mummy's Curse" "The 'Burbs" "Legend: The Director's Cut" "The NBA's 100 Greatest Plays" "Say It Isn't So" "Cadfael: The Devil's Novice" "Gate to the Mind's Eye" "Malibu's Most Wanted" "Barney: Come on Over to Barney's House" "Casey's Shadow" "Now You See Him, Now You Don't" "Carmen Electra's Fit to Strip" "Blue's Clues: Get to Know Joe!" "The Young Poisoner's Handbook" "Clifford: Team Clifford and Rock N' Roll Clifford" "Who'll Stop The Rain" "Miller's Crossing" "Vive L'Amour" "Popeye 75th Anniversary Collector's Edition" "'Allo 'Allo!: Series 2" "The Very Best of America's Funniest Comedians" "He Knows You're Alone" "Joggers' Park" "H.H. Holmes: America's First Serial Killer" "Rudyard Kipling's The Second Jungle Book: Mowgli and Baloo" "Hangin' with the Homeboys" "You're Invited to Mary-Kate and Ashley's Greatest Parties" "WWE: New Year's Revolution" "National Geographic's Most Amazing Moments" "Summer's Lease" "Roy Jones Jr.'s Greatest Knockouts" "Aliens: Collector's Edition: Bonus Material" "A Summer's Tale" "Boccaccio '70" "Hal Roach's Rascals #2" "The '60s" "A Hard Day's Night: Collector's Series: Bonus Material" "Big Girls Don't Cry ... They Get Even" "Romy and Michele's High School Reunion" "Goin' South" "That '70s Show: Season 2" "Kira's Reason: A Love Story" "Mickey & Minnie's Sweetheart Stories" "Bob Hope: Hollywood's Brightest Star" "The Bells of St. Mary's" "Prizzi's Honor" "Ed Sullivan: Rock 'n' Roll Forever" "Boys Don't Cry" "Sesame Street: Elmo's World: Food, Water & Exercise!" "The Serpent's Egg" "Family Values Tour '98" "Deep Purple: Total Abandon: Australia '99" "Tony Hawk's Gigantic Skatepark Tour 2000" "A Midsummer Night's Rave" "Madea's Family Reunion (Stage Play)" "My Kinda' Muzik: Vol. 1" "Franz Kafka's It's a Wonderful Life and Other Strange Tales" "Don't Go in the House" "Gunslinger's Revenge" "Baby Looney Tunes' Eggs-traordinary Adventure" "White Men Can't Jump" "Classic Cartoon Favorites: Starring Chip 'n' Dale" "No Man's Land" "That's Entertainment 3" "The Pigkeeper's Daughter / Sassy Sue" "Lil' Pimp" "Child's Play" "National Lampoon's Going the Distance" "Spike & Mike's Classic Festival of Animation" "Pokemon: The Advanced Master's Guide" "Lupin the 3rd: The Pursuit of Harimao's Treasure" "No Man's Land" "A Doll's House" "Amy's O" "Broadway's Lost Treasures II" "The Fabulous '50s" "Smilla's Sense of Snow" "Dance 'Til Dawn" "Tarzan's Secret Treasure / Tarzan's New York Adventure (Double Feature)" "Hal Roach's Rascals #1" "They Saved Hitler's Brain" "Weekend at Bernie's 2" "Mr. Holland's Opus" "The Devil's Arithmetic" "Nobody's Baby" "Trois 2: Pandora's Box" "I'll Be Seeing You" "Nicholas' Gift" "Nora's Hair Salon" "Everybody's Famous" "StarGaze: Hubble's View of the Universe" "National Geographic: King Tut's Final Secrets" "We're No Angels" "Ulee's Gold" "My Architect: A Son's Journey" "Pot o' Gold" "Keb' Mo': Sessions at West 54th" "Beauty and the Beast: Belle's Magical World" "Scooby-Doo and the Witch's Ghost" "It's Black Entertainment!" "Freddy's Dead: The Final Nightmare" "Whispers: An Elephant's Tale" "Boys Don't Cry" "Maggie and the Ferocious Beast: Let's Go to the Beach!" "Tony Hawk's Trick Tips: Vol. 2: Essentials of Street" "Guns N' Roses: Use Your Illusion II" "Shackleton's Antarctic Adventure: IMAX" "American Graffiti: Collector's Edition" "National Lampoon's Animal House" "Finian's Rainbow" "Rachel's Attic" "Queer Eye for the Straight Guy: Thom's Home" "What's Up, Doc?" "Elvis '56" "Kino's Journey" "Who's That Knocking at My Door?" "River's Edge" "It's My Party" "Classic Albums: The Who: Who's Next" "Alexander: Director's Cut: Bonus Material" "That's Entertainment 2" "Shintaro Katsu's Zatoichi: The Blind Swordsman" "James Stewart: Pot O' Gold/Made for Each Other" "Don't Tell Mom the Babysitter's Dead" "Schindler's List" "It's the Rage" "Hollywood Musicals of the '50s" "'Round Midnight" "The God Who Wasn't There" "Poker: More Secrets of No-Limit Hold 'Em" "Dracula: Pages from a Virgin's Diary" "Craig Shoemaker: Live: That's a True Story!" "Trainspotting: Collector's Edition: Bonus Material" "Agatha Christie's Poirot: The Hollow" "Lucio Fulci: Don't Torture a Duckling" "Don't Let Me Die on a Sunday" "What's New Scooby-Doo?" "What's Eating Gilbert Grape" "Pingu: Chillin' with Pingu" "Danielle Steel's Remembrance" "Clifford's Really Big Movie" "It's a Wonderful Life" "WWE: Bad Blood '04" "Relax ... It's Just Sex" "Kiki's Delivery Service" "The Best of Ripley's Believe It or Not" "Chaplin's Essanay Comedies: Vol. 1" "The Odyssey of Life: The Photographer's Secrets: Nova" "I'll Take You There" "Ulysses' Gaze" "Don't Try This at Home: The Steve-O Video" "Sharpe 6: Sharpe's Gold" "Casanova's Big Night" "Heaven's Burning" "National Lampoon's European Vacation" "Andy Kaufman: I'm from Hollywood/My Breakfast with Blassie" "Come Together: A Night for John Lennon's Words and Music" "Harry Potter and the Sorcerer's Stone: Bonus Material" "Big Girls Don't Cry" "Murphy's War" "My Wife's Murder" "Dragon Tales: Don't Give Up!" "Gone Fishin'" "Gentleman's Agreement" "Bryan Kest's Power Yoga" "Scooby-Doo's Creepiest Capers" "The General's Daughter" "Stephen King's The Shining" "Jamie Oliver: Jamie's Kitchen" "Mockingbird Don't Sing" "Carmen Electra's Aerobic Striptease" "The Damned Don't Cry" "Blue's Clues: Blue's Big Band" "Cheech & Chong's Still Smokin" "Dragon Tales: It's Cool to Be Me!" "Popeye the Sailor Man: Collector's Edition" "Cheech & Chong's The Corsican Brothers" "What's Happening!!: Season 1" "The Hitcher II: I've Been Waiting" "Surviving Gilligan's Island" "Cutter's Way" "Marquis de Sade's Justine" "Gracie's Choice" "The Ballad of Ramblin' Jack" "Jennifer Lopez: Let's Get Loud" "Winnie the Pooh: 123's" "I'm the One That I Want" "Nobody's Fool" "Troma's War" "My Father's Glory" "Donnie Darko: Director's Cut" "It's in the Water" "Little House on the Prairie: There's No Place Like Home" "Dizzy's Dream Band" "Bush's Brain" "Joe's Apartment" "INXS: The Best of INXS: I'm Only Looking" "This Boy's Life" "Don't Tell Anyone" "Casque d'Or" "'Allo 'Allo!: Series 3" "Dora the Explorer: Dora's Map Adventures" "Extreme Engineering: Building Hong Kong's Airport" "Ben-Hur: Collector's Edition" "The Beach Boys: Good Timin': Live at Knebworth" "Dawson's Creek: Season 3" "Mo'Nique: One Night Stand" "Lorenzo's Oil" "Elvis Presley: Elvis: '68 Comeback Special" "Without You I'm Nothing" "My Best Friend's Wife" "NBA Ultimate Jordan: 20th Anniversary Collector's Edition" "Hook'd Up" "Don't Be a Menace to South Central While Drinking Your Juice in the Hood" "Cinderella: Rodgers & Hammerstein's" "Snake in Eagle's Shadow" "The Nazi Officer's Wife" "Spider-Man: The '67 Classic Collection" "Trainspotting: Collector's Edition" "God's Little Acre" "Three's Company: Season 3" "Jacob's Ladder" "There's Something About McConkey" "Hanzo the Razor: Who's Got the Gold?" "Midsomer Murders: Death's Shadow" "Sesame Street: Elmo's World: Birthdays, Games & More" "Murphy's Law" "Disney's Little Einsteins: Our Big Huge Adventure" "An Autumn's Tale" "America's Heart and Soul" "H.G. Wells' The War of the Worlds: The Real Story" "The French Lieutenant's Woman" "National Lampoon's Holiday Reunion" "McLintock! Collector's Edition" "Smiley's People" "Another Man's Poison" "What's Love Got to Do with It" "Broadway's Lost Treasures III: The Best of the Tony Awards" "Changing Rooms: Trust Me, I'm a Designer" "Amityville 1992: It's About Time" "In Harm's Way" "Ben-Hur: Collector's Edition: Bonus Material" "You've Got Mail" "Benjamin's Woman" "Late Night with Conan O'Brien 10th Anniversary Special" "Cartoon Crazys Kids' All Time Favorites" "I'll Take Manhattan" "Chaplin's Essanay Comedies: Vol. 2" "Guess Who's Coming to Dinner" "Dragon Ball Z: The World's Strongest" "National Geographic: China's Lost Girls" "Sharpe 13: Sharpe's Justice" "Walk, Don't Run" "Hang 'Em High" "Leonard Bernstein's Young People's Concerts" "Stephen Hawking's Universe" "Bruce Lee's Jeet Kune Do" "Barney: Let's Play School" "Caillou: Caillou's Summertime and Other Adventures" "Ayane's High Kick" "The Rutles 2: Can't Buy Me Lunch" "J.D.'s Revenge" "George Balanchine's The Nutcracker" "Warren Miller's: Ride" "Linnea in Monet's Garden" "Mariah Carey: #1's" "A Soldier's Tale" "Mobile Suit Gundam: Char's Counterattack" "America's National Parks" "Eat Man '98" "Pee-Wee's Playhouse: Vol. 2" "Human Condition III: A Soldier's Prayer" "The Captain's Paradise" "Cameron's Closet" "The Son's Room" "Livin' tha Life" "The Avengers '63" "Salem's Lot" "Mom's Outta Sight!" "The Draughtsman's Contract" "The Avengers '66" "Ocean's Eleven" "Coal Miner's Daughter: Collector's Edition" "Stan Lee's Mutants, Monsters & Marvels" "Pokemon Master Quest: Collector's Box: Quest 1" "The Best of Rowan & Martin's Laugh-In" "Lemora: A Child's Tale of the Supernatural" "Fellini's Roma" "The Brain That Wouldn't Die" "Wes Craven's New Nightmare" "Asylum of Satan / Satan's Children" "The Sid Caesar Collection: Inside the Writer's Room" "Dragon Ball Z: Great Saiyaman: Gohan's Secret" "The Pennsylvania Miners' Story" "Danielle Steel's Once in a Lifetime" "Fellini: I'm a Born Liar" "Alien 3: Collector's Edition" "Mystery Science Theater 3000: Mr. B's Lost Shorts" "Sharpe 1: Sharpe's Rifles" "'Allo 'Allo!: Series 1" "Lord Stanley's Cup: Hockey's Ultimate Prize" "The Seagull's Laughter" "Samurai X: Trust and Betrayal, Director's Cut" "Don't Look Now" "WWF: Hell Yeah: Stone Cold's Saga Continues" "The Preacher's Wife" "Harold Robbins' Body Parts" "Fat Albert's Greatest Hits: The Ultimate Collection" "The Man Who Wasn't There" "Guns N' Roses: Welcome to the Videos" "Spider's Web" "Madea's Class Reunion" "Love's Enduring Promise" "Sesame Street: Elmo's World: Wild Wild West" "The Pilot's Wife" "How to Kill Your Neighbor's Dog" "A Woman's a Helluva Thing" "She's All That" "Grateful Dead: Ticket to New Year's" "Sheryl Crow: Rockin' the Globe Live" "A Connecticut Yankee in King Arthur's Court / The Emperor Waltz: Double Feature" "Tony Hawk's Gigantic Skatepark Tour 2002" "Fairly Oddparents: School's Out! The Musical" "Hell's Gate" "Lemony Snicket's A Series of Unfortunate Events" "Brainy Baby: ABC's" "I've Heard the Mermaids Singing" "Puff the Magic Dragon / Gulliver's Travels" "Jeff Foxworthy's Comedy Classics" "Elmo's Magic Cookbook" "Gilligan's Island: Season 3" "National Geographic: The Search for Kennedy's PT 109" "Monsieur Beaucaire / Where There's Life: Double Feature" "Three's Company: Season 2" "Jane's Addiction: Three Days" "I'm All Right Jack" "Vampire's Kiss" "What's Happening!!: Season 3" "Love Don't Cost a Thing" "I'm Losing You" "Hunter's Moon" "A Pyromaniac's Love Story" "All the King's Men" "Cheech & Chong's Next Movie" "I'll Be Seeing You" "I'm Going Home" "Crazy Richard & I Can't Even Think Straight" "L'Effrontee" "NBA: Larry Bird: A Basketball Legend: 25th Anniversary Collector's Edition" "Devon's Ghost: Legend of the Bloody Boy" "Bill & Ted's Excellent Adventure" "One Night at McCool's" "Brian's Song" "Maria's Lovers" "He Sees You When You're Sleeping" "High Times' Potluck" "She's Too Young" "Dragon Ball GT: A Hero's Legacy" "Don't Ask, Don't Tell (Attack of the Gay Space Invaders)" "In God's Hands" "Carla's Song" "Marvin Gaye: Greatest Hits Live in '76" "Warren Miller's: The Power of Snow: Fifty" "You're the Top: The Cole Porter Story" "Wayne's World 2" "L'Auberge Espagnole" "Benny Hill's World Tour: New York" "Agatha Christie's Seven Dials Mystery" "Midsomer Murders: The Killings at Badger's Drift" "AFI's 100 Years, 100 Stars" "America's Stone Age Explorers: Nova" "Scooby-Doo's Greatest Mysteries" "Let's Make Love" "What's the Worst That Could Happen?" "The History Channel Presents: Julius Caesar's Rome" "Alice Doesn't Live Here Anymore" "John Cleese's Wine for the Confused" "Another Woman's Husband" "Sesame Street: Elmo's World: Head to Toe with Elmo" "Barney: Let's Go to the Zoo" "It's All About Love" "Dragon Ball Z: Cooler's Revenge" "Barney's Read with Me / Dance with Me" "Jim Henson's The Storyteller: Greek Myths" "Dragon's World: A Fantasy Made Real" "C-Walk: It's a Way of Livin'" "The Devil at 4 o'clock" "There's No Business Like Show Business" "That's the Way I Like It" "H.G. Wells' War of the Worlds" "99 Women (Unrated Director's Cut)" "Jackie Brown: Collector's Series: Bonus Material" "Uncle Tom's Cabin" "The Lion King II: Simba's Pride" "The Battle of the Bulge: World War II's Deadliest Battle" "I'm Not Rappaport" "Donovan's Brain" "You'll Never Get Rich" "A Bug's Life: Bonus Material" "Horatio's Drive: America's First Road Trip" "Brian's Song" "Dragon Ball Z: Broly's Second Coming" "Charlotte's Web 2: Wilbur's Great Adventure" "Paul Simon: You're the One: In Concert from Paris" "What's Cooking?" "Water's Edge" "That's So Raven: Supernaturally Stylish" "Payne Stewart's DVD Guide of Golf Etiquette" "The Bishop's Wife" "David Alan Grier: The Book of David: The Cult Figure's Manifesto" "Mummy's Kiss" "Inspector Gadget's Last Case" "Mr. Toad's Wild Ride" "Alvin Lee's Ten Years Later: Best of Rockpalast" "Sharky's Machine" "Bang Bang You're Dead" "Swing: Cal Pozo's Learn to Dance in Minutes" "Let's Do It Again" "I Don't Know Jack" "Akira Kurosawa's Dreams" "Carlito's Way: Rise to Power" "Sesame Street: Elmo's World: Springtime Fun" "The Devil's Advocate" "She's the One" "Love's Labour's Lost" "The Three Stooges: All the World's a Stooge" "Other People's Money" "I Love You, Don't Touch Me" "Joe Bob Briggs Presents: Jesse James Meets Frankenstein's Daughter" "Look Who's Talking Now" "Bill Engvall's New All-Stars of Country Comedy: Vol. 2" "Agatha Christie's Endless Night" "Sesame Street: Kids' Favorite Songs" "Unlocking Da Vinci's Code: Mystery or Conspiracy?" "Soldier's Girl" "Michael Moore's The Awful Truth: Season 1" "Wes Craven's Summer of Fear" "We Don't Live Here Anymore" "The Razor's Edge" "Beethoven's 3rd" "Danielle Steel's Mixed Blessings" "Bob Mann's Automatic Golf" "That's Entertainment" "Breakin' All the Rules" "Elvira's Horror Classics" "The True Meaning of Pictures: Shelby Lee Adams' Appalachia" "It's the Easter Beagle, Charlie Brown" "The Razor's Edge" "Blue's Clues: Shapes and Colors" "Breakin'" "Who's Afraid of Virginia Woolf?" "I'm With Lucy" "Davey and Goliath: Vol. 1: Collector's Edition" "Don't Tempt Me" "Bill Engvall's New All-Stars of Country Comedy: Vol. 1" "Dr. Seuss' How the Grinch Stole Christmas" "They Shoot Horses, Don't They?" "James' Journey to Jerusalem" "Harry Potter and the Sorcerer's Stone" "The Best of Too Hot for Troma's Edge TV: Vol. 1" "Carmen Electra's Hip Hop" "Teacher's Pet" "Popeye's Voyage: Quest for Pappy" "Jerry Seinfeld: I'm Telling You for the Last Time" "Elizabeth Taylor: The Last Time I Saw Paris/Father's Little Dividend" "Godzilla's Revenge"

command

select * from movie where title ~ ';

4. How many movies have titles that begin with the word “Star”?

88

command

select count(*) from movie where title like 'Star%';

5. How many movies, on a year by year basis, were released in the 1940s (years 1940 to 1949)?

1940 - 34 movies released
1941 - 33 movies released
1942 - 33 movies released
1943 - 33 movies released
1944 - 36 movies released
1945 - 37 movies released
1946 - 39 movies released
1947 - 37 movies released
1948 - 36 movies released
1949 - 41 movies released

command

select year, count(*) from movie where year >= 1940 and year < 1950 group by year order by year

6. Which movies, in alphabetical order, did member number 42 rate as a “5”?

Bruce Lee: A Warrior's Journey
Donnie Darko: Director's Cut
The Legend of Zelda: Ganon's Evil Tower
Zatoichi's Conspiracy

command

select title, rating from movie inner join rating on (movie.id = rating.movie) where member = 42 and rating = 5 order by title

7. Produce a table that lists every movie that has been rated, the rating that the movie got, and the name of the member that gave this rating.

Title;Rating;Member Name

"Something's Gotta Give";4;"Doug"
"Zatoichi's Conspiracy";4;"Natalie"
"Zatoichi's Conspiracy";5;"Doug"
"Bruce Lee: A Warrior's Journey";2;"Natalie"
"Bruce Lee: A Warrior's Journey";5;"Doug"
"Star Trek: Deep Space Nine: Season 5";5;"Natalie"
"Star Trek: The Next Generation: Season 5";5;"Natalie"
"Star Wars: Ewok Adventures: Caravan of Courage / The Battle for Endor";1;"Natalie"
"Sesame Street: Cookie Monster's Best Bites";3;"Boomer"
"The Legend of Zelda: Ganon's Evil Tower";5;"Doug"
"Hello Kitty's Paradise";3;"Doug"
"Sesame Street: Elmo's Sing-Along Guessing Game";4;"Doug"
"Star Trek V: The Final Frontier";2;"Natalie"
"Star Wars: Episode II: Attack of the Clones";1;"Boomer"
"Star Trek: Nemesis";2;"Natalie"
"Star Wars: Episode VI: Return of the Jedi";5;"Boomer"
"Weekend at Bernie's";4;"Doug"
"Star Wars: Episode I: The Phantom Menace: Bonus Material";2;"Boomer"
"Star Trek: Insurrection";1;"Boomer"
"Donnie Darko: Director's Cut";5;"Doug"
"Pokemon Master Quest: Collector's Box: Quest 1";3;"Doug"
"She's All That";1;"Doug"
"She's All That";3;"Boomer"
"Star Trek V: The Final Frontier: Bonus Material";2;"Boomer"

command

select title, rating, name from movie inner join rating on (movie.id = rating.movie) inner join member on (member.id = rating.member)

8. How many movies has member number 42 rated as 1, 2, 3, 4, and 5, respectively?

rating:number

1:1 2:0 3:2 4:3 5:4

command

select * from movie inner join rating on (movie.id = rating.movie) inner join member on (member.id = rating.member) where member = 42 order by rating

9. What is the average rating of movies that begin with the word “Star”?

0

command

select avg(rating) from movie inner join rating on (movie.id = rating.movie) where title like 'Star%'

10. What movies, in alphabetical order, did member number 6 rate as a 3?

"Bruce Lee: A Warrior's Journey"
"Star Trek V: The Final Frontier"
"Star Trek: Deep Space Nine: Season 5"
"Star Trek: Nemesis"
"Star Trek: The Next Generation: Season 5"
"Star Wars: Ewok Adventures: Caravan of Courage / The Battle for Endor"
"Zatoichi's Conspiracy"

command

select title from movie inner join rating on (movie.id = rating.movie) inner join member on (member.id = rating.member) where member = 6 order by title

Kmeilak (talk) 21:20, 12 September 2013 (PDT)

Kmeilak Week 6

Movies from Text File to Tables

Personal tools

Namespaces

Variants

Views

Actions

Search

Navigation

Toolbox