Table of Contents
Lorem ipsum dolor sit, amet consectetur adipisicing elit. Odio porro similique eveniet tenetur voluptas at? Perferendis sunt temporibus fuga in?
-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: localhost:8889
-- Generation Time: Feb 20, 2023 at 06:56 AM
-- Server version: 5.7.39
-- PHP Version: 7.4.33
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `disney`
--
-- --------------------------------------------------------
--
-- Table structure for table `director`
--
CREATE TABLE `director` (
`movie_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`director` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `director`
--
INSERT INTO `director` (`movie_title`, `director`) VALUES
('Snow White and the Seven Dwarfs', 'David Hand'),
('Pinocchio', 'Ben Sharpsteen'),
('Fantasia', 'full credits'),
('Dumbo', 'Ben Sharpsteen'),
('Bambi', 'David Hand'),
('Saludos Amigos', 'Jack Kinney'),
('The Three Caballeros', 'Norman Ferguson'),
('Make Mine Music', 'Jack Kinney'),
('Fun and Fancy Free', 'Jack Kinney'),
('Melody Time', 'Clyde Geronimi'),
('The Adventures of Ichabod and Mr. Toad', 'Jack Kinney'),
('Cinderella', 'Wilfred Jackson'),
('Alice in Wonderland', 'Clyde Geronimi'),
('Peter Pan', 'Hamilton Luske'),
('Lady and the Tramp', 'Hamilton Luske'),
('Sleeping Beauty', 'Clyde Geronimi'),
('101 Dalmatians', 'Wolfgang Reitherman'),
('The Sword in the Stone', 'Wolfgang Reitherman'),
('The Jungle Book', 'Wolfgang Reitherman'),
('The Aristocats', 'Wolfgang Reitherman'),
('Robin Hood', 'Wolfgang Reitherman'),
('The Many Adventures of Winnie the Pooh', 'Wolfgang Reitherman'),
('The Rescuers', 'Wolfgang Reitherman'),
('The Fox and the Hound', 'Art Stevens'),
('The Black Cauldron', 'Ted Berman'),
('The Great Mouse Detective', 'Ron Clements'),
('Oliver & Company', 'George Scribner'),
('The Little Mermaid', 'Ron Clements'),
('The Rescuers Down Under', 'Mike Gabriel'),
('Beauty and the Beast', 'Gary Trousdale'),
('Aladdin', 'Ron Clements'),
('The Lion King', 'Roger Allers'),
('Pocahontas', 'Mike Gabriel'),
('The Hunchback of Notre Dame', 'Gary Trousdale'),
('Hercules', 'Ron Clements'),
('Mulan', 'Barry Cook'),
('Tarzan', 'Chris Buck'),
('Fantasia 2000', 'full credits'),
('Dinosaur', 'Ralph Zondag'),
('The Emperor\'s New Groove', 'Mark Dindal'),
('Atlantis: The Lost Empire', 'Gary Trousdale'),
('Lilo & Stitch', 'Chris Sanders'),
('Treasure Planet', 'Ron Clements'),
('Brother Bear', 'Robert Walker'),
('Home on the Range', 'Will Finn'),
('Chicken Little', 'Mark Dindal'),
('Meet the Robinsons', 'Stephen J. Anderson'),
('Bolt', 'Chris Williams'),
('The Princess and the Frog', 'Ron Clements'),
('Tangled', 'Nathan Greno'),
('Winnie the Pooh', 'Stephen J. Anderson'),
('Wreck-It Ralph', 'Rich Moore'),
('Frozen', 'Chris Buck'),
('Big Hero 6', 'Don Hall'),
('Zootopia', 'Byron Howard'),
('Moana', 'Ron Clements');
-- --------------------------------------------------------
--
-- Table structure for table `disney_char`
--
CREATE TABLE `disney_char` (
`movie_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`release_date` date DEFAULT NULL,
`hero` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`villian` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`song` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `disney_char`
--
INSERT INTO `disney_char` (`movie_title`, `release_date`, `hero`, `villian`, `song`) VALUES
('Snow White and the Seven Dwarfs', '1937-12-21', 'Snow White', 'Evil Queen', 'Some Day My Prince Will Come'),
('Pinocchio', '1940-02-07', 'Pinocchio', 'Stromboli', 'When You Wish upon a Star'),
('Fantasia', '1940-11-13', NULL, 'Chernabog', NULL),
('Dumbo', '1941-10-23', 'Dumbo', 'Ringmaster', 'Baby Mine'),
('Bambi', '1942-08-13', 'Bambi', 'Hunter', 'Love Is a Song'),
('Saludos Amigos', '1943-02-06', 'Donald Duck', NULL, 'Saludos Amigos'),
('The Three Caballeros', '1945-02-03', 'Donald Duck', NULL, NULL),
('Make Mine Music', '1946-04-20', NULL, NULL, NULL),
('Fun and Fancy Free', '1947-09-27', 'Mickey Mouse', 'Willie the Giant', NULL),
('Melody Time', '1948-05-27', NULL, NULL, 'Little Toot'),
('The Adventures of Ichabod and Mr. Toad', '1949-10-05', 'Mr. Toad and Ichabod Crane', 'Mr. Winkie and The Headless Horseman', 'The Merrily Song'),
('Cinderella', '1950-02-15', 'Cinderella', 'Lady Tremaine', 'Bibbidi-Bobbidi-Boo'),
('Alice in Wonderland', '1951-07-28', 'Alice', 'Queen of Hearts', 'The Unbirthday Song'),
('Peter Pan', '1953-02-05', 'Peter Pan', 'Captain Hook', 'You Can Fly!'),
('Lady and the Tramp', '1955-06-22', 'Lady and Tramp', 'Si and Am', 'Bella Notte'),
('Sleeping Beauty', '1959-01-29', 'Aurora', 'Maleficent', 'Once Upon a Dream'),
('One Hundred and One Dalmatians', '1961-01-25', 'Pongo', 'Cruella de Vil', 'Cruella De Vil'),
('The Sword in the Stone', '1963-12-25', 'Arthur', 'Madam Mim', 'Higitus Figitus'),
('The Jungle Book', '1967-10-18', 'Mowgli', 'Kaa and Shere Khan', 'The Bare Necessities'),
('The Aristocats', '1970-12-24', 'Thomas and Duchess', 'Edgar Balthazar', 'Ev\'rybody Wants to Be a Cat'),
('Robin Hood', '1973-11-08', 'Robin Hood', 'Prince John', 'Oo De Lally'),
('The Many Adventures of Winnie the Pooh', '1977-03-11', 'Winnie the Pooh', NULL, 'Winnie the Pooh'),
('The Rescuers', '1977-06-22', 'Bernard and Miss Bianca', 'Madame Medusa', 'The Journey'),
('The Fox and the Hound', '1981-07-10', 'Tod and Copper', 'Amos Slade', 'Best of Friends'),
('The Black Cauldron', '1985-07-24', 'Taran', 'Horned King', NULL),
('The Great Mouse Detective', '1986-07-02', 'Basil', 'Professor Ratigan', 'The World\'s Greatest Criminal Mind'),
('Oliver & Company', '1988-11-18', 'Oliver', 'Sykes', 'Once Upon a Time in New York City'),
('The Little Mermaid', '1989-11-17', 'Ariel', 'Ursula', 'Under the Sea'),
('The Rescuers Down Under', '1990-11-16', 'Bernard and Miss Bianca', 'Percival C. McLeach', ''),
('Beauty and the Beast', '1991-11-22', 'Belle', 'Gaston', 'Be Our Guest'),
('Aladdin', '1992-11-25', 'Aladdin', 'Jafar', 'A Whole New World'),
('The Lion King', '1994-06-24', 'Simba', 'Scar', 'Circle of Life'),
('Pocahontas', '1995-06-23', 'Pocahontas', 'Governor Ratcliffe', 'Colors of the Wind'),
('The Hunchback of Notre Dame', '1996-06-21', 'Quasimodo', 'Claude Frollo', 'God Help the Outcasts'),
('Hercules', '1997-06-27', 'Hercules', 'Hades', 'Go the Distance'),
('Mulan', '1998-06-19', 'Mulan', 'Shan Yu', 'I\'ll Make a Man Out of You'),
('Tarzan', '1999-06-18', 'Tarzan', 'Clayton', 'You\'ll Be in My Heart'),
('Fantasia 2000', '1999-12-17', NULL, NULL, NULL),
('Dinosaur', '2000-05-19', 'Aladar', 'Kron', NULL),
('The Emperor\'s New Groove', '2000-12-15', 'Kuzco', 'Yzma', 'My Funny Friend and Me'),
('Atlantis: The Lost Empire', '2001-06-15', 'Milo Thatch', 'Commander Rourke', 'Where the Dream Takes You'),
('Lilo & Stitch', '2002-06-21', 'Lilo and Stitch', NULL, 'He Mele No Lilo'),
('Treasure Planet', '2002-11-27', 'Jim Hawkins', 'John Silver', 'I\'m Still Here'),
('Brother Bear', '2003-11-01', 'Kenai', 'Denahi', 'Look Through My Eyes'),
('Home on the Range', '2004-04-02', 'Maggie', 'Alameda Slim', NULL),
('Chicken Little', '2005-11-04', 'Ace Cluck', 'Foxy Loxy', NULL),
('Meet the Robinsons', '2007-03-30', 'Lewis', 'Doris', 'Little Wonders'),
('Bolt', '2008-11-21', 'Bolt', 'Dr. Calico', 'I Thought I Lost You'),
('The Princess and the Frog', '2009-12-11', 'Tiana', 'Dr. Facilier', 'Almost There'),
('Tangled', '2010-11-24', 'Rapunzel', 'Mother Gothel', 'I See the Light'),
('Winnie the Pooh', '2011-07-15', 'Winnie the Pooh', NULL, 'Winnie the Pooh'),
('Wreck-It Ralph', '2012-11-02', 'Ralph', 'Turbo', 'Sugar Rush'),
('Frozen', '2013-11-27', 'Elsa', 'Prince Hans', 'Let It Go'),
('Big Hero 6', '2014-11-07', 'Hiro Hamada', 'Professor Callaghan', 'Immortals'),
('Zootopia', '2016-03-04', 'Judy Hopps', NULL, 'Try Everything'),
('Moana', '2016-11-23', 'Moana', NULL, 'How Far I\'ll Go');
-- --------------------------------------------------------
--
-- Table structure for table `movie_gross`
--
CREATE TABLE `movie_gross` (
`movie_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`release_date` date DEFAULT NULL,
`genre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`mpaa_rating` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`total_gross` bigint(20) DEFAULT NULL,
`inflation_adjusted_gross` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `movie_gross`
--
INSERT INTO `movie_gross` (`movie_title`, `release_date`, `genre`, `mpaa_rating`, `total_gross`, `inflation_adjusted_gross`) VALUES
('Snow White and the Seven Dwarfs', '1937-12-21', 'Musical', 'G', 184925485, 5228953251),
('Pinocchio', '1940-02-09', 'Adventure', 'G', 84300000, 2188229052),
('Fantasia', '1940-11-13', 'Musical', 'G', 83320000, 2187090808),
('Song of the South', '1946-11-12', 'Adventure', 'G', 65000000, 1078510579),
('Cinderella', '1950-02-15', 'Drama', 'G', 85000000, 920608730),
('20,000 Leagues Under the Sea', '1954-12-23', 'Adventure', NULL, 28200000, 528279994),
('Lady and the Tramp', '1955-06-22', 'Drama', 'G', 93600000, 1236035515),
('Sleeping Beauty', '1959-01-29', 'Drama', NULL, 9464608, 21505832),
('101 Dalmatians', '1961-01-25', 'Comedy', 'G', 153000000, 1362870985),
('The Absent Minded Professor', '1961-03-16', 'Comedy', NULL, 25381407, 310094574),
('Babes in Toyland', '1961-12-14', 'Musical', 'G', 10218316, 124841160),
('Bon Voyage!', '1962-05-17', 'Comedy', 'Not Rated', 9230769, 109581646),
('The Sword in the Stone', '1963-12-25', 'Adventure', NULL, 22182353, 153870834),
('The Jungle Book', '1967-10-18', 'Musical', 'Not Rated', 141843000, 789612346),
('Blackbeard\'s Ghost', '1968-02-08', 'Comedy', NULL, 21540050, 138612686),
('The Aristocats', '1970-04-24', 'Musical', 'G', 55675257, 255161499),
('The Boatniks', '1970-07-01', 'Comedy', NULL, 18607492, 101200742),
('Bedknobs and Broomsticks', '1971-10-07', 'Musical', NULL, 17871174, 91305448),
('The Apple Dumpling Gang', '1975-07-01', 'Comedy', NULL, 31916500, 131246872),
('Freaky Friday', '1977-01-21', 'Comedy', NULL, 25942000, 98067733),
('The Many Adventures of Winnie the Pooh', '1977-03-11', NULL, NULL, 0, 0),
('The Rescuers', '1977-06-22', 'Adventure', NULL, 48775599, 159743914),
('Herbie Goes to Monte Carlo', '1977-06-24', NULL, NULL, 28000000, 105847527),
('The Black Hole', '1979-12-21', NULL, NULL, 35841901, 120377374),
('Midnight Madness', '1980-02-08', NULL, NULL, 2900000, 9088096),
('The Last Flight of Noah’s Ark', '1980-06-25', NULL, NULL, 11000000, 34472116),
('The Devil and Max Devlin', '1981-01-01', NULL, NULL, 16000000, 48517980),
('Amy', '1981-03-20', 'Drama', NULL, 0, 0),
('The Fox and the Hound', '1981-07-10', 'Comedy', NULL, 43899231, 133118889),
('Condorman', '1981-08-07', 'Action', NULL, 0, 0),
('Night Crossing', '1982-02-05', 'Drama', NULL, 4500000, 12903059),
('Tron', '1982-07-09', 'Action', NULL, 26918576, 77184895),
('Tex', '1982-11-19', 'Drama', NULL, 7199408, 20643199),
('Trenchcoat', '1983-03-11', 'Comedy', NULL, 4304286, 11519089),
('Something Wicked This Way Comes', '1983-04-29', 'Horror', NULL, 5656087, 15136765),
('Never Cry Wolf', '1983-10-07', 'Drama', NULL, 27668764, 70669955),
('Running Brave', '1983-11-04', 'Drama', NULL, 1204595, 3223725),
('Splash', '1984-03-09', 'Comedy', 'PG', 62599495, 157057661),
('Country', '1984-09-29', 'Drama', NULL, 8400000, 21075000),
('Baby: Secret of the Lost Legend', '1985-03-22', 'Adventure', NULL, 14276095, 33900697),
('Return to Oz', '1985-06-21', 'Adventure', NULL, 10618813, 25215934),
('The Black Cauldron', '1985-07-24', 'Adventure', NULL, 21288692, 50553142),
('My Science Project', '1985-08-09', 'Comedy', NULL, 4100000, 9736051),
('The Journey of Natty Gann', '1985-09-27', 'Drama', NULL, 9468512, 22302956),
('One Magic Christmas', '1985-11-22', 'Drama', NULL, 13229514, 31415432),
('Down and Out in Beverly Hills', '1986-01-31', 'Comedy', 'R', 62134225, 141183693),
('Off Beat', '1986-04-11', 'Comedy', NULL, 4842778, 11003932),
('Ruthless People', '1986-06-27', 'Comedy', 'R', 71624879, 162748712),
('The Great Mouse Detective', '1986-07-02', 'Adventure', NULL, 23605534, 53637367),
('Flight of the Navigator', '1986-07-30', 'Adventure', NULL, 18564613, 42183197),
('Tough Guys', '1986-10-03', 'Comedy', NULL, 21458229, 48758184),
('The Color of Money', '1986-10-17', 'Drama', 'R', 52293000, 117957323),
('Outrageous Fortune', '1987-01-30', 'Comedy', 'R', 52864741, 113976921),
('Tin Men', '1987-03-06', 'Comedy', NULL, 25411386, 54787202),
('Ernest Goes to Camp', '1987-05-22', 'Comedy', NULL, 23509382, 50686462),
('Benji the Hunted', '1987-06-05', 'Adventure', NULL, 15212539, 32798382),
('Adventures in Babysitting', '1987-07-03', 'Comedy', NULL, 33790923, 72853569),
('Stakeout', '1987-08-05', 'Comedy', 'R', 65673233, 141592160),
('Can\'t Buy Me Love', '1987-08-14', 'Romantic Comedy', NULL, 31623833, 68181300),
('Hello Again', '1987-11-06', 'Comedy', NULL, 20419446, 44024529),
('3 Men and a Baby', '1987-11-25', 'Comedy', 'PG', 167780960, 353334607),
('Good Morning Vietnam', '1987-12-23', 'Comedy', 'R', 123922370, 254414837),
('Shoot to Kill', '1988-02-12', 'Action', NULL, 29300000, 60097074),
('D.O.A.', '1988-03-18', 'Thriller/Suspense', NULL, 12706478, 26062188),
('Return to Snowy River', '1988-04-15', 'Adventure', 'PG', 13687027, 28073384),
('Big Business', '1988-06-10', 'Comedy', 'PG', 40150487, 82352451),
('Who Framed Roger Rabbit?', '1988-06-22', 'Comedy', 'PG', 154112492, 316250084),
('Cocktail', '1988-07-29', 'Drama', 'R', 78222753, 160442289),
('The Rescue', '1988-08-05', 'Action', NULL, 5855392, 12009960),
('Heartbreak Hotel', '1988-09-30', 'Comedy', NULL, 5509417, 11300331),
('The Good Mother', '1988-11-04', 'Drama', NULL, 4764606, 9772655),
('Ernest Saves Christmas', '1988-11-11', 'Comedy', 'PG', 28202109, 57845202),
('Oliver & Company', '1988-11-18', 'Adventure', 'G', 49576671, 102254492),
('Beaches', '1988-12-21', 'Drama', 'PG-13', 57041866, 120381757),
('Three Fugitives', '1989-01-27', 'Comedy', 'PG-13', 40590000, 85757817),
('New York Stories', '1989-03-01', 'Drama', 'PG', 10763469, 22740861),
('Disorganized Crime', '1989-04-14', 'Comedy', NULL, 7210149, 15233465),
('Dead Poets Society', '1989-06-02', 'Drama', 'PG', 95860116, 202531517),
('Honey, I Shrunk the Kids', '1989-06-23', 'Adventure', 'PG', 130724172, 276191669),
('Turner & Hooch', '1989-07-28', 'Comedy', 'PG', 71079915, 150176361),
('Cheetah', '1989-08-18', 'Adventure', NULL, 7882250, 16653473),
('An Innocent Man', '1989-10-06', 'Drama', 'R', 19397847, 40983414),
('Gross Anatomy', '1989-10-20', 'Drama', 'PG-13', 11346186, 23972012),
('The Little Mermaid', '1989-11-15', 'Adventure', 'G', 111543479, 223726012),
('Blaze', '1989-12-13', 'Drama', 'R', 19049727, 39884640),
('Stella', '1990-02-02', 'Drama', 'PG-13', 20062347, 40077147),
('Where the Heart Is', '1990-02-23', 'Comedy', NULL, 1106475, 2210321),
('Pretty Woman', '1990-03-23', 'Romantic Comedy', 'R', 178406268, 356389765),
('Ernest Goes to Jail', '1990-04-06', 'Comedy', 'PG', 25029569, 49999822),
('Spaced Invaders', '1990-04-27', 'Comedy', 'PG', 15000000, 29964452),
('Fire Birds', '1990-05-24', 'Action', 'PG-13', 14760451, 29485923),
('Dick Tracy', '1990-06-15', 'Action', 'PG', 103738726, 207231621),
('Betsy\'s Wedding', '1990-06-22', 'Comedy', 'R', 19740070, 39433357),
('Arachnophobia', '1990-07-18', 'Thriller/Suspense', 'PG-13', 53208180, 106290270),
('DuckTales: The Movie - Treasure of th…', '1990-08-03', 'Adventure', 'G', 18075331, 36107823),
('Taking Care of Business', '1990-08-17', 'Comedy', 'R', 20005435, 39963460),
('Mr. Destiny', '1990-10-12', 'Comedy', 'PG-13', 15379253, 30722056),
('The Rescuers Down Under', '1990-11-16', 'Adventure', 'G', 27931461, 55796728),
('3 Men and a Little Lady', '1990-11-21', 'Comedy', 'PG', 71609321, 143108869),
('Green Card', '1990-12-25', 'Romantic Comedy', 'PG-13', 29804169, 59679131),
('White Fang', '1991-01-18', 'Adventure', 'PG', 34729091, 69540672),
('Scenes from a Mall', '1991-02-22', 'Comedy', NULL, 9563393, 19149495),
('Haakon Haakonsen', '1991-03-01', 'Adventure', 'PG', 15024232, 30084149),
('The Marrying Man', '1991-04-05', 'Romantic Comedy', 'R', 12454768, 24939118),
('Oscar', '1991-04-26', 'Comedy', 'PG', 23562716, 47181395),
('One Good Cop', '1991-05-03', 'Action', 'R', 11276846, 22580472),
('What About Bob?', '1991-05-17', 'Comedy', 'PG', 63710000, 127571325),
('Wild Hearts Can\'t Be Broken', '1991-05-24', 'Drama', NULL, 7300000, 14617333),
('The Rocketeer', '1991-06-21', 'Action', 'PG', 46573027, 93256673),
('The Doctor', '1991-07-24', 'Drama', 'PG-13', 37497480, 75084021),
('Paradise', '1991-09-18', 'Drama', 'PG-13', 18634643, 37313540),
('Deceived', '1991-09-27', 'Thriller/Suspense', 'PG-13', 28738096, 57544453),
('Ernest Scared Stupid', '1991-10-11', 'Comedy', 'PG', 14143280, 28320147),
('Billy Bathgate', '1991-11-01', 'Drama', 'R', 15565363, 31167691),
('Beauty and the Beast', '1991-11-13', 'Musical', 'G', 218951625, 363017667),
('Father of the Bride', '1991-12-20', 'Comedy', 'PG', 89325780, 179821881),
('The Hand That Rocks the Cradle', '1992-01-10', 'Thriller/Suspense', 'R', 88036683, 178831137),
('Medicine Man', '1992-02-07', 'Drama', 'PG-13', 44948240, 91304495),
('Blame it on the Bellboy', '1992-03-06', 'Comedy', 'PG-13', 2891055, 5872667),
('Noises Off...', '1992-03-20', 'Comedy', 'PG-13', 2280148, 4631720),
('Straight Talk', '1992-04-03', 'Comedy', 'PG', 21202099, 43068356),
('Newsies', '1992-04-08', NULL, 'PG', 2706352, 5497481),
('Passed Away', '1992-04-24', NULL, 'PG-13', 4030793, 8187848),
('Encino Man', '1992-05-22', 'Comedy', 'PG', 40057130, 81369058),
('Sister Act', '1992-05-29', 'Comedy', 'PG', 139605150, 283583472),
('Honey I Blew Up the Kid', '1992-07-17', 'Comedy', 'PG', 58662452, 119162518),
('A Stranger Among Us', '1992-07-17', 'Drama', 'PG-13', 12282994, 24950752),
('3 Ninjas', '1992-08-07', 'Action', 'PG', 29028000, 58965304),
('A Gun in Betty Lou\'s Handbag', '1992-08-21', NULL, 'PG-13', 3591460, 7295423),
('Captain Ron', '1992-09-18', 'Comedy', 'PG-13', 22518097, 45741576),
('Sarafina!', '1992-09-18', 'Drama', 'PG-13', 7306242, 14841352),
('Innocent Blood', '1992-09-25', 'Horror', 'R', 4877567, 9907922),
('The Mighty Ducks', '1992-10-02', 'Comedy', 'PG', 50752337, 103120810),
('1492: Conquest of Paradise', '1992-10-09', 'Adventure', 'PG-13', 7099531, 14421454),
('Consenting Adults', '1992-10-16', 'Drama', 'R', 21591728, 43859823),
('Aladdin', '1992-11-11', 'Comedy', 'G', 217350219, 441969178),
('The Distinguished Gentleman', '1992-12-04', 'Comedy', 'R', 46434570, 94349900),
('The Muppet Christmas Carol', '1992-12-11', 'Comedy', 'G', 27281507, 55417615),
('Alive', '1993-01-15', 'Adventure', 'R', 36299670, 73914543),
('Aspen Extreme', '1993-01-22', 'Romantic Comedy', 'PG-13', 7843388, 15970955),
('Homeward Bound: The Incredible Journey', '1993-02-03', 'Adventure', 'G', 41833324, 85182343),
('The Cemetery Club', '1993-02-03', 'Comedy', 'PG-13', 5583621, 11369541),
('Swing Kids', '1993-03-05', 'Musical', 'PG-13', 5632086, 11468231),
('A Far Off Place', '1993-03-12', 'Adventure', 'PG', 12890752, 26248558),
('Born Yesterday', '1993-03-26', 'Romantic Comedy', 'PG', 17760754, 36165012),
('The Adventures of Huck Finn', '1993-04-02', 'Adventure', 'PG', 24103594, 49080505),
('Bound by Honor', '1993-04-16', NULL, 'R', 4496583, 9156084),
('Indian Summer', '1993-04-23', 'Comedy', 'R', 14717851, 29968953),
('Super Mario Bros.', '1993-05-28', 'Action', 'PG', 20844907, 42445058),
('Guilty as Sin', '1993-06-04', 'Thriller/Suspense', 'R', 22622537, 46064723),
('Life With Mikey', '1993-06-04', 'Comedy', 'PG', 12349549, 25146538),
('What\'s Love Got to Do With It', '1993-06-09', 'Drama', 'R', 39100956, 79618610),
('Son in Law', '1993-07-02', 'Comedy', 'PG-13', 25989889, 52921433),
('Hocus Pocus', '1993-07-16', 'Comedy', 'PG', 39360491, 80147079),
('Another Stakeout', '1993-07-23', 'Comedy', 'PG-13', 20107504, 40943541),
('My Boyfriend\'s Back', '1993-08-06', NULL, 'PG-13', 3218882, 6554384),
('Father Hood', '1993-08-27', NULL, 'PG-13', 3268203, 6654819),
('The Joy Luck Club', '1993-09-08', 'Drama', 'R', 32790064, 66768171),
('Money for Nothing', '1993-09-10', 'Comedy', 'R', 1044824, 2127496),
('The Program', '1993-09-24', 'Action', 'R', 23042200, 46919256),
('Cool Runnings', '1993-10-01', 'Comedy', 'PG', 68856263, 140392731),
('The Nightmare Before Christmas', '1993-10-13', 'Musical', 'PG', 50408318, 100026637),
('The Three Musketeers', '1993-11-12', 'Adventure', 'PG', 53661805, 109310377),
('Sister Act 2 Back in the Habit', '1993-12-10', 'Comedy', 'PG', 57319029, 116965668),
('Tombstone', '1993-12-25', 'Western', 'R', 56505065, 115781734),
('The Air Up There', '1994-01-07', 'Comedy', 'PG', 20782439, 42940186),
('Cabin Boy', '1994-01-07', 'Comedy', 'PG-13', 3469493, 7168577),
('Iron Will', '1994-01-14', 'Drama', 'PG', 20623071, 42610902),
('Red Rock West', '1994-01-28', NULL, 'R', 2502551, 5170709),
('Blank Check', '1994-02-11', 'Comedy', 'PG', 30573770, 63170804),
('Angie', '1994-03-04', 'Comedy', 'R', 9252349, 19116981),
('The Ref', '1994-03-09', 'Comedy', 'R', 11325885, 23401275),
('D2: The Mighty Ducks', '1994-03-25', 'Comedy', 'PG', 45604206, 94226333),
('Holy Matrimony', '1994-04-08', 'Comedy', NULL, 713234, 1473665),
('White Fang 2: Myth of the White Wolf', '1994-04-15', 'Adventure', 'PG', 8752399, 18083994),
('The Inkwell', '1994-04-22', 'Comedy', 'R', 8864699, 18316030),
('When a Man Loves a Woman', '1994-04-29', 'Drama', 'R', 50021959, 103354194),
('3 Ninjas Kick Back', '1994-05-06', 'Action', 'PG', 11744960, 24267154),
('Renaissance Man', '1994-06-03', 'Comedy', 'PG-13', 24172899, 49945474),
('The Lion King', '1994-06-15', 'Adventure', 'G', 422780140, 761640898),
('I Love Trouble', '1994-06-29', 'Romantic Comedy', 'PG', 30806194, 63651027),
('Angels in the Outfield', '1994-07-15', 'Comedy', 'PG', 50236831, 103798152),
('In the Army Now', '1994-08-12', 'Comedy', 'PG', 28881266, 59673787),
('Color of Night', '1994-08-19', 'Thriller/Suspense', 'R', 19750470, 40804816),
('Camp Nowhere', '1994-08-26', 'Comedy', 'PG', 10442641, 21576332),
('It\'s Pat', '1994-08-26', 'Comedy', NULL, 60822, 125666),
('A Simple Twist of Fate', '1994-09-02', 'Drama', 'PG-13', 3404935, 7035189),
('Quiz Show', '1994-09-14', 'Drama', 'PG-13', 24787282, 50840394),
('Terminal Velocity', '1994-09-23', 'Action', 'PG-13', 16478900, 34048315),
('Ed Wood', '1994-09-30', 'Comedy', 'R', 5828466, 12042634),
('The Puppet Masters', '1994-10-21', 'Horror', 'R', 8579626, 17727017),
('Squanto: A Warrior\'s Tale', '1994-10-28', 'Drama', 'PG', 3319344, 6858345),
('The Santa Clause', '1994-11-11', 'Comedy', 'PG', 144833357, 298369717),
('A Low Down Dirty Shame', '1994-11-23', 'Action', 'R', 29317886, 60321919),
('The Jungle Book', '1994-12-25', 'Adventure', 'PG', 44342956, 88930321),
('Houseguest', '1995-01-06', 'Comedy', 'PG', 26325256, 51016522),
('Bad Company', '1995-01-20', 'Thriller/Suspense', 'R', 3523909, 6829092),
('Miami Rhapsody', '1995-01-27