UPDATE gamemetadata SET genre = 'Action, Simulation', year = '1991', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Ace of Aces' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1986', publisher = 'SEGA Corporation' WHERE gamename = 'Action Fighter' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Addams Family, The' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'SEGA Corporation' WHERE gamename = 'Aerial Assault' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'SEGA of America, Inc.' WHERE gamename = 'After Burner' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Sega of Europe' WHERE gamename = 'Air Rescue' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Aladdin' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Shooter', year = '1988', publisher = '' WHERE gamename = 'Aleste' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Sega of America, Inc.' WHERE gamename = 'Alex Kidd - The Lost Stars' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Racing/Driving, Sports', year = '1987', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Alex Kidd BMX Trial' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1989', publisher = 'SEGA Corporation' WHERE gamename = 'Alex Kidd in High Tech World' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1986', publisher = 'SEGA Corporation' WHERE gamename = 'Alex Kidd in Miracle World' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'SEGA Corporation' WHERE gamename = 'Alex Kidd in Shinobi World' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1989', publisher = 'SEGA Corporation' WHERE gamename = 'ALF' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Alien 3' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Alien Storm' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'Alien Syndrome' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'SEGA of America, Inc.' WHERE gamename = 'Altered Beast' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1989', publisher = '' WHERE gamename = 'American Baseball' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1989', publisher = '' WHERE gamename = 'American Pro Football' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Lance Investments' WHERE gamename = 'Andre Agassi Tennis' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Misc.', year = '1992', publisher = 'Virgin Interactive Entertainment' WHERE gamename = 'Arcade Smash Hits' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Shooter', year = '1990', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Assault City - Light Phaser Version' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Assault City - Pad Version' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Asterix' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'SEGA Europe Ltd., Tec Toy Indústria de Brinquedos S.A.' WHERE gamename = 'Asterix and the Great Rescue' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = '' WHERE gamename = 'Asterix and the Secret Mission' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1986', publisher = 'SEGA Corporation' WHERE gamename = 'Astro Warrior' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Misc.', year = '1987', publisher = 'Sega of Europe' WHERE gamename = 'Astro Warrior & Pit Pot' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1987', publisher = 'SEGA Enterprises Ltd., SEGA Corporation' WHERE gamename = 'Aztec Adventure - The Golden Road to Paradise' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'Image Works, Mirrorsoft Ltd.' WHERE gamename = 'Back to the Future 2' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Image Works' WHERE gamename = 'Back to the Future 3' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Strategy', year = '1998', publisher = 'Tec Toy Indústria de Brinquedos S.A.' WHERE gamename = 'Baku Baku Animals' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1987', publisher = 'Sega of Europe' WHERE gamename = 'Bank Panic' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Flying Edge, Inc., Tec Toy Indústria de Brinquedos S.A.' WHERE gamename = 'Bart vs. the Space Mutants' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = '' WHERE gamename = 'Bart vs. the World' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1989', publisher = '' WHERE gamename = 'Basket Ball Nightmare' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Adventure', year = '1992', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Batman Returns' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1989', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Battle Out Run' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1986', publisher = 'SEGA Corporation' WHERE gamename = 'Black Belt' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1988', publisher = 'SEGA Corporation' WHERE gamename = 'Blade Eagle 3D' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'Activision, Inc., SEGA Enterprises Ltd.' WHERE gamename = 'Bomber Raid' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Bonanza Bros' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action Adventure', year = '1994', publisher = '' WHERE gamename = 'Bonkers Wax Up!' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = '' WHERE gamename = 'Borgman' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Psygnosis Limited, Sony Imagesoft' WHERE gamename = 'Bram Stoker\'s Dracula' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'SEGA Corporation' WHERE gamename = 'Bubble Bobble' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Racing', year = '1994', publisher = '' WHERE gamename = 'Buggy Run' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1989', publisher = 'Sega of America, Inc.' WHERE gamename = 'California Games' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'SEGA Corporation' WHERE gamename = 'California Games 2' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'SEGA Corporation' WHERE gamename = 'Captain Silver' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1989', publisher = 'Sega of America, Inc.' WHERE gamename = 'Casino Games' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = '' WHERE gamename = 'Champions of Europe' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'Championship Hockey' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = '' WHERE gamename = 'Cheese Cat-astrophe' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1986', publisher = 'SEGA Corporation, SEGA of America, Inc.' WHERE gamename = 'Choplifter' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Virgin Games, Inc.' WHERE gamename = 'Chuck Rock' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = '' WHERE gamename = 'Chuck Rock 2' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Sega of America, Inc.' WHERE gamename = 'Cloud Master' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Strategy', year = '1990', publisher = 'SEGA Enterprises Ltd., Tec Toy Indústria de Brinquedos S.A.' WHERE gamename = 'Columns' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Virgin Games, Ltd.' WHERE gamename = 'Cool Spot' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1993', publisher = '' WHERE gamename = 'Cosmic Spacehead' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'Sega of Europe' WHERE gamename = 'Cyber Shinobi' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'Activision, Inc.' WHERE gamename = 'Cyborg Hunter' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = '' WHERE gamename = 'Daffy Duck in Hollywood' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'SEGA Corporation' WHERE gamename = 'Danan the Jungle Fighter' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'SEGA Corporation' WHERE gamename = 'Dead Angle' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = '' WHERE gamename = 'Deep Duck Trouble' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = '' WHERE gamename = 'Desert Speedtrap' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Shooter', year = '1993', publisher = '' WHERE gamename = 'Desert Strike' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Sega of America, Inc.' WHERE gamename = 'Dick Tracy' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'Sega of America, Inc.' WHERE gamename = 'Double Dragon' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'SEGA Corporation' WHERE gamename = 'Double Hawk' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Strategy', year = '1994', publisher = 'SEGA Corporation' WHERE gamename = 'Dr. Robotnik\'s Mean Bean Machine' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Dragon - The Bruce Lee Story' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'RPG', year = '1990', publisher = 'SEGA Corporation' WHERE gamename = 'Dragon Crystal' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'SEGA Corporation' WHERE gamename = 'Dynamite Duke' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1989', publisher = 'Sega of Europe' WHERE gamename = 'Dynamite Dux' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = '' WHERE gamename = 'E-SWAT - City Under Siege' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'SEGA Corporation' WHERE gamename = 'Ecco the Dolphin' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Racing/Driving, Sports', year = '1987', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Enduro Racer' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Simulator', year = '1986', publisher = 'Sega of America, Inc.' WHERE gamename = 'F-16 Fighting Falcon' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Diving/Racing', year = '1995', publisher = '' WHERE gamename = 'F1 Championship' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1986', publisher = 'SEGA Corporation' WHERE gamename = 'Fantasy Zone' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'SEGA Corporation' WHERE gamename = 'Fantasy Zone 2 - The Tears of Opa-Opa' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'SEGA Corporation' WHERE gamename = 'Fantasy Zone 3 - The Maze' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Racing', year = '1991', publisher = 'Sega of Europe' WHERE gamename = 'Fire & Forget 2' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Sega of Europe' WHERE gamename = 'Flash, The' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = '' WHERE gamename = 'Flintstones, The' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Capcom Co., Ltd.' WHERE gamename = 'Forgotten Worlds' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'G-Loc Air Battle' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = '' WHERE gamename = 'Gain Ground' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Galactic Protector' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Activision, Inc.' WHERE gamename = 'Galaxy Force' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'SEGA Corporation' WHERE gamename = 'Gangster Town' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'Gauntlet' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Fighting', year = '1992', publisher = 'Flying Edge' WHERE gamename = 'George Foreman\'s KO Boxing' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1986', publisher = 'SEGA Corporation' WHERE gamename = 'Ghost House' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'Sega of America, Inc.' WHERE gamename = 'Ghostbusters' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'SEGA of America, Inc.' WHERE gamename = 'Ghouls \'n Ghosts' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'SEGA Corporation' WHERE gamename = 'Global Defense' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Tec Toy Indústria de Brinquedos S.A., Virgin Games, Inc.' WHERE gamename = 'Global Gladiators' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Sega of America, Inc.' WHERE gamename = 'Golden Axe' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'SEGA Corporation' WHERE gamename = 'Golden Axe Warrior' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = '' WHERE gamename = 'Golf Mania' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1988', publisher = 'SEGA Corporation' WHERE gamename = 'Golvellius - Valley of Doom' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Racing', year = '1993', publisher = '' WHERE gamename = 'GP Rider' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Simulation, Sports', year = '1987', publisher = 'SEGA Corporation' WHERE gamename = 'Great Baseball' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1987', publisher = 'SEGA Corporation' WHERE gamename = 'Great Basketball' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1987', publisher = 'Sega of America, Inc.' WHERE gamename = 'Great Football' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Simulation, Sports', year = '1987', publisher = 'SEGA Corporation' WHERE gamename = 'Great Golf' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1987', publisher = 'Sega of America, Inc.' WHERE gamename = 'Great Ice Hockey' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1987', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'Great Volleyball' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1985', publisher = 'SEGA Corporation' WHERE gamename = 'Hang-On' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Misc.', year = '1986', publisher = 'Sega of America, Inc.' WHERE gamename = 'Hang-On & Safari Hunt' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Fighting', year = '1991', publisher = '' WHERE gamename = 'Heavyweight Champ' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG', year = '1991', publisher = 'Strategic Simulations, Inc.' WHERE gamename = 'Heroes of the Lance' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = '' WHERE gamename = 'Home Alone' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Sony Imagesoft Inc.' WHERE gamename = 'Hook (Proto)' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'Impossible Mission' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Incredible Crash Dummies, The' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Incredible Hulk, The' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'Indiana Jones and the Last Crusade' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Domark Software, Inc.' WHERE gamename = 'James Bond 007 - The Duel' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'James Pond 2 - Codename Robocod' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = 'Sega of America, Inc.' WHERE gamename = 'Joe Montana Football' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = '' WHERE gamename = 'Jungle Book, The' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'SEGA Corporation' WHERE gamename = 'Jurassic Park' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'SEGA Enterprises Ltd., SEGA Corporation' WHERE gamename = 'Kenseiden' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Adventure', year = '1989', publisher = 'Parker Brothers' WHERE gamename = 'King\'s Quest' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1991', publisher = 'Tengen' WHERE gamename = 'Klax' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Krusty\'s Fun House' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'SEGA Corporation' WHERE gamename = 'Kung Fu Kid' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'SEGA Corporation' WHERE gamename = 'Laser Ghost' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Strategy', year = '1991', publisher = 'SEGA Corporation' WHERE gamename = 'Lemmings' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = '' WHERE gamename = 'Line of Fire' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Virgin Interactive Entertainment (Europe) Ltd.' WHERE gamename = 'Lion King, The' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1988', publisher = 'SEGA Corporation' WHERE gamename = 'Lord of the Sword' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'Lucky Dime Caper Starring Donald Duck, The' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Virgin Games, Inc.' WHERE gamename = 'Marble Madness' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'SEGA Corporation' WHERE gamename = 'Master of Darkness' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = '' WHERE gamename = 'Masters of Combat' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1988', publisher = 'SEGA Corporation' WHERE gamename = 'Maze Hunter 3D' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Mercs' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'Michael Jackson\'s Moonwalker' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = '' WHERE gamename = 'Mickey Mouse - Castle of Illusion' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = '' WHERE gamename = 'Mickey Mouse - Land of Illusion' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Mickey Mouse - Legend of Illusion' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1993', publisher = 'Codemasters Software Company Limited, The' WHERE gamename = 'Micro Machines' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action, RPG', year = '1987', publisher = 'SEGA Enterprises Ltd., SEGA Corporation' WHERE gamename = 'Miracle Warriors - Seal of the Dark Lord' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Shooter', year = '1987', publisher = 'SEGA Corporation' WHERE gamename = 'Missile Defense 3D' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Strategy', year = '1987', publisher = 'SEGA Corporation' WHERE gamename = 'Monopoly' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Parker Brothers' WHERE gamename = 'Montezuma\'s Revenge' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Arena Entertainment' WHERE gamename = 'Mortal Kombat' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Mortal Kombat 2' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Tec Toy Indústria de Brinquedos S.A.' WHERE gamename = 'Mortal Kombat 3' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Tengen' WHERE gamename = 'Ms. Pac-man' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1986', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'My Hero' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Taito Corporation' WHERE gamename = 'New Zealand Story, The' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'SEGA Corporation' WHERE gamename = 'Ninja Gaiden' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1986', publisher = 'SEGA Enterprises Ltd., SEGA Corporation' WHERE gamename = 'Ninja, The' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Taito Corporation' WHERE gamename = 'Operation Wolf' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Sega of Europe' WHERE gamename = 'Ottifants, The' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1987', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'OutRun' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1988', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'OutRun 3D' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Tengen' WHERE gamename = 'Pac Mania' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Sega of America, Inc.' WHERE gamename = 'Paperboy' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1987', publisher = 'SEGA Corporation, SEGA Entertainment, Inc.' WHERE gamename = 'Parlour Games' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Adventure', year = '1987', publisher = 'SEGA Corporation' WHERE gamename = 'Penguin Land' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Tengen' WHERE gamename = 'PGA Tour Golf' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1987', publisher = 'SEGA Enterprises Ltd., SEGA Corporation, SEGA of America, Inc., Tec Toy Indústria de Brinquedos S.A.' WHERE gamename = 'Phantasy Star' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Fighting', year = '1991', publisher = 'Domark Software Ltd.' WHERE gamename = 'Pit Fighter' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Strategy', year = '1991', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Populous' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1989', publisher = 'SEGA Enterprises Ltd., SEGA Corporation' WHERE gamename = 'Poseidon Wars 3D' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'SEGA Corporation' WHERE gamename = 'Power Strike' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'SEGA Corporation' WHERE gamename = 'Power Strike 2' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Predator 2' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Fighting', year = '1986', publisher = 'Sega of America, Inc.' WHERE gamename = 'Pro Wrestling' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Adventure', year = '1991', publisher = 'SEGA Corporation' WHERE gamename = 'Psychic World' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'SEGA Corporation' WHERE gamename = 'Psycho Fox' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Putt & Putter' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'SEGA of America, Inc.' WHERE gamename = 'Quartet' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'SEGA of America, Inc.' WHERE gamename = 'R-Type' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1989', publisher = 'Seismic Software Inc.' WHERE gamename = 'R.C. Grand Prix' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'SEGA of America, Inc.' WHERE gamename = 'Rainbow Islands' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1986', publisher = 'SEGA Corporation' WHERE gamename = 'Rambo - First Blood Part 2' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Shooter', year = '1988', publisher = 'Sega of America, Inc.' WHERE gamename = 'Rambo 3' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1988', publisher = 'Activision, Inc.' WHERE gamename = 'Rampage' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1993', publisher = 'Tengen' WHERE gamename = 'Rampart' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'Sega of America, Inc.' WHERE gamename = 'Rastan' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1988', publisher = 'Sega of America, Inc.' WHERE gamename = 'Reggie Jackson Baseball' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = '' WHERE gamename = 'Ren & Stimpy - Quest for the Shaven Yak, The' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'SEGA Corporation' WHERE gamename = 'Renegade' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'SEGA Corporation' WHERE gamename = 'Rescue Mission' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving, Simulation', year = '1994', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'Road Rash' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Robocop 3' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Virgin Games, Ltd.' WHERE gamename = 'Robocop vs. Terminator' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Fighting', year = '1987', publisher = 'Sega of America, Inc.' WHERE gamename = 'Rocky' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Sega of Europe' WHERE gamename = 'Running Battle' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Taito Corporation, Tec Toy Indústria de Brinquedos S.A.' WHERE gamename = 'Sagaia' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'SEGA Corporation' WHERE gamename = 'Scramble Spirits' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = '' WHERE gamename = 'SDI' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1986', publisher = 'SEGA Corporation' WHERE gamename = 'Secret Commando' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1991', publisher = '' WHERE gamename = 'Sega Chess' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = '' WHERE gamename = 'Sega World Tournament Golf' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = '' WHERE gamename = 'Sensible Soccer' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'SEGA Corporation' WHERE gamename = 'Shadow Dancer' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Psygnosis Limited' WHERE gamename = 'Shadow of the Beast' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1988', publisher = 'Sega of America, Inc.' WHERE gamename = 'Shanghai' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'Sega of America, Inc.' WHERE gamename = 'Shinobi' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'Shooting Gallery' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = 'Sega of America, Inc.' WHERE gamename = 'Slap Shot' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Smash TV' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = '' WHERE gamename = 'Smurfs 2, The (Smurfs Travel the World)' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1996', publisher = 'Infogrames' WHERE gamename = 'Smurfs, The' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Sega of Europe' WHERE gamename = 'Sonic Chaos' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1994', publisher = 'Sega of Europe' WHERE gamename = 'Sonic Spinball' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'SEGA of America, Inc., Tec Toy S.A.' WHERE gamename = 'Sonic the Hedgehog' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'SEGA Corporation' WHERE gamename = 'Sonic the Hedgehog 2' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1986', publisher = 'SEGA of America, Inc.' WHERE gamename = 'Space Harrier' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Shooter', year = '1988', publisher = 'SEGA Corporation' WHERE gamename = 'Space Harrier 3D' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Taito Corporation' WHERE gamename = 'Spacegun' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1992', publisher = 'SEGA Enterprises Ltd., Taito Corporation' WHERE gamename = 'Special Criminal Investigation' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1992', publisher = '' WHERE gamename = 'Speedball (Mirrorsoft)' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1992', publisher = 'Virgin Games, Inc.' WHERE gamename = 'Speedball (Virgin)' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Sega of Europe' WHERE gamename = 'Speedball 2' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1989', publisher = 'SEGA Corporation' WHERE gamename = 'Spellcaster' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Flying Edge, Inc.' WHERE gamename = 'Spider-Man - Return of the Sinister Six' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'Spider-Man vs. the Kingpin' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1986', publisher = 'SEGA Corporation' WHERE gamename = 'Spy vs. Spy' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'Star Wars' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Streets of Rage' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Streets of Rage 2' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'SEGA Corporation' WHERE gamename = 'Strider' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'Strider 2' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Shooter', year = '1993', publisher = 'Sega of Europe' WHERE gamename = 'Submarine Attack' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1988', publisher = 'SEGA Corporation' WHERE gamename = 'Summer Games' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'Super Kick Off' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1990', publisher = 'SEGA Corporation' WHERE gamename = 'Super Monaco GP' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1992', publisher = '' WHERE gamename = 'Super Monaco GP 2' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Racing', year = '1993', publisher = '' WHERE gamename = 'Super Off-Road' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1988', publisher = '' WHERE gamename = 'Super Racing' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Domark Software, Ltd' WHERE gamename = 'Super Space Invaders' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1986', publisher = 'Sega of America, Inc.' WHERE gamename = 'Super Tennis' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1986', publisher = '' WHERE gamename = 'Super Tetris' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = '' WHERE gamename = 'Superman' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Taz-Mania' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1986', publisher = 'SEGA Corporation' WHERE gamename = 'Teddy Boy' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1989', publisher = 'SEGA Corporation' WHERE gamename = 'Tennis Ace' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Terminator 2 - Judgment Day' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Terminator 2 - The Arcade Game' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Virgin Games, Ltd.' WHERE gamename = 'Terminator, The' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'Sega of America, Inc.' WHERE gamename = 'Thunder Blade' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Sega of America, Inc.' WHERE gamename = 'Time Soldiers' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = '' WHERE gamename = 'Tom and Jerry' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = '' WHERE gamename = 'Tom and Jerry - The Movie' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1986', publisher = 'SEGA Corporation' WHERE gamename = 'Trans-Bot' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Shooter', year = '1986', publisher = 'Sega of America, Inc.' WHERE gamename = 'Trap Shooting - Marksman Shooting - Safari Hunt' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1993', publisher = '' WHERE gamename = 'Trivial Pursuit' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1990', publisher = 'SEGA Corporation' WHERE gamename = 'Ultima 4 - Quest of the Avatar' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Ultimate Soccer' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = '' WHERE gamename = 'Vampire' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'SEGA Corporation' WHERE gamename = 'Vigilante' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'SEGA of America, Inc.' WHERE gamename = 'Wanted' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Educational', year = '1989', publisher = 'Parker Brothers, Tec Toy Indústria de Brinquedos S.A.' WHERE gamename = 'Where in the World is Carmen Sandiego' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Sega of Europe' WHERE gamename = 'Wimbledon' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = '' WHERE gamename = 'Wimbledon 2' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'Winter Olympics \'94' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Virgin Games, Inc.' WHERE gamename = 'Wolf Child' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'SEGA Corporation' WHERE gamename = 'Wonder Boy' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'SEGA Corporation' WHERE gamename = 'Wonder Boy 2 - Wonderboy in Monsterland' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1989', publisher = 'SEGA Corporation' WHERE gamename = 'Wonder Boy 3 - The Dragon\'s Trap' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'RPG', year = '1991', publisher = 'SEGA Corporation' WHERE gamename = 'Wonder Boy 5 - Wonder Boy in Monster World' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'World Class Leaderboard' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = '' WHERE gamename = 'World Cup \'92 by Tecmo' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1994', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'World Cup \'94' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = 'Sega of Europe' WHERE gamename = 'World Cup Italia \'90' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1989', publisher = 'SEGA Corporation' WHERE gamename = 'World Games' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1986', publisher = 'SEGA Enterprises Ltd., SEGA Corporation' WHERE gamename = 'World Grand Prix' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Sports', year = '1987', publisher = 'Sega of Europe' WHERE gamename = 'World Soccer' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1996', publisher = '' WHERE gamename = 'X-Men - Mojo World' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Image Works, Virgin Games, Inc.' WHERE gamename = 'Xenon 2 (Image Works)' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Virgin Interactive Entertainment' WHERE gamename = 'Xenon 2 (Virgin)' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'RPG', year = '1988', publisher = 'Sega of America, Inc.' WHERE gamename = 'Ys - The Vanished Omens' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Shooter', year = '1988', publisher = 'SEGA Corporation' WHERE gamename = 'Zaxxon 3D' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'SEGA Corporation' WHERE gamename = 'Zillion' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1987', publisher = 'Sega of America, Inc.' WHERE gamename = 'Zillion II - The Tri Formation' AND gametype = 'SEGA';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Gremlin Graphics Software Ltd.' WHERE gamename = 'Zool' AND gametype = 'SEGA';