scifi_video_games_practice.sql

-- Sci-fi / video game practice database for MySQL
-- Generated for classroom SQL practice
-- Tables:
--   studios (100 rows)
--   species (120 rows)
--   games (240 rows)
--   characters (260 rows)
--   missions (320 rows)

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE IF EXISTS `missions`;
DROP TABLE IF EXISTS `characters`;
DROP TABLE IF EXISTS `games`;
DROP TABLE IF EXISTS `species`;
DROP TABLE IF EXISTS `studios`;

SET FOREIGN_KEY_CHECKS = 1;

CREATE TABLE `studios` (
    `studio_id` INT PRIMARY KEY,
    `studio_name` VARCHAR(100) NOT NULL,
    `founded_year` YEAR NOT NULL,
    `country` VARCHAR(60) NOT NULL,
    `headquarters_city` VARCHAR(60) NOT NULL,
    `employee_count` INT NOT NULL,
    UNIQUE KEY `uk_studio_name` (`studio_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `species` (
    `species_id` INT PRIMARY KEY,
    `species_name` VARCHAR(100) NOT NULL,
    `homeworld` VARCHAR(100) NOT NULL,
    `biology_type` VARCHAR(50) NOT NULL,
    `average_lifespan` INT NOT NULL,
    `signature_ability` VARCHAR(100) NOT NULL,
    UNIQUE KEY `uk_species_name` (`species_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `games` (
    `game_id` INT PRIMARY KEY,
    `title` VARCHAR(150) NOT NULL,
    `studio_id` INT NOT NULL,
    `release_year` YEAR NOT NULL,
    `genre` VARCHAR(50) NOT NULL,
    `platforms` VARCHAR(80) NOT NULL,
    `base_price` DECIMAL(6,2) NOT NULL,
    `metacritic_score` INT NOT NULL,
    CONSTRAINT `fk_games_studio`
        FOREIGN KEY (`studio_id`) REFERENCES `studios` (`studio_id`)
        ON UPDATE CASCADE ON DELETE RESTRICT,
    INDEX `idx_games_studio_id` (`studio_id`),
    INDEX `idx_games_release_year` (`release_year`),
    INDEX `idx_games_genre` (`genre`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `characters` (
    `character_id` INT PRIMARY KEY,
    `character_name` VARCHAR(100) NOT NULL,
    `species_id` INT NOT NULL,
    `first_appearance_game_id` INT NOT NULL,
    `role_title` VARCHAR(60) NOT NULL,
    `faction_name` VARCHAR(80) NOT NULL,
    `is_playable` TINYINT(1) NOT NULL,
    `power_rating` INT NOT NULL,
    CONSTRAINT `fk_characters_species`
        FOREIGN KEY (`species_id`) REFERENCES `species` (`species_id`)
        ON UPDATE CASCADE ON DELETE RESTRICT,
    CONSTRAINT `fk_characters_first_game`
        FOREIGN KEY (`first_appearance_game_id`) REFERENCES `games` (`game_id`)
        ON UPDATE CASCADE ON DELETE RESTRICT,
    INDEX `idx_characters_species_id` (`species_id`),
    INDEX `idx_characters_first_appearance_game_id` (`first_appearance_game_id`),
    INDEX `idx_characters_faction_name` (`faction_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `missions` (
    `mission_id` INT PRIMARY KEY,
    `game_id` INT NOT NULL,
    `mission_title` VARCHAR(150) NOT NULL,
    `quest_giver_character_id` INT NOT NULL,
    `mission_type` VARCHAR(40) NOT NULL,
    `difficulty` VARCHAR(20) NOT NULL,
    `reward_credits` INT NOT NULL,
    `is_main_story` TINYINT(1) NOT NULL,
    CONSTRAINT `fk_missions_game`
        FOREIGN KEY (`game_id`) REFERENCES `games` (`game_id`)
        ON UPDATE CASCADE ON DELETE RESTRICT,
    CONSTRAINT `fk_missions_character`
        FOREIGN KEY (`quest_giver_character_id`) REFERENCES `characters` (`character_id`)
        ON UPDATE CASCADE ON DELETE RESTRICT,
    INDEX `idx_missions_game_id` (`game_id`),
    INDEX `idx_missions_quest_giver` (`quest_giver_character_id`),
    INDEX `idx_missions_difficulty` (`difficulty`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `studios` (`studio_id`, `studio_name`, `founded_year`, `country`, `headquarters_city`, `employee_count`) VALUES
(1, 'Comet Interactive', 1986, 'Czech Republic', 'Stockholm', 939),
(2, 'Void Interactive', 2019, 'Canada', 'Cape Town', 1753),
(3, 'Quantum Forge', 1990, 'Sweden', 'Stockholm', 2094),
(4, 'Lunar Forge', 2020, 'Sweden', 'Brisbane', 1743),
(5, 'Crimson Entertainment', 2022, 'Czech Republic', 'Warsaw', 678),
(6, 'Rogue Foundry', 2006, 'Czech Republic', 'Seoul', 906),
(7, 'Crystal Assembly', 1991, 'Canada', 'Osaka', 421),
(8, 'Nova Core', 2023, 'Czech Republic', 'Seattle', 1906),
(9, 'Binary Interactive', 2009, 'Canada', 'Brisbane', 1225),
(10, 'Comet Factory', 2008, 'Sweden', 'Montreal', 212),
(11, 'Aether Games', 2003, 'Canada', 'Stockholm', 438),
(12, 'Titan Systems', 2014, 'Singapore', 'Berlin', 1541),
(13, 'Nova Collective', 2002, 'Canada', 'Buenos Aires', 725),
(14, 'Binary Games', 1995, 'South Africa', 'Osaka', 1130),
(15, 'Comet Guild', 1999, 'Australia', 'Seattle', 963),
(16, 'Quantum Assembly', 2010, 'Czech Republic', 'Montreal', 889),
(17, 'Cipher Assembly', 1998, 'Estonia', 'Osaka', 1904),
(18, 'Void Systems', 1993, 'Finland', 'Brisbane', 2232),
(19, 'Stellar Soft', 2012, 'Portugal', 'Dublin', 923),
(20, 'Void Circuit', 2016, 'Canada', 'Seattle', 474),
(21, 'Void Dynamics', 2012, 'Canada', 'Osaka', 1588),
(22, 'Lunar Entertainment', 2018, 'Czech Republic', 'Brisbane', 72),
(23, 'Aether Interactive', 2019, 'Czech Republic', 'Prague', 481),
(24, 'Eclipse Foundry', 1995, 'South Africa', 'Warsaw', 1103),
(25, 'Vector Dynamics', 2017, 'Japan', 'Toronto', 2104),
(26, 'Lunar Collective', 1994, 'Singapore', 'Berlin', 2234),
(27, 'Crystal Circuit', 1985, 'Australia', 'Lisbon', 104),
(28, 'Solar Core', 2004, 'Finland', 'Seattle', 1011),
(29, 'Cipher Labs', 1990, 'Estonia', 'Montreal', 2206),
(30, 'Crystal Studios', 1993, 'Estonia', 'Brisbane', 701),
(31, 'Stellar Circuit', 2023, 'Argentina', 'Austin', 2233),
(32, 'Crystal Collective', 2004, 'Portugal', 'Dublin', 1819),
(33, 'Vector Entertainment', 1992, 'Finland', 'Stockholm', 287),
(34, 'Omega Forge', 2022, 'Finland', 'Cape Town', 927),
(35, 'Nebula Labs', 2025, 'USA', 'Stockholm', 301),
(36, 'Iron Circuit', 2000, 'Czech Republic', 'Lisbon', 902),
(37, 'Binary Studios', 2021, 'Estonia', 'Stockholm', 1962),
(38, 'Arc Collective', 1991, 'Japan', 'Helsinki', 1476),
(39, 'Arc Foundry', 2014, 'USA', 'Tokyo', 273),
(40, 'Titan Assembly', 1991, 'Finland', 'Austin', 804),
(41, 'Binary Entertainment', 1993, 'Argentina', 'Berlin', 1165),
(42, 'Ghost Games', 1989, 'South Africa', 'Brisbane', 426),
(43, 'Quantum Guild', 1985, 'Canada', 'Stockholm', 706),
(44, 'Arc Division', 2015, 'Sweden', 'Osaka', 265),
(45, 'Pixel Productions', 1985, 'Portugal', 'Reykjavik', 1888),
(46, 'Rogue Guild', 2016, 'South Korea', 'Austin', 1240),
(47, 'Hyper Works', 2022, 'USA', 'Prague', 259),
(48, 'Quantum Soft', 2015, 'Germany', 'Seattle', 2105),
(49, 'Iron Dynamics', 1989, 'Canada', 'Stockholm', 1678),
(50, 'Solar Soft', 2000, 'USA', 'Buenos Aires', 360),
(51, 'Arc Soft', 2021, 'Australia', 'Reykjavik', 861),
(52, 'Aether Assembly', 2000, 'Czech Republic', 'Osaka', 561),
(53, 'Aether Dreams', 2014, 'Australia', 'Montreal', 63),
(54, 'Ghost Factory', 2021, 'Japan', 'Montreal', 2227),
(55, 'Hyper Circuit', 2001, 'South Korea', 'Dublin', 306),
(56, 'Crimson Core', 2003, 'Germany', 'Tallinn', 2250),
(57, 'Rogue Dreams', 2024, 'Poland', 'Brisbane', 1251),
(58, 'Solar Interactive', 2020, 'South Korea', 'Reykjavik', 1179),
(59, 'Rogue Assembly', 1998, 'Czech Republic', 'Singapore', 2026),
(60, 'Stellar Works', 1990, 'Argentina', 'Reykjavik', 205),
(61, 'Nebula Assembly', 1993, 'Czech Republic', 'Berlin', 1834),
(62, 'Binary Foundry', 2020, 'Poland', 'Tokyo', 333),
(63, 'Rogue Studios', 2019, 'USA', 'Dublin', 2288),
(64, 'Void Foundry', 1993, 'USA', 'Toronto', 1518),
(65, 'Quantum Core', 1998, 'Finland', 'Tokyo', 1473),
(66, 'Crystal Guild', 2011, 'South Korea', 'Stockholm', 690),
(67, 'Pixel Foundry', 1986, 'Germany', 'Prague', 1711),
(68, 'Stellar Dynamics', 1991, 'Portugal', 'Seattle', 1952),
(69, 'Crimson Collective', 2014, 'Singapore', 'Toronto', 957),
(70, 'Crimson Forge', 1997, 'Portugal', 'Prague', 1166),
(71, 'Iron Systems', 2007, 'Portugal', 'Brisbane', 1381),
(72, 'Nebula Interactive', 2001, 'Germany', 'Cape Town', 1112),
(73, 'Quantum Interactive', 2023, 'Argentina', 'Dublin', 1309),
(74, 'Arc Factory', 2017, 'Japan', 'Osaka', 2386),
(75, 'Hyper Systems', 1987, 'Argentina', 'Warsaw', 2154),
(76, 'Binary Collective', 2008, 'Argentina', 'Montreal', 1377),
(77, 'Lunar Assembly', 1992, 'Ireland', 'Singapore', 1291),
(78, 'Aether Foundry', 2005, 'Portugal', 'Toronto', 2295),
(79, 'Void Collective', 2011, 'Portugal', 'Berlin', 2356),
(80, 'Eclipse Productions', 2020, 'Poland', 'Toronto', 1200),
(81, 'Hyper Foundry', 2022, 'Australia', 'Tallinn', 1834),
(82, 'Ghost Collective', 2017, 'Estonia', 'Berlin', 372),
(83, 'Eclipse Circuit', 2025, 'Australia', 'Montreal', 987),
(84, 'Void Forge', 1987, 'Finland', 'Lisbon', 323),
(85, 'Ghost Foundry', 2025, 'Sweden', 'Osaka', 2049),
(86, 'Titan Games', 1994, 'Poland', 'Tokyo', 1766),
(87, 'Crimson Dynamics', 2018, 'South Africa', 'Seattle', 2308),
(88, 'Crimson Interactive', 2014, 'South Korea', 'Tallinn', 2200),
(89, 'Binary Factory', 2005, 'South Africa', 'Buenos Aires', 2092),
(90, 'Arc Guild', 2013, 'Germany', 'Lisbon', 1868),
(91, 'Stellar Games', 2025, 'Czech Republic', 'Singapore', 2009),
(92, 'Comet Games', 2002, 'South Africa', 'Montreal', 1195),
(93, 'Crimson Systems', 2006, 'Australia', 'Brisbane', 355),
(94, 'Void Studios', 1999, 'Portugal', 'Seoul', 901),
(95, 'Iron Foundry', 2011, 'Australia', 'Brisbane', 1933),
(96, 'Arc Works', 1998, 'Argentina', 'Osaka', 105),
(97, 'Crystal Soft', 2009, 'Estonia', 'Warsaw', 1465),
(98, 'Mythic Guild', 2023, 'Finland', 'Lisbon', 923),
(99, 'Stellar Foundry', 2016, 'Poland', 'Osaka', 1401),
(100, 'Aether Productions', 1995, 'South Africa', 'Seoul', 2212);

INSERT INTO `species` (`species_id`, `species_name`, `homeworld`, `biology_type`, `average_lifespan`, `signature_ability`) VALUES
(1, 'Ashen Reavers', 'Arcadia-10', 'mammalian', 47, 'cloak generation'),
(2, 'Solar Krell', 'Oberon-3', 'organic', 286, 'phase shifting'),
(3, 'Storm Wardens', 'Oberon-6', 'avian', 799, 'phase shifting'),
(4, 'Frozen Weavers', 'Orpheon-2', 'energy-based', 39, 'terraform adaptation'),
(5, 'Deep Nomads', 'Morrow-4', 'mammalian', 90, 'psionic shielding'),
(6, 'Crystal Drifters', 'Rime-4', 'organic', 656, 'radiation resistance'),
(7, 'Radiant Krell', 'Ymir-11', 'cybernetic', 597, 'rapid regeneration'),
(8, 'Obsidian Leviathans', 'Morrow-3', 'hive-mind', 641, 'terraform adaptation'),
(9, 'Iron Oracles', 'Duskfall-2', 'hive-mind', 46, 'gravity sensing'),
(10, 'Titan Reavers', 'Nadir-12', 'fungal', 97, 'bio-luminescence'),
(11, 'Radiant Minders', 'Duskfall-11', 'hive-mind', 844, 'cloak generation'),
(12, 'Titan Nomads', 'Morrow-9', 'reptilian', 697, 'hive communication'),
(13, 'Void Navigators', 'Caelus-1', 'reptilian', 862, 'nanite repair'),
(14, 'Iron Weavers', 'Morrow-11', 'energy-based', 744, 'radiation resistance'),
(15, 'Solar Oracles', 'Vanguard-11', 'amphibious', 650, 'sonic mapping'),
(16, 'Copper Sentinels', 'Solace-12', 'hive-mind', 294, 'hive communication'),
(17, 'Radiant Synths', 'Orpheon-8', 'fungal', 788, 'nanite repair'),
(18, 'Titan Swarmers', 'Nadir-6', 'organic', 526, 'hive communication'),
(19, 'Emerald Morphs', 'Ilyra-6', 'amphibious', 368, 'gravity sensing'),
(20, 'Echo Leviathans', 'Perihelion-1', 'synthetic', 215, 'cloak generation'),
(21, 'Radiant Weavers', 'Ymir-9', 'fungal', 727, 'nanite repair'),
(22, 'Ashen Synths', 'Duskfall-4', 'reptilian', 728, 'rapid regeneration'),
(23, 'Sand Forged', 'Morrow-8', 'synthetic', 563, 'hive communication'),
(24, 'Solar Exiles', 'Caelus-6', 'crystalline', 484, 'gravity sensing'),
(25, 'Sand Leviathans', 'Rime-2', 'crystalline', 217, 'hive communication'),
(26, 'Iron Exiles', 'Nova Prime-4', 'fungal', 776, 'nanite repair'),
(27, 'Frozen Forged', 'Vanguard-10', 'amphibious', 122, 'rapid regeneration'),
(28, 'Sand Mycoids', 'Morrow-3', 'amphibious', 34, 'terraform adaptation'),
(29, 'Deep Krell', 'Orpheon-1', 'organic', 586, 'gravity sensing'),
(30, 'Azure Morphs', 'Kharon-1', 'hive-mind', 311, 'nanite repair'),
(31, 'Storm Oracles', 'Vesper-5', 'energy-based', 136, 'cloak generation'),
(32, 'Shadow Morphs', 'Helion-10', 'mammalian', 722, 'telepathy'),
(33, 'Azure Krell', 'Arcadia-5', 'cybernetic', 274, 'cloak generation'),
(34, 'Deep Weavers', 'Draconis-10', 'hive-mind', 251, 'sonic mapping'),
(35, 'Shadow Sentinels', 'Oberon-5', 'hive-mind', 459, 'gravity sensing'),
(36, 'Crystal Swarmers', 'Kharon-4', 'mammalian', 236, 'gravity sensing'),
(37, 'Void Oracles', 'Rime-3', 'synthetic', 96, 'radiation resistance'),
(38, 'Ashen Weavers', 'Oberon-12', 'hive-mind', 501, 'gravity sensing'),
(39, 'Crystal Mycoids', 'Duskfall-12', 'amphibious', 739, 'nanite repair'),
(40, 'Void Mycoids', 'Orpheon-11', 'hive-mind', 697, 'rapid regeneration'),
(41, 'Solar Minders', 'Perihelion-4', 'mammalian', 172, 'gravity sensing'),
(42, 'Azure Synths', 'Vesper-3', 'amphibious', 629, 'terraform adaptation'),
(43, 'Titan Pilgrims', 'Oberon-2', 'energy-based', 725, 'gravity sensing'),
(44, 'Shadow Leviathans', 'Vanguard-9', 'energy-based', 468, 'cloak generation'),
(45, 'Echo Nomads', 'Solace-12', 'avian', 638, 'gravity sensing'),
(46, 'Radiant Forged', 'Arcadia-1', 'mammalian', 861, 'gravity sensing'),
(47, 'Ivory Sentinels', 'Orpheon-3', 'hive-mind', 466, 'psionic shielding'),
(48, 'Copper Synths', 'Ymir-6', 'reptilian', 361, 'hive communication'),
(49, 'Storm Weavers', 'Ymir-5', 'mammalian', 430, 'sonic mapping'),
(50, 'Crystal Sentinels', 'Helion-6', 'amphibious', 351, 'cloak generation'),
(51, 'Shadow Navigators', 'Astra IX-11', 'synthetic', 493, 'phase shifting'),
(52, 'Crystal Wardens', 'Vanguard-6', 'hive-mind', 794, 'nanite repair'),
(53, 'Obsidian Nomads', 'Ilyra-5', 'synthetic', 154, 'gravity sensing'),
(54, 'Obsidian Morphs', 'Kharon-1', 'mammalian', 643, 'rapid regeneration'),
(55, 'Emerald Pilgrims', 'Perihelion-1', 'synthetic', 437, 'cloak generation'),
(56, 'Obsidian Minders', 'Tethys-8', 'crystalline', 318, 'sonic mapping'),
(57, 'Copper Morphs', 'Rime-8', 'synthetic', 168, 'phase shifting'),
(58, 'Sable Swarmers', 'Vanguard-12', 'silicon-based', 91, 'gravity sensing'),
(59, 'Solar Striders', 'Vanguard-5', 'organic', 309, 'terraform adaptation'),
(60, 'Titan Morphs', 'Tethys-8', 'synthetic', 515, 'hive communication'),
(61, 'Storm Exiles', 'Perihelion-7', 'energy-based', 349, 'rapid regeneration'),
(62, 'Shadow Mycoids', 'Solace-1', 'avian', 782, 'nanite repair'),
(63, 'Shadow Reavers', 'Tethys-8', 'organic', 149, 'sonic mapping'),
(64, 'Titan Striders', 'Kharon-8', 'cybernetic', 558, 'nanite repair'),
(65, 'Ashen Krell', 'Solace-11', 'silicon-based', 96, 'nanite repair'),
(66, 'Frozen Striders', 'Draconis-12', 'reptilian', 685, 'cloak generation'),
(67, 'Shadow Striders', 'Ymir-9', 'organic', 652, 'cloak generation'),
(68, 'Radiant Pilgrims', 'Rime-12', 'cybernetic', 464, 'cloak generation'),
(69, 'Iron Sentinels', 'Nova Prime-12', 'amphibious', 49, 'telepathy'),
(70, 'Storm Nomads', 'Duskfall-6', 'avian', 461, 'radiation resistance'),
(71, 'Radiant Navigators', 'Solace-10', 'mammalian', 831, 'radiation resistance'),
(72, 'Emerald Oracles', 'Helion-10', 'reptilian', 654, 'psionic shielding'),
(73, 'Radiant Morphs', 'Arcadia-3', 'fungal', 492, 'psionic shielding'),
(74, 'Frozen Sentinels', 'Orpheon-11', 'organic', 843, 'nanite repair'),
(75, 'Sand Exiles', 'Nova Prime-2', 'energy-based', 373, 'bio-luminescence'),
(76, 'Sand Weavers', 'Orpheon-8', 'amphibious', 223, 'phase shifting'),
(77, 'Copper Minders', 'Rime-7', 'hive-mind', 387, 'bio-luminescence'),
(78, 'Sand Pilgrims', 'Astra IX-11', 'reptilian', 301, 'telepathy'),
(79, 'Echo Morphs', 'Duskfall-4', 'hive-mind', 841, 'hive communication'),
(80, 'Radiant Wardens', 'Draconis-5', 'mammalian', 793, 'terraform adaptation'),
(81, 'Azure Minders', 'Vesper-5', 'energy-based', 54, 'bio-luminescence'),
(82, 'Luminous Krell', 'Helion-5', 'avian', 785, 'phase shifting'),
(83, 'Emerald Wardens', 'Tethys-9', 'avian', 563, 'sonic mapping'),
(84, 'Frozen Oracles', 'Orpheon-8', 'amphibious', 784, 'hive communication'),
(85, 'Void Krell', 'Rime-11', 'crystalline', 710, 'phase shifting'),
(86, 'Deep Choristers', 'Helion-7', 'organic', 290, 'sonic mapping'),
(87, 'Luminous Leviathans', 'Arcadia-7', 'mammalian', 400, 'cloak generation'),
(88, 'Ashen Swarmers', 'Perihelion-6', 'hive-mind', 246, 'psionic shielding'),
(89, 'Void Sentinels', 'Duskfall-11', 'reptilian', 139, 'radiation resistance'),
(90, 'Crystal Nomads', 'Duskfall-8', 'cybernetic', 119, 'rapid regeneration'),
(91, 'Luminous Exiles', 'Solace-10', 'crystalline', 764, 'radiation resistance'),
(92, 'Copper Swarmers', 'Solace-5', 'organic', 726, 'hive communication'),
(93, 'Sable Sentinels', 'Oberon-4', 'avian', 121, 'psionic shielding'),
(94, 'Luminous Nomads', 'Nadir-5', 'fungal', 145, 'nanite repair'),
(95, 'Void Wardens', 'Draconis-1', 'organic', 825, 'hive communication'),
(96, 'Titan Wardens', 'Helion-9', 'fungal', 620, 'rapid regeneration'),
(97, 'Radiant Striders', 'Tethys-10', 'organic', 303, 'radiation resistance'),
(98, 'Azure Exiles', 'Orpheon-3', 'cybernetic', 696, 'telepathy'),
(99, 'Azure Drifters', 'Morrow-4', 'hive-mind', 351, 'telepathy'),
(100, 'Emerald Leviathans', 'Vesper-3', 'crystalline', 451, 'sonic mapping'),
(101, 'Iron Synths', 'Ymir-8', 'avian', 545, 'bio-luminescence'),
(102, 'Ivory Mycoids', 'Draconis-1', 'crystalline', 822, 'psionic shielding'),
(103, 'Ivory Pilgrims', 'Oberon-11', 'organic', 82, 'nanite repair'),
(104, 'Shadow Weavers', 'Kharon-8', 'crystalline', 474, 'cloak generation'),
(105, 'Void Striders', 'Draconis-3', 'cybernetic', 149, 'gravity sensing'),
(106, 'Echo Forged', 'Perihelion-12', 'avian', 410, 'bio-luminescence'),
(107, 'Obsidian Navigators', 'Draconis-7', 'cybernetic', 832, 'terraform adaptation'),
(108, 'Sable Weavers', 'Oberon-4', 'reptilian', 367, 'nanite repair'),
(109, 'Iron Striders', 'Solace-6', 'mammalian', 281, 'hive communication'),
(110, 'Void Synths', 'Helion-2', 'reptilian', 118, 'terraform adaptation'),
(111, 'Titan Exiles', 'Perihelion-6', 'mammalian', 145, 'phase shifting'),
(112, 'Luminous Weavers', 'Vesper-5', 'hive-mind', 339, 'hive communication'),
(113, 'Iron Forged', 'Vanguard-4', 'silicon-based', 692, 'nanite repair'),
(114, 'Luminous Minders', 'Orpheon-10', 'fungal', 846, 'phase shifting'),
(115, 'Deep Swarmers', 'Draconis-11', 'mammalian', 590, 'telepathy'),
(116, 'Ashen Oracles', 'Orpheon-12', 'amphibious', 367, 'hive communication'),
(117, 'Azure Forged', 'Nadir-2', 'silicon-based', 778, 'psionic shielding'),
(118, 'Ivory Wardens', 'Nadir-7', 'energy-based', 369, 'radiation resistance'),
(119, 'Luminous Pilgrims', 'Caelus-10', 'hive-mind', 106, 'telepathy'),
(120, 'Azure Oracles', 'Draconis-1', 'mammalian', 103, 'gravity sensing');

INSERT INTO `games` (`game_id`, `title`, `studio_id`, `release_year`, `genre`, `platforms`, `base_price`, `metacritic_score`) VALUES
(1, 'Solar Archive', 54, 2012, 'Shooter', 'PC, PlayStation', 69.99, 84),
(2, 'Galaxy Siege', 87, 2007, 'Roguelike', 'PC, Switch', 49.99, 94),
(3, 'Eclipse Protocol: Ascension', 1, 1999, '4X Strategy', 'PC, Xbox', 24.99, 60),
(4, 'Neon Signal: Origins', 96, 2013, 'Survival', 'PC, PlayStation', 24.99, 76),
(5, 'Crimson Anomaly', 86, 2024, 'Simulation', 'PC', 39.99, 54),
(6, 'Dark Frontier', 41, 2000, 'Roguelike', 'PC, Switch', 49.99, 77),
(7, 'Dark Signal: Origins', 22, 2008, 'Roguelike', 'PC, Switch', 69.99, 96),
(8, 'Orbit Reckoning', 32, 2001, 'Survival', 'Multiplatform', 39.99, 85),
(9, 'Cyber Horizon', 44, 2021, '4X Strategy', 'PC, Xbox', 69.99, 62),
(10, 'Cyber Chronicle', 66, 2014, '4X Strategy', 'PC, Xbox', 29.99, 93),
(11, 'Mech Anomaly: Prime', 23, 2004, 'Roguelike', 'PC, PlayStation', 69.99, 93),
(12, 'Cyber Wars', 64, 2018, 'Adventure', 'Multiplatform', 69.99, 89),
(13, 'Solar Colony', 42, 2017, 'Simulation', 'PC, PlayStation', 39.99, 56),
(14, 'Alien Uprising', 36, 2023, 'Roguelike', 'PC', 29.99, 84),
(15, 'Cyber Signal', 8, 1999, 'Simulation', 'PC, Xbox', 19.99, 93),
(16, 'Cyber Zero', 60, 2010, 'Roguelike', 'Multiplatform', 69.99, 54),
(17, 'Quantum Zero', 8, 2002, 'Adventure', 'PC', 69.99, 73),
(18, 'Void Anomaly', 68, 2012, 'Tactical RPG', 'Multiplatform', 24.99, 75),
(19, 'Orbit Signal', 44, 2022, 'Roguelike', 'PC', 69.99, 92),
(20, 'Quantum Reckoning: Rift', 50, 2019, 'Shooter', 'PC, Xbox', 59.99, 94),
(21, 'Omega Directive: Ascension', 19, 2019, 'Simulation', 'PC, Xbox', 59.99, 96),
(22, 'Hyper Directive', 40, 2000, 'Tactical RPG', 'PC, Switch', 59.99, 73),
(23, 'Mech Chronicle: Infinity', 47, 2014, 'RPG', 'PC, Xbox', 29.99, 63),
(24, 'Nova Expanse', 25, 2013, '4X Strategy', 'PC, PlayStation', 24.99, 56),
(25, 'Eclipse Odyssey', 95, 2015, 'Tactical RPG', 'PC', 59.99, 73),
(26, 'Omega Directive', 21, 2002, 'Strategy', 'PC, PlayStation, Xbox', 69.99, 91),
(27, 'Shadow Uprising: Echoes', 93, 2019, '4X Strategy', 'PC, Switch', 49.99, 70),
(28, 'Solar Anomaly', 61, 2007, '4X Strategy', 'PC, Xbox', 59.99, 88),
(29, 'Solar Uprising', 49, 2022, 'Tactical RPG', 'Multiplatform', 39.99, 62),
(30, 'Nova Zero: Prime', 83, 1999, 'Adventure', 'PC, Xbox', 49.99, 58),
(31, 'Deep Odyssey: Nexus', 58, 2006, 'Tactical RPG', 'PC, PlayStation', 69.99, 79),
(32, 'Cyber Anomaly', 45, 2026, 'RPG', 'PC, Switch', 19.99, 77),
(33, 'Deep Siege: Reborn', 29, 2009, 'RPG', 'PC, Xbox', 19.99, 97),
(34, 'Quantum Directive: Prime', 61, 2024, 'Strategy', 'PC, PlayStation, Xbox', 39.99, 80),
(35, 'Omega Frontier', 33, 1998, '4X Strategy', 'PC, PlayStation', 49.99, 90),
(36, 'Deep Archive: Prime', 39, 2005, 'Action RPG', 'PC', 24.99, 78),
(37, 'Omega Uprising: Awakening', 69, 2017, 'RPG', 'PC, PlayStation, Xbox', 49.99, 88),
(38, 'Titan Directive: Origins', 46, 2017, '4X Strategy', 'Multiplatform', 39.99, 63),
(39, 'Deep Engine: Awakening', 82, 1999, 'Survival', 'PC, Xbox', 29.99, 53),
(40, 'Orbit Reckoning: Reborn', 75, 2022, 'Simulation', 'PC, PlayStation', 19.99, 74),
(41, 'Crimson Expanse', 100, 2003, 'Adventure', 'PC, PlayStation, Xbox', 39.99, 92),
(42, 'Shadow Directive: Awakening', 38, 1999, '4X Strategy', 'PC', 69.99, 64),
(43, 'Void Expanse', 51, 2014, 'Tactical RPG', 'PC, Switch', 29.99, 54),
(44, 'Nova Signal', 7, 2022, 'Simulation', 'PC, Xbox', 19.99, 75),
(45, 'Dark Horizon', 50, 2026, 'Simulation', 'PC, PlayStation', 39.99, 96),
(46, 'Alien Siege', 35, 2014, 'Action RPG', 'PC, PlayStation, Xbox', 39.99, 57),
(47, 'Dark Zero', 70, 2003, 'Shooter', 'PC, Xbox', 19.99, 57),
(48, 'Quantum Signal: Ascension', 55, 2020, 'Strategy', 'PC, PlayStation, Xbox', 39.99, 74),
(49, 'Solar Protocol', 79, 2009, 'Survival', 'PC, Xbox', 59.99, 55),
(50, 'Shadow Frontier: Ascension', 57, 2019, 'RPG', 'PC, PlayStation', 19.99, 67),
(51, 'Orbit Siege', 5, 2016, 'Roguelike', 'PC, PlayStation', 59.99, 80),
(52, 'Cyber Colony: Echoes', 41, 2010, 'Shooter', 'PC, PlayStation', 19.99, 53),
(53, 'Shadow Sector', 16, 2015, 'Shooter', 'PC, Xbox', 59.99, 80),
(54, 'Nova Zero: Awakening', 16, 2004, 'Strategy', 'PC', 39.99, 63),
(55, 'Solar Reckoning', 41, 2025, 'Simulation', 'PC, PlayStation, Xbox', 19.99, 87),
(56, 'Crimson Signal', 21, 2025, 'Strategy', 'PC, Xbox', 49.99, 66),
(57, 'Galaxy Drift', 64, 2005, 'RPG', 'PC, Xbox', 49.99, 88),
(58, 'Orbit Uprising', 17, 2015, 'Roguelike', 'PC', 19.99, 71),
(59, 'Hyper Sector', 53, 2022, 'Roguelike', 'PC', 24.99, 72),
(60, 'Cyber Uprising', 45, 2014, 'Strategy', 'Multiplatform', 59.99, 89),
(61, 'Shadow Directive', 8, 2025, 'Action RPG', 'Multiplatform', 24.99, 71),
(62, 'Shadow Wars: Beyond', 67, 2009, 'Shooter', 'PC', 29.99, 64),
(63, 'Crimson Legion: Prime', 69, 2017, 'Action RPG', 'Multiplatform', 59.99, 62),
(64, 'Iron Colony: Ascension', 78, 2021, 'Simulation', 'Multiplatform', 19.99, 53),
(65, 'Cyber Protocol', 74, 2022, 'Shooter', 'PC, PlayStation, Xbox', 24.99, 88),
(66, 'Alien Engine: Prime', 32, 2013, 'Survival', 'PC, Xbox', 39.99, 56),
(67, 'Void Wars', 60, 2013, '4X Strategy', 'PC, Xbox', 49.99, 61),
(68, 'Quantum Expanse', 45, 2025, 'Survival', 'PC, PlayStation', 69.99, 75),
(69, 'Deep Engine: Beyond', 16, 2012, 'Shooter', 'PC, Switch', 24.99, 61),
(70, 'Galaxy Protocol: Infinity', 79, 2025, 'Survival', 'PC, PlayStation', 69.99, 62),
(71, 'Quantum Colony', 98, 2004, 'Strategy', 'PC, Switch', 49.99, 81),
(72, 'Alien Signal', 51, 2000, 'Tactical RPG', 'PC, Switch', 24.99, 65),
(73, 'Iron Siege: Prime', 77, 2013, 'Adventure', 'PC, Xbox', 49.99, 52),
(74, 'Galaxy Archive: Prime', 47, 2021, 'Survival', 'PC, Xbox', 19.99, 77),
(75, 'Void Colony', 71, 2009, 'Shooter', 'PC', 39.99, 84),
(76, 'Solar Engine: Ascension', 79, 2019, 'Action RPG', 'PC, PlayStation', 19.99, 77),
(77, 'Orbit Expanse', 97, 2009, 'Strategy', 'PC, PlayStation', 49.99, 84),
(78, 'Hyper Chronicle: Origins', 92, 2002, 'Simulation', 'PC, Switch', 49.99, 81),
(79, 'Mech Zero', 42, 2002, 'Roguelike', 'PC, Xbox', 24.99, 77),
(80, 'Omega Signal', 66, 2014, 'Tactical RPG', 'PC, Switch', 59.99, 88),
(81, 'Eclipse Sector', 43, 2009, 'Action RPG', 'PC, Switch', 49.99, 71),
(82, 'Star Zero', 100, 2018, 'Roguelike', 'Multiplatform', 24.99, 55),
(83, 'Iron Sector: Ascension', 49, 2022, 'Strategy', 'PC, PlayStation, Xbox', 24.99, 54),
(84, 'Iron Odyssey: Awakening', 54, 2008, 'Strategy', 'PC, Switch', 59.99, 65),
(85, 'Dark Chronicle', 95, 2013, 'RPG', 'PC, PlayStation, Xbox', 24.99, 85),
(86, 'Nova Engine: Awakening', 49, 2014, 'Simulation', 'PC, PlayStation', 39.99, 86),
(87, 'Quantum Engine', 93, 2022, 'Shooter', 'Multiplatform', 39.99, 64),
(88, 'Titan Legion', 39, 2005, 'Shooter', 'PC, PlayStation, Xbox', 24.99, 96),
(89, 'Alien Expanse', 93, 2015, 'Shooter', 'PC, Xbox', 19.99, 88),
(90, 'Crimson Horizon', 45, 2010, 'Strategy', 'PC, Xbox', 19.99, 70),
(91, 'Cyber Siege', 33, 2018, 'Adventure', 'PC, PlayStation', 24.99, 86),
(92, 'Neon Engine', 14, 2002, 'Roguelike', 'PC, PlayStation, Xbox', 49.99, 67),
(93, 'Titan Protocol', 29, 2014, '4X Strategy', 'PC', 19.99, 78),
(94, 'Quantum Sector: Nexus', 71, 1998, 'Strategy', 'PC, Switch', 59.99, 82),
(95, 'Alien Drift', 42, 2007, 'Shooter', 'PC, PlayStation, Xbox', 19.99, 57),
(96, 'Iron Anomaly', 5, 2021, 'Strategy', 'PC, Switch', 69.99, 63),
(97, 'Void Horizon', 96, 2003, 'Shooter', 'PC', 19.99, 71),
(98, 'Iron Zero: Echoes', 59, 2007, 'Tactical RPG', 'Multiplatform', 39.99, 60),
(99, 'Deep Uprising: Reborn', 21, 2008, 'Adventure', 'PC, PlayStation, Xbox', 29.99, 97),
(100, 'Shadow Frontier', 38, 2023, 'Roguelike', 'PC, PlayStation, Xbox', 69.99, 64),
(101, 'Shadow Zero', 52, 2026, 'Survival', 'Multiplatform', 29.99, 57),
(102, 'Hyper Odyssey: Nexus', 42, 2013, '4X Strategy', 'PC', 29.99, 76),
(103, 'Titan Uprising', 39, 2008, 'Roguelike', 'PC, PlayStation, Xbox', 49.99, 52),
(104, 'Neon Siege', 86, 1999, 'Action RPG', 'PC, Switch', 29.99, 62),
(105, 'Hyper Chronicle', 91, 2026, 'Shooter', 'PC, PlayStation, Xbox', 19.99, 92),
(106, 'Eclipse Siege', 18, 2005, 'Adventure', 'PC, PlayStation', 39.99, 90),
(107, 'Orbit Archive', 97, 2013, 'Tactical RPG', 'PC, PlayStation, Xbox', 69.99, 65),
(108, 'Titan Zero', 68, 2000, 'Adventure', 'Multiplatform', 59.99, 75),
(109, 'Cyber Colony: Rift', 65, 2026, '4X Strategy', 'Multiplatform', 49.99, 61),
(110, 'Shadow Expanse', 15, 2012, '4X Strategy', 'PC, PlayStation, Xbox', 49.99, 83),
(111, 'Void Uprising: Infinity', 73, 2012, 'RPG', 'Multiplatform', 39.99, 95),
(112, 'Eclipse Frontier', 1, 2024, '4X Strategy', 'Multiplatform', 19.99, 54),
(113, 'Dark Siege', 8, 2015, 'Action RPG', 'PC, Switch', 19.99, 70),
(114, 'Dark Wars', 83, 2022, 'Survival', 'PC, Xbox', 39.99, 80),
(115, 'Hyper Horizon: Rift', 84, 2002, 'Simulation', 'PC', 24.99, 86),
(116, 'Hyper Chronicle: Beyond', 1, 2024, 'RPG', 'PC, Xbox', 39.99, 95),
(117, 'Crimson Archive', 30, 2024, '4X Strategy', 'PC, Switch', 29.99, 61),
(118, 'Neon Drift', 98, 2021, 'Action RPG', 'PC', 69.99, 94),
(119, 'Star Anomaly: Reborn', 5, 2017, 'Adventure', 'Multiplatform', 59.99, 97),
(120, 'Hyper Uprising: Beyond', 100, 2022, 'RPG', 'PC, PlayStation', 49.99, 70),
(121, 'Titan Colony: Ascension', 87, 2022, 'Simulation', 'PC, PlayStation', 29.99, 61),
(122, 'Deep Anomaly', 8, 2006, 'Tactical RPG', 'Multiplatform', 59.99, 63),
(123, 'Dark Engine', 83, 2009, 'Survival', 'Multiplatform', 29.99, 96),
(124, 'Dark Archive: Infinity', 97, 2003, 'Tactical RPG', 'PC, Switch', 24.99, 66),
(125, 'Eclipse Directive', 72, 1999, 'Survival', 'PC, Switch', 49.99, 85),
(126, 'Mech Horizon: Beyond', 83, 2008, 'Action RPG', 'PC, Switch', 69.99, 75),
(127, 'Cyber Engine', 7, 2004, 'Shooter', 'PC, Switch', 59.99, 90),
(128, 'Omega Protocol', 98, 2004, 'Roguelike', 'PC, PlayStation, Xbox', 59.99, 87),
(129, 'Nova Sector: Echoes', 2, 2007, '4X Strategy', 'PC, PlayStation', 59.99, 59),
(130, 'Alien Anomaly', 27, 2020, 'Survival', 'PC, PlayStation', 49.99, 72),
(131, 'Eclipse Horizon', 46, 2018, 'Shooter', 'PC, Xbox', 29.99, 84),
(132, 'Alien Uprising: Awakening', 41, 2022, '4X Strategy', 'PC, Xbox', 29.99, 78),
(133, 'Mech Frontier: Ascension', 93, 2016, 'Survival', 'PC, Xbox', 24.99, 64),
(134, 'Quantum Anomaly', 32, 2024, 'Adventure', 'Multiplatform', 59.99, 95),
(135, 'Quantum Legion', 93, 2013, 'Adventure', 'PC, Switch', 24.99, 74),
(136, 'Alien Wars', 83, 2015, 'RPG', 'Multiplatform', 19.99, 56),
(137, 'Void Frontier', 81, 2024, '4X Strategy', 'PC', 59.99, 61),
(138, 'Star Drift', 8, 2009, 'Roguelike', 'PC, PlayStation, Xbox', 59.99, 91),
(139, 'Alien Sector: Rift', 53, 2015, 'RPG', 'PC', 49.99, 69),
(140, 'Crimson Signal: Infinity', 23, 2023, 'Action RPG', 'PC', 49.99, 61),
(141, 'Titan Drift', 46, 2006, 'Shooter', 'PC, Switch', 19.99, 75),
(142, 'Hyper Uprising', 29, 2020, 'Shooter', 'PC, PlayStation, Xbox', 69.99, 57),
(143, 'Void Reckoning', 71, 2010, 'Adventure', 'PC', 59.99, 52),
(144, 'Shadow Reckoning', 83, 2011, 'Simulation', 'Multiplatform', 69.99, 58),
(145, 'Deep Protocol: Ascension', 35, 2013, 'RPG', 'PC', 59.99, 69),
(146, 'Crimson Colony', 41, 2003, 'RPG', 'PC, PlayStation', 49.99, 61),
(147, 'Hyper Reckoning: Ascension', 73, 2005, 'Survival', 'PC, PlayStation, Xbox', 49.99, 73),
(148, 'Orbit Protocol: Beyond', 10, 2024, 'Simulation', 'Multiplatform', 69.99, 91),
(149, 'Omega Horizon', 4, 2008, 'Shooter', 'PC, Switch', 39.99, 66),
(150, 'Orbit Engine', 24, 2011, 'Roguelike', 'PC, PlayStation, Xbox', 39.99, 57),
(151, 'Cyber Reckoning: Infinity', 82, 2020, 'Strategy', 'PC, PlayStation, Xbox', 39.99, 72),
(152, 'Orbit Odyssey: Prime', 47, 2012, 'Shooter', 'PC', 24.99, 57),
(153, 'Shadow Archive', 66, 2015, 'Survival', 'PC', 19.99, 57),
(154, 'Orbit Engine: Ascension', 42, 2023, 'Survival', 'PC', 29.99, 78),
(155, 'Hyper Reckoning', 32, 2015, 'Roguelike', 'Multiplatform', 24.99, 95),
(156, 'Hyper Wars: Prime', 64, 2006, 'Strategy', 'PC', 24.99, 79),
(157, 'Neon Archive: Reborn', 33, 2009, '4X Strategy', 'PC, PlayStation, Xbox', 59.99, 83),
(158, 'Omega Zero: Reborn', 39, 2002, 'RPG', 'PC, Switch', 29.99, 91),
(159, 'Hyper Expanse', 84, 2011, 'Roguelike', 'PC, PlayStation', 29.99, 72),
(160, 'Omega Drift', 51, 2003, 'Simulation', 'PC, Xbox', 59.99, 96),
(161, 'Alien Colony', 49, 2008, 'Shooter', 'PC, Switch', 29.99, 59),
(162, 'Iron Drift', 24, 2015, 'Tactical RPG', 'PC', 59.99, 81),
(163, 'Nova Uprising', 89, 2024, 'Action RPG', 'PC, Switch', 59.99, 83),
(164, 'Mech Signal: Nexus', 55, 2020, 'Survival', 'PC', 39.99, 90),
(165, 'Deep Archive', 47, 2023, 'Tactical RPG', 'Multiplatform', 59.99, 57),
(166, 'Galaxy Anomaly', 22, 2009, 'Roguelike', 'PC', 49.99, 93),
(167, 'Dark Odyssey: Prime', 66, 2005, 'Tactical RPG', 'Multiplatform', 49.99, 96),
(168, 'Iron Chronicle: Origins', 14, 2013, 'Shooter', 'PC, Switch', 19.99, 59),
(169, 'Mech Siege: Awakening', 27, 2023, 'Tactical RPG', 'PC, Switch', 29.99, 82),
(170, 'Galaxy Uprising', 41, 2012, 'Action RPG', 'PC, Xbox', 19.99, 97),
(171, 'Galaxy Frontier', 14, 2018, 'Strategy', 'PC, PlayStation, Xbox', 24.99, 85),
(172, 'Shadow Engine: Rift', 60, 2011, '4X Strategy', 'PC, Switch', 59.99, 63),
(173, 'Dark Horizon: Beyond', 36, 2004, 'Action RPG', 'Multiplatform', 19.99, 86),
(174, 'Shadow Siege: Awakening', 34, 2001, 'Adventure', 'Multiplatform', 59.99, 72),
(175, 'Omega Wars', 39, 2020, 'Roguelike', 'Multiplatform', 19.99, 95),
(176, 'Mech Expanse: Prime', 24, 2001, 'Simulation', 'PC, PlayStation, Xbox', 24.99, 84),
(177, 'Hyper Archive', 50, 2016, 'Survival', 'PC, PlayStation', 39.99, 92),
(178, 'Crimson Wars', 37, 2013, 'Strategy', 'PC, PlayStation', 29.99, 80),
(179, 'Star Sector: Infinity', 65, 2015, 'Adventure', 'PC, Switch', 59.99, 83),
(180, 'Dark Uprising', 73, 2000, 'RPG', 'PC, PlayStation', 29.99, 54),
(181, 'Neon Anomaly', 100, 2003, 'Adventure', 'Multiplatform', 59.99, 83),
(182, 'Crimson Chronicle: Reborn', 100, 2006, 'Tactical RPG', 'PC, Xbox', 49.99, 54),
(183, 'Solar Engine: Infinity', 95, 2001, '4X Strategy', 'PC, Xbox', 69.99, 54),
(184, 'Solar Legion: Reborn', 16, 2012, '4X Strategy', 'PC, PlayStation', 69.99, 89),
(185, 'Orbit Zero', 79, 2003, 'Strategy', 'PC, PlayStation', 69.99, 65),
(186, 'Neon Zero', 91, 2008, 'Shooter', 'PC, Xbox', 49.99, 69),
(187, 'Deep Odyssey: Infinity', 36, 1999, 'Strategy', 'PC, PlayStation, Xbox', 69.99, 60),
(188, 'Titan Directive', 32, 2024, 'Survival', 'PC, Switch', 24.99, 88),
(189, 'Neon Archive', 82, 2000, 'Action RPG', 'PC, Switch', 49.99, 69),
(190, 'Quantum Colony: Reborn', 59, 2021, 'Simulation', 'PC', 69.99, 86),
(191, 'Hyper Drift', 28, 2024, 'Adventure', 'PC, Xbox', 29.99, 70),
(192, 'Iron Sector', 88, 2026, 'RPG', 'PC', 19.99, 92),
(193, 'Solar Frontier: Nexus', 59, 2012, 'RPG', 'PC, Switch', 24.99, 96),
(194, 'Mech Signal: Prime', 84, 2000, 'Simulation', 'PC, Xbox', 19.99, 75),
(195, 'Shadow Protocol', 93, 2007, '4X Strategy', 'PC, Switch', 59.99, 57),
(196, 'Galaxy Frontier: Reborn', 76, 2002, '4X Strategy', 'Multiplatform', 59.99, 80),
(197, 'Star Frontier', 16, 2024, 'Survival', 'PC, PlayStation, Xbox', 24.99, 82),
(198, 'Galaxy Odyssey: Prime', 49, 2002, 'Strategy', 'PC, PlayStation, Xbox', 59.99, 61),
(199, 'Nova Directive', 88, 2017, 'Adventure', 'PC, PlayStation', 19.99, 58),
(200, 'Mech Odyssey', 45, 2010, 'Survival', 'PC, Xbox', 69.99, 60),
(201, 'Titan Engine', 78, 2021, 'Shooter', 'PC, PlayStation, Xbox', 19.99, 94),
(202, 'Eclipse Drift', 25, 2014, 'Survival', 'PC, Xbox', 59.99, 55),
(203, 'Titan Sector', 64, 2005, 'Roguelike', 'PC', 49.99, 52),
(204, 'Orbit Expanse: Ascension', 47, 2011, 'Tactical RPG', 'PC, PlayStation, Xbox', 24.99, 82),
(205, 'Cyber Frontier', 34, 1998, '4X Strategy', 'PC', 19.99, 77),
(206, 'Deep Signal', 99, 2014, 'Survival', 'PC, Switch', 59.99, 77),
(207, 'Mech Legion: Reborn', 27, 2014, 'Strategy', 'Multiplatform', 29.99, 77),
(208, 'Iron Reckoning: Infinity', 31, 2021, 'RPG', 'PC, PlayStation', 19.99, 79),
(209, 'Void Signal', 95, 2019, 'Strategy', 'PC', 19.99, 97),
(210, 'Mech Frontier: Echoes', 67, 2014, 'Shooter', 'PC, PlayStation', 29.99, 60),
(211, 'Neon Odyssey', 43, 1998, 'Survival', 'PC, Xbox', 49.99, 56),
(212, 'Neon Colony', 59, 2013, 'Tactical RPG', 'PC, Xbox', 19.99, 83),
(213, 'Iron Wars', 99, 2006, 'Action RPG', 'Multiplatform', 59.99, 59),
(214, 'Titan Chronicle: Origins', 6, 2005, 'Adventure', 'PC, Xbox', 39.99, 61),
(215, 'Dark Anomaly: Infinity', 41, 2021, 'Shooter', 'PC', 49.99, 75),
(216, 'Galaxy Chronicle', 23, 1999, '4X Strategy', 'Multiplatform', 19.99, 77),
(217, 'Eclipse Expanse: Awakening', 48, 1998, '4X Strategy', 'PC, Xbox', 49.99, 71),
(218, 'Omega Anomaly', 64, 2016, '4X Strategy', 'PC, PlayStation, Xbox', 49.99, 67),
(219, 'Mech Frontier', 30, 1998, 'Tactical RPG', 'PC, Xbox', 59.99, 96),
(220, 'Star Expanse: Infinity', 95, 2025, 'Shooter', 'PC', 24.99, 85),
(221, 'Titan Archive', 19, 1999, 'Shooter', 'PC', 19.99, 66),
(222, 'Cyber Colony: Nexus', 51, 2018, 'Action RPG', 'Multiplatform', 49.99, 55),
(223, 'Dark Directive: Prime', 41, 2025, 'Survival', 'PC, PlayStation, Xbox', 69.99, 72),
(224, 'Quantum Uprising: Reborn', 18, 2004, 'Roguelike', 'PC', 24.99, 58),
(225, 'Shadow Uprising', 16, 2011, 'Tactical RPG', 'PC, Xbox', 69.99, 65),
(226, 'Solar Signal', 16, 2025, 'Action RPG', 'PC, PlayStation', 69.99, 95),
(227, 'Eclipse Zero: Echoes', 12, 2002, '4X Strategy', 'PC, Xbox', 39.99, 84),
(228, 'Void Signal: Nexus', 52, 1998, 'Adventure', 'Multiplatform', 59.99, 87),
(229, 'Titan Odyssey', 18, 2023, 'Action RPG', 'PC', 19.99, 66),
(230, 'Mech Drift', 88, 2009, 'Action RPG', 'Multiplatform', 49.99, 68),
(231, 'Cyber Expanse: Awakening', 22, 1999, 'Roguelike', 'PC, Switch', 69.99, 77),
(232, 'Alien Frontier', 23, 2011, 'Simulation', 'PC, PlayStation', 24.99, 69),
(233, 'Neon Uprising', 79, 1999, 'Roguelike', 'Multiplatform', 24.99, 93),
(234, 'Crimson Sector: Prime', 18, 2010, 'Survival', 'PC, PlayStation', 59.99, 85),
(235, 'Hyper Siege', 63, 2023, 'Simulation', 'Multiplatform', 49.99, 72),
(236, 'Hyper Legion: Echoes', 29, 2017, 'RPG', 'PC, Xbox', 19.99, 82),
(237, 'Deep Siege', 21, 2005, 'Action RPG', 'PC, PlayStation', 59.99, 67),
(238, 'Shadow Wars: Echoes', 95, 2023, 'Simulation', 'Multiplatform', 19.99, 97),
(239, 'Orbit Colony', 25, 2016, 'Adventure', 'Multiplatform', 29.99, 63),
(240, 'Alien Protocol: Beyond', 29, 2017, 'RPG', 'Multiplatform', 39.99, 52);

INSERT INTO `characters` (`character_id`, `character_name`, `species_id`, `first_appearance_game_id`, `role_title`, `faction_name`, `is_playable`, `power_rating`) VALUES
(1, 'Soren Flint', 104, 52, 'pilot', 'Red Nebula', 1, 42),
(2, 'Nova-7', 76, 38, 'pilot', 'Helix Combine', 1, 10),
(3, 'Vera Ash', 51, 170, 'commander', 'Helix Combine', 1, 39),
(4, 'Soren Kade', 94, 41, 'diplomat', 'Independent', 1, 23),
(5, 'Cor Ion', 114, 178, 'terraformer', 'Red Nebula', 1, 86),
(6, 'Tara Rook', 40, 97, 'bounty hunter', 'Orion League', 1, 94),
(7, 'Ari Ash', 51, 147, 'commander', 'Free Colonies', 1, 78),
(8, 'Talon Marrow', 14, 145, 'miner', 'Orion League', 1, 96),
(9, 'Cass Strife', 41, 89, 'scientist', 'Helix Combine', 1, 58),
(10, 'Ari Vale', 32, 54, 'engineer', 'Red Nebula', 1, 14),
(11, 'Vale-7', 50, 13, 'drone operator', 'Nadir Circle', 1, 53),
(12, 'Lyra Sol', 70, 90, 'xenobiologist', 'Helix Combine', 1, 74),
(13, 'Ivo Kestrel', 29, 176, 'scientist', 'Independent', 0, 5),
(14, 'Dex-7', 34, 82, 'sniper', 'Helix Combine', 1, 22),
(15, 'Kest Sol', 94, 42, 'engineer', 'Titan Guard', 0, 44),
(16, 'Zev Flint', 62, 229, 'captain', 'Nadir Circle', 1, 78),
(17, 'Kest Renn', 7, 41, 'sniper', 'Red Nebula', 1, 25),
(18, 'Kael Ash', 93, 142, 'spy', 'Atlas Republic', 1, 39),
(19, 'Talon Arden', 51, 13, 'commander', 'Titan Guard', 1, 20),
(20, 'Nova Dray', 55, 1, 'engineer', 'Atlas Republic', 1, 26),
(21, 'Jax-7', 22, 53, 'bounty hunter', 'Helix Combine', 1, 15),
(22, 'Dex Sol', 63, 121, 'mechanic', 'Helix Combine', 1, 24),
(23, 'Vera Sol', 24, 95, 'drone operator', 'Free Colonies', 1, 57),
(24, 'Rin Vale', 108, 58, 'mechanic', 'Solar Union', 0, 20),
(25, 'Mako Ash', 13, 171, 'engineer', 'Red Nebula', 1, 97),
(26, 'Tara Strife', 8, 142, 'xenobiologist', 'Titan Guard', 1, 69),
(27, 'Nia Korr', 113, 147, 'archivist', 'Independent', 1, 11),
(28, 'Nyx Ash', 65, 9, 'commander', 'Titan Guard', 1, 16),
(29, 'Mako Pike', 22, 45, 'mercenary', 'Dust Cartel', 1, 6),
(30, 'Kael Quill', 56, 175, 'mercenary', 'Orion League', 1, 41),
(31, 'Bram Rime', 104, 235, 'engineer', 'Helix Combine', 1, 72),
(32, 'Nyx Ion', 110, 84, 'mechanic', 'Titan Guard', 1, 2),
(33, 'Zara Ash', 76, 160, 'medic', 'Nadir Circle', 0, 54),
(34, 'Lena Kade', 76, 146, 'commander', 'Helix Combine', 0, 73),
(35, 'Mako Arden', 37, 202, 'spy', 'Red Nebula', 1, 34),
(36, 'Nyx Marrow', 74, 125, 'terraformer', 'Independent', 0, 23),
(37, 'Kira Sol', 80, 37, 'terraformer', 'Nadir Circle', 0, 51),
(38, 'Kest Thorn', 31, 177, 'smuggler', 'Independent', 1, 48),
(39, 'Ari Thorn', 102, 210, 'bounty hunter', 'Atlas Republic', 1, 63),
(40, 'Rhea Ash', 13, 176, 'archivist', 'Orion League', 1, 96),
(41, 'Rin Kestrel', 42, 212, 'mechanic', 'Nadir Circle', 0, 25),
(42, 'Rin Halcyon', 106, 234, 'diplomat', 'Independent', 1, 8),
(43, 'Dax Rook', 40, 17, 'medic', 'Nadir Circle', 1, 100),
(44, 'Rhea Sable', 73, 226, 'captain', 'Orion League', 1, 26),
(45, 'Theo Voss', 5, 64, 'drone operator', 'Free Colonies', 1, 91),
(46, 'Mira Vale', 106, 95, 'drone operator', 'Titan Guard', 1, 82),
(47, 'Bram Arden', 4, 175, 'archivist', 'Red Nebula', 1, 77),
(48, 'Rin Rook', 61, 223, 'commander', 'Titan Guard', 1, 45),
(49, 'Orin Vale', 107, 192, 'engineer', 'Atlas Republic', 0, 50),
(50, 'Nova Rook', 74, 219, 'mercenary', 'Dust Cartel', 1, 87),
(51, 'Ivo Renn', 3, 132, 'captain', 'Independent', 1, 83),
(52, 'Orin Flint', 2, 206, 'archivist', 'Atlas Republic', 1, 92),
(53, 'Cor Marrow', 55, 71, 'xenobiologist', 'Red Nebula', 1, 33),
(54, 'Mira Pike', 87, 78, 'medic', 'Solar Union', 1, 75),
(55, 'Dax Cinder', 108, 216, 'ranger', 'Titan Guard', 1, 39),
(56, 'Nia Arden', 9, 124, 'hacker', 'Atlas Republic', 1, 36),
(57, 'Kira Marrow', 115, 183, 'bounty hunter', 'Dust Cartel', 1, 67),
(58, 'Mako Strife', 8, 231, 'terraformer', 'Nadir Circle', 1, 88),
(59, 'Lena Rime', 84, 7, 'miner', 'Atlas Republic', 1, 54),
(60, 'Nyx Sol', 5, 189, 'commander', 'Solar Union', 1, 44),
(61, 'Vale Ash', 88, 57, 'spy', 'Independent', 1, 65),
(62, 'Dex Rook', 85, 216, 'spy', 'Orion League', 1, 13),
(63, 'Lyra Kade', 34, 190, 'spy', 'Orion League', 1, 84),
(64, 'Vera Strife', 112, 191, 'bounty hunter', 'Nadir Circle', 1, 48),
(65, 'Kira Vex', 60, 76, 'sniper', 'Independent', 0, 82),
(66, 'Tara Vex', 10, 159, 'miner', 'Dust Cartel', 0, 88),
(67, 'Nyx Sable', 53, 77, 'smuggler', 'Orion League', 1, 26),
(68, 'Soren Renn', 115, 146, 'drone operator', 'Orion League', 1, 92),
(69, 'Orin Kestrel', 63, 21, 'hacker', 'Orion League', 1, 82),
(70, 'Mira Kestrel', 22, 199, 'commander', 'Orion League', 1, 98),
(71, 'Mako Quill', 79, 34, 'diplomat', 'Nadir Circle', 1, 55),
(72, 'Ari Voss', 26, 137, 'ranger', 'Free Colonies', 1, 97),
(73, 'Theo Sable', 3, 49, 'captain', 'Dust Cartel', 1, 89),
(74, 'Kest Dray', 17, 80, 'sniper', 'Nadir Circle', 1, 22),
(75, 'Cass Voss', 38, 77, 'drone operator', 'Titan Guard', 1, 56),
(76, 'Kest Cinder', 44, 35, 'miner', 'Red Nebula', 1, 22),
(77, 'Bram Sol', 30, 5, 'archivist', 'Orion League', 1, 94),
(78, 'Ari Vex', 22, 130, 'sniper', 'Red Nebula', 0, 49),
(79, 'Kest Marrow', 99, 66, 'spy', 'Solar Union', 0, 77),
(80, 'Nova Cinder', 84, 28, 'captain', 'Free Colonies', 0, 54),
(81, 'Rin Sol', 71, 32, 'mechanic', 'Independent', 1, 27),
(82, 'Cor Cinder', 2, 162, 'bounty hunter', 'Nadir Circle', 0, 85),
(83, 'Dax Vale', 78, 160, 'pilot', 'Nadir Circle', 0, 66),
(84, 'Vale Flint', 37, 31, 'sniper', 'Helix Combine', 1, 26),
(85, 'Zev Halcyon', 34, 200, 'medic', 'Dust Cartel', 1, 91),
(86, 'Kael Mercer', 6, 42, 'spy', 'Independent', 1, 89),
(87, 'Bram Korr', 31, 85, 'captain', 'Free Colonies', 0, 15),
(88, 'Theo Vex', 64, 172, 'pilot', 'Helix Combine', 0, 93),
(89, 'Vale Arden', 33, 232, 'archivist', 'Independent', 1, 34),
(90, 'Rin Voss', 105, 26, 'scientist', 'Free Colonies', 1, 47),
(91, 'Zara Cinder', 55, 81, 'sniper', 'Helix Combine', 0, 2),
(92, 'Rhea Kade', 83, 170, 'scientist', 'Red Nebula', 1, 57),
(93, 'Zev Vale', 94, 225, 'engineer', 'Red Nebula', 1, 24),
(94, 'Jax Sol', 59, 103, 'mechanic', 'Nadir Circle', 1, 54),
(95, 'Ivo Rook', 17, 29, 'smuggler', 'Orion League', 0, 54),
(96, 'Bram Vex', 103, 124, 'commander', 'Independent', 1, 79),
(97, 'Nyx Kestrel', 79, 92, 'captain', 'Orion League', 1, 63),
(98, 'Jax Renn', 6, 113, 'engineer', 'Atlas Republic', 1, 2),
(99, 'Dax Kestrel', 74, 191, 'commander', 'Dust Cartel', 1, 67),
(100, 'Dax Ash', 80, 180, 'sniper', 'Nadir Circle', 1, 62),
(101, 'Vera Cinder', 83, 174, 'xenobiologist', 'Orion League', 0, 2),
(102, 'Dax Korr', 64, 219, 'scientist', 'Helix Combine', 1, 42),
(103, 'Talon Thorn', 7, 72, 'medic', 'Dust Cartel', 1, 52),
(104, 'Theo Strife', 59, 21, 'drone operator', 'Solar Union', 1, 12),
(105, 'Rhea Korr', 41, 115, 'sniper', 'Independent', 0, 14),
(106, 'Nyx Renn', 72, 10, 'spy', 'Free Colonies', 0, 78),
(107, 'Zev Marrow', 114, 78, 'medic', 'Titan Guard', 1, 84),
(108, 'Nia Pike', 47, 88, 'smuggler', 'Dust Cartel', 1, 43),
(109, 'Sel Kestrel', 77, 159, 'miner', 'Red Nebula', 1, 15),
(110, 'Jax Kestrel', 29, 169, 'captain', 'Red Nebula', 1, 82),
(111, 'Zara Mercer', 67, 141, 'ranger', 'Helix Combine', 0, 22),
(112, 'Theo Ash', 93, 191, 'diplomat', 'Helix Combine', 1, 79),
(113, 'Mira Halcyon', 120, 31, 'xenobiologist', 'Dust Cartel', 1, 25),
(114, 'Cor Thorn', 97, 28, 'diplomat', 'Free Colonies', 0, 99),
(115, 'Kest Pike', 85, 118, 'commander', 'Titan Guard', 1, 64),
(116, 'Ari Sable', 7, 189, 'spy', 'Nadir Circle', 1, 66),
(117, 'Mako Rook', 75, 178, 'scientist', 'Orion League', 0, 50),
(118, 'Nia Flint', 113, 156, 'hacker', 'Titan Guard', 1, 54),
(119, 'Zev Ash', 32, 196, 'mechanic', 'Nadir Circle', 1, 38),
(120, 'Rin Kade', 53, 36, 'terraformer', 'Titan Guard', 1, 90),
(121, 'Sel Thorn', 95, 183, 'spy', 'Dust Cartel', 1, 27),
(122, 'Dex Cinder', 118, 89, 'pilot', 'Orion League', 1, 91),
(123, 'Vera Ion', 75, 123, 'commander', 'Nadir Circle', 1, 55),
(124, 'Zara-7', 14, 134, 'captain', 'Nadir Circle', 1, 7),
(125, 'Nia Voss', 35, 52, 'scientist', 'Atlas Republic', 1, 19),
(126, 'Cor Mercer', 97, 53, 'spy', 'Free Colonies', 1, 58),
(127, 'Jax Flint', 87, 223, 'spy', 'Dust Cartel', 1, 31),
(128, 'Dex Ash', 7, 171, 'xenobiologist', 'Nadir Circle', 1, 88),
(129, 'Soren Ion', 2, 14, 'mechanic', 'Dust Cartel', 1, 29),
(130, 'Bram Marrow', 91, 181, 'ranger', 'Solar Union', 1, 100),
(131, 'Vale Halcyon', 58, 76, 'scientist', 'Helix Combine', 1, 23),
(132, 'Vale Sable', 49, 31, 'smuggler', 'Nadir Circle', 1, 72),
(133, 'Kira Kade', 75, 42, 'mechanic', 'Free Colonies', 1, 60),
(134, 'Cor Kade', 20, 11, 'hacker', 'Solar Union', 0, 100),
(135, 'Zev Cinder', 63, 78, 'commander', 'Titan Guard', 1, 10),
(136, 'Soren Sable', 24, 57, 'medic', 'Helix Combine', 1, 54),
(137, 'Sel Ion', 12, 104, 'ranger', 'Dust Cartel', 1, 85),
(138, 'Soren Thorn', 38, 93, 'mercenary', 'Solar Union', 1, 72),
(139, 'Theo Kestrel', 2, 167, 'sniper', 'Red Nebula', 1, 31),
(140, 'Talon Voss', 114, 175, 'hacker', 'Nadir Circle', 0, 50),
(141, 'Kira Ion', 37, 186, 'captain', 'Titan Guard', 1, 66),
(142, 'Zara Sable', 63, 115, 'smuggler', 'Atlas Republic', 1, 42),
(143, 'Dax Quill', 22, 25, 'spy', 'Titan Guard', 0, 81),
(144, 'Cass Halcyon', 81, 172, 'mercenary', 'Nadir Circle', 0, 27),
(145, 'Sel Ash', 95, 225, 'diplomat', 'Helix Combine', 1, 4),
(146, 'Rin Ash', 5, 85, 'engineer', 'Helix Combine', 0, 23),
(147, 'Zara Vale', 10, 143, 'commander', 'Dust Cartel', 1, 53),
(148, 'Nyx Pike', 52, 162, 'diplomat', 'Red Nebula', 0, 50),
(149, 'Sel-7', 93, 165, 'terraformer', 'Helix Combine', 0, 90),
(150, 'Rhea Quill', 119, 92, 'medic', 'Helix Combine', 1, 88),
(151, 'Dex Flint', 37, 23, 'drone operator', 'Nadir Circle', 1, 85),
(152, 'Ari Korr', 69, 41, 'archivist', 'Orion League', 1, 70),
(153, 'Dex Marrow', 39, 37, 'ranger', 'Free Colonies', 1, 16),
(154, 'Tara Flint', 69, 101, 'spy', 'Helix Combine', 1, 27),
(155, 'Vale Rime', 93, 232, 'ranger', 'Dust Cartel', 1, 83),
(156, 'Lena Rook', 29, 48, 'terraformer', 'Atlas Republic', 1, 15),
(157, 'Orin Cinder', 73, 205, 'smuggler', 'Titan Guard', 1, 83),
(158, 'Sel Quill', 86, 75, 'engineer', 'Atlas Republic', 0, 26),
(159, 'Vale Vex', 43, 125, 'ranger', 'Orion League', 1, 13),
(160, 'Soren Korr', 43, 116, 'terraformer', 'Atlas Republic', 1, 73),
(161, 'Tara Dray', 41, 207, 'diplomat', 'Orion League', 0, 41),
(162, 'Talon Strife', 95, 183, 'diplomat', 'Atlas Republic', 1, 18),
(163, 'Nia Rime', 113, 85, 'miner', 'Independent', 1, 46),
(164, 'Mako Mercer', 71, 125, 'sniper', 'Orion League', 0, 36),
(165, 'Kest Ion', 34, 51, 'engineer', 'Helix Combine', 0, 65),
(166, 'Ivo-7', 75, 209, 'commander', 'Nadir Circle', 1, 5),
(167, 'Sel Vale', 115, 140, 'spy', 'Independent', 1, 47),
(168, 'Nyx Strife', 99, 229, 'commander', 'Atlas Republic', 1, 60),
(169, 'Dax Sable', 51, 24, 'ranger', 'Titan Guard', 0, 85),
(170, 'Talon Flint', 22, 176, 'medic', 'Orion League', 1, 21),
(171, 'Orin Vex', 85, 145, 'pilot', 'Independent', 1, 6),
(172, 'Talon Kestrel', 30, 125, 'engineer', 'Atlas Republic', 1, 30),
(173, 'Mira Sable', 102, 233, 'ranger', 'Nadir Circle', 1, 59),
(174, 'Kest Voss', 84, 11, 'hacker', 'Helix Combine', 1, 95),
(175, 'Sel Vex', 49, 45, 'xenobiologist', 'Red Nebula', 0, 67),
(176, 'Bram Strife', 52, 133, 'ranger', 'Red Nebula', 1, 62),
(177, 'Kest Flint', 65, 2, 'pilot', 'Independent', 1, 30),
(178, 'Cass Sable', 36, 165, 'mercenary', 'Orion League', 1, 21),
(179, 'Vera Flint', 105, 184, 'sniper', 'Dust Cartel', 1, 43),
(180, 'Lyra Cinder', 62, 123, 'mercenary', 'Solar Union', 1, 83),
(181, 'Theo Renn', 32, 6, 'smuggler', 'Orion League', 1, 18),
(182, 'Ivo Sable', 115, 11, 'commander', 'Orion League', 0, 22),
(183, 'Kira Rook', 52, 133, 'terraformer', 'Solar Union', 0, 93),
(184, 'Vale Cinder', 37, 211, 'engineer', 'Dust Cartel', 1, 78),
(185, 'Lyra Korr', 29, 44, 'diplomat', 'Solar Union', 1, 75),
(186, 'Nia Sable', 22, 68, 'hacker', 'Independent', 0, 30),
(187, 'Lena Arden', 26, 5, 'medic', 'Titan Guard', 1, 20),
(188, 'Zev Arden', 61, 46, 'terraformer', 'Solar Union', 0, 69),
(189, 'Jax Quill', 85, 124, 'pilot', 'Solar Union', 0, 100),
(190, 'Nia Marrow', 67, 111, 'diplomat', 'Red Nebula', 0, 90),
(191, 'Dax Renn', 103, 59, 'miner', 'Nadir Circle', 1, 76),
(192, 'Zara Rime', 98, 233, 'commander', 'Helix Combine', 1, 18),
(193, 'Kira Korr', 30, 197, 'engineer', 'Atlas Republic', 1, 33),
(194, 'Mira-7', 96, 182, 'captain', 'Solar Union', 0, 67),
(195, 'Ari Sol', 27, 168, 'hacker', 'Nadir Circle', 1, 14),
(196, 'Lena Renn', 75, 167, 'mechanic', 'Atlas Republic', 1, 73),
(197, 'Kira Cinder', 97, 102, 'mercenary', 'Nadir Circle', 1, 23),
(198, 'Sel Korr', 40, 65, 'commander', 'Red Nebula', 1, 95),
(199, 'Lena Cinder', 96, 31, 'archivist', 'Independent', 1, 13),
(200, 'Nyx Thorn', 71, 206, 'terraformer', 'Free Colonies', 1, 50),
(201, 'Zara Quill', 19, 211, 'miner', 'Solar Union', 1, 12),
(202, 'Cass Vale', 48, 57, 'engineer', 'Solar Union', 0, 93),
(203, 'Dax Mercer', 77, 183, 'smuggler', 'Orion League', 1, 57),
(204, 'Ari Halcyon', 85, 218, 'medic', 'Atlas Republic', 1, 5),
(205, 'Zara Flint', 67, 131, 'archivist', 'Solar Union', 1, 87),
(206, 'Ari Rook', 36, 23, 'xenobiologist', 'Red Nebula', 1, 52),
(207, 'Tara Halcyon', 2, 133, 'engineer', 'Helix Combine', 1, 93),
(208, 'Theo Ion', 75, 235, 'ranger', 'Red Nebula', 1, 29),
(209, 'Tara-7', 23, 67, 'diplomat', 'Titan Guard', 0, 72),
(210, 'Dex Thorn', 103, 30, 'medic', 'Atlas Republic', 1, 89),
(211, 'Tara Korr', 32, 198, 'hacker', 'Independent', 1, 76),
(212, 'Rhea-7', 15, 124, 'mechanic', 'Helix Combine', 1, 82),
(213, 'Zara Strife', 90, 174, 'archivist', 'Red Nebula', 1, 46),
(214, 'Dax Ion', 90, 3, 'mechanic', 'Dust Cartel', 1, 12),
(215, 'Nyx Cinder', 106, 192, 'hacker', 'Helix Combine', 1, 61),
(216, 'Soren Dray', 115, 56, 'commander', 'Atlas Republic', 1, 96),
(217, 'Nia Halcyon', 95, 128, 'mercenary', 'Dust Cartel', 1, 34),
(218, 'Mira Strife', 107, 52, 'archivist', 'Solar Union', 1, 20),
(219, 'Nia Cinder', 79, 127, 'captain', 'Titan Guard', 0, 62),
(220, 'Kest Vex', 36, 223, 'miner', 'Orion League', 1, 51),
(221, 'Tara Kade', 68, 14, 'diplomat', 'Independent', 0, 65),
(222, 'Rhea Cinder', 23, 199, 'drone operator', 'Helix Combine', 1, 41),
(223, 'Cor-7', 87, 4, 'mercenary', 'Nadir Circle', 0, 42),
(224, 'Rhea Vale', 71, 48, 'mechanic', 'Dust Cartel', 1, 61),
(225, 'Zev Thorn', 24, 94, 'miner', 'Nadir Circle', 1, 54),
(226, 'Cor Kestrel', 47, 96, 'xenobiologist', 'Atlas Republic', 1, 24),
(227, 'Tara Cinder', 105, 59, 'sniper', 'Atlas Republic', 1, 72),
(228, 'Kael Sol', 19, 51, 'pilot', 'Independent', 0, 23),
(229, 'Kael Korr', 115, 35, 'medic', 'Titan Guard', 1, 63),
(230, 'Dex Vale', 110, 144, 'commander', 'Free Colonies', 1, 13),
(231, 'Cor Rook', 28, 16, 'mechanic', 'Independent', 0, 58),
(232, 'Vale Thorn', 47, 67, 'ranger', 'Titan Guard', 1, 45),
(233, 'Ari Renn', 45, 32, 'terraformer', 'Dust Cartel', 1, 100),
(234, 'Dex Dray', 87, 84, 'medic', 'Independent', 1, 11),
(235, 'Nyx Flint', 60, 74, 'pilot', 'Orion League', 1, 54),
(236, 'Ivo Flint', 52, 147, 'engineer', 'Helix Combine', 1, 44),
(237, 'Soren Marrow', 91, 75, 'mechanic', 'Solar Union', 1, 35),
(238, 'Mako Dray', 76, 192, 'medic', 'Independent', 1, 22),
(239, 'Orin-7', 94, 33, 'archivist', 'Atlas Republic', 0, 27),
(240, 'Orin Sol', 13, 27, 'engineer', 'Independent', 0, 4),
(241, 'Mako Sol', 98, 135, 'engineer', 'Helix Combine', 1, 80),
(242, 'Lena Quill', 120, 168, 'xenobiologist', 'Atlas Republic', 1, 32),
(243, 'Vale Mercer', 81, 114, 'pilot', 'Orion League', 1, 4),
(244, 'Vera Thorn', 61, 222, 'drone operator', 'Titan Guard', 1, 71),
(245, 'Zev Pike', 96, 162, 'commander', 'Nadir Circle', 1, 45),
(246, 'Lyra Ion', 104, 59, 'engineer', 'Independent', 1, 47),
(247, 'Kael Vale', 39, 40, 'captain', 'Free Colonies', 1, 45),
(248, 'Dex Korr', 2, 137, 'miner', 'Independent', 1, 2),
(249, 'Mako Renn', 38, 205, 'terraformer', 'Dust Cartel', 0, 71),
(250, 'Vera Halcyon', 113, 106, 'spy', 'Nadir Circle', 1, 32),
(251, 'Orin Ash', 83, 189, 'xenobiologist', 'Nadir Circle', 1, 34),
(252, 'Cass Renn', 31, 161, 'medic', 'Solar Union', 1, 37),
(253, 'Ivo Rime', 104, 137, 'mechanic', 'Nadir Circle', 1, 9),
(254, 'Orin Kade', 15, 75, 'drone operator', 'Solar Union', 1, 35),
(255, 'Cor Flint', 25, 126, 'hacker', 'Free Colonies', 1, 7),
(256, 'Orin Arden', 35, 73, 'pilot', 'Independent', 0, 30),
(257, 'Cass Kade', 64, 4, 'mercenary', 'Red Nebula', 1, 40),
(258, 'Zara Korr', 60, 96, 'smuggler', 'Red Nebula', 0, 97),
(259, 'Lena Voss', 100, 69, 'xenobiologist', 'Helix Combine', 1, 24),
(260, 'Theo Sol', 2, 213, 'sniper', 'Dust Cartel', 1, 99);

INSERT INTO `missions` (`mission_id`, `game_id`, `mission_title`, `quest_giver_character_id`, `mission_type`, `difficulty`, `reward_credits`, `is_main_story`) VALUES
(1, 114, 'Defend the xenoforest', 127, 'stealth', 'Easy', 17176, 0),
(2, 122, 'Mine the dust moon', 200, 'bounty', 'Easy', 24503, 0),
(3, 65, 'Mine the xenoforest', 247, 'escort', 'Easy', 21946, 0),
(4, 29, 'Negotiate the dust moon', 121, 'story', 'Normal', 9147, 0),
(5, 102, 'Recover the crystal vault', 125, 'faction', 'Very Hard', 22657, 0),
(6, 96, 'Infiltrate the rogue AI', 46, 'stealth', 'Easy', 22577, 0),
(7, 239, 'Defend the research lab', 31, 'bounty', 'Legendary', 3619, 0),
(8, 125, 'Secure the mining outpost', 120, 'escort', 'Very Hard', 24125, 0),
(9, 6, 'Evacuate the wormhole gate', 194, 'raid', 'Easy', 16002, 1),
(10, 144, 'Awaken the prison barge', 151, 'exploration', 'Legendary', 6215, 0),
(11, 83, 'Chart the ghost fleet', 240, 'puzzle', 'Normal', 2356, 0),
(12, 116, 'Chart the mining outpost', 152, 'escort', 'Very Hard', 123, 1),
(13, 188, 'Recover the ghost fleet', 95, 'escort', 'Legendary', 7924, 0),
(14, 185, 'Awaken the artifact cache', 33, 'exploration', 'Legendary', 22487, 1),
(15, 197, 'Stabilize the smuggler convoy', 79, 'escort', 'Very Hard', 21101, 0),
(16, 29, 'Investigate the reactor core', 50, 'story', 'Normal', 5953, 0),
(17, 52, 'Track the xenoforest', 55, 'side', 'Easy', 18810, 1),
(18, 169, 'Investigate the ghost fleet', 251, 'faction', 'Hard', 1708, 0),
(19, 57, 'Recover the xenoforest', 37, 'stealth', 'Easy', 15437, 0),
(20, 93, 'Evacuate the crystal vault', 213, 'faction', 'Hard', 17434, 0),
(21, 188, 'Mine the reactor core', 37, 'exploration', 'Legendary', 3282, 0),
(22, 186, 'Awaken the artifact cache', 119, 'exploration', 'Normal', 17342, 0),
(23, 146, 'Awaken the mining outpost', 92, 'survival', 'Easy', 21026, 0),
(24, 173, 'Negotiate the frontier colony', 235, 'bounty', 'Normal', 18121, 1),
(25, 130, 'Decode the mining outpost', 173, 'faction', 'Very Hard', 11644, 0),
(26, 141, 'Evacuate the quantum relay', 167, 'survival', 'Hard', 20036, 0),
(27, 145, 'Steal the mining outpost', 110, 'raid', 'Hard', 14924, 1),
(28, 102, 'Defend the smuggler convoy', 1, 'faction', 'Easy', 17061, 0),
(29, 228, 'Recover the smuggler convoy', 155, 'exploration', 'Normal', 10418, 0),
(30, 198, 'Awaken the black box', 142, 'puzzle', 'Legendary', 18830, 0),
(31, 25, 'Contain the research lab', 20, 'bounty', 'Normal', 8783, 0),
(32, 228, 'Infiltrate the orbital station', 128, 'raid', 'Easy', 18793, 1),
(33, 146, 'Escort the dust moon', 112, 'stealth', 'Normal', 16099, 0),
(34, 153, 'Defend the weather array', 154, 'survival', 'Easy', 1932, 0),
(35, 90, 'Negotiate the frontier colony', 223, 'exploration', 'Legendary', 474, 1),
(36, 14, 'Investigate the crystal vault', 157, 'escort', 'Legendary', 18611, 0),
(37, 84, 'Infiltrate the wormhole gate', 258, 'story', 'Very Hard', 14701, 0),
(38, 57, 'Mine the artifact cache', 222, 'bounty', 'Normal', 11115, 0),
(39, 122, 'Awaken the artifact cache', 26, 'raid', 'Easy', 13158, 1),
(40, 199, 'Sabotage the prison barge', 67, 'puzzle', 'Normal', 16086, 1),
(41, 167, 'Awaken the ghost fleet', 101, 'puzzle', 'Normal', 8040, 0),
(42, 69, 'Secure the weather array', 221, 'side', 'Easy', 22111, 1),
(43, 109, 'Evacuate the xenoforest', 188, 'escort', 'Hard', 19560, 0),
(44, 198, 'Decode the research lab', 157, 'faction', 'Very Hard', 20520, 0),
(45, 113, 'Infiltrate the xenoforest', 23, 'escort', 'Normal', 24929, 0),
(46, 29, 'Infiltrate the ghost fleet', 28, 'bounty', 'Hard', 550, 0),
(47, 178, 'Mine the lost survey team', 57, 'stealth', 'Easy', 10974, 0),
(48, 190, 'Rescue the mining outpost', 109, 'puzzle', 'Hard', 18083, 1),
(49, 160, 'Recover the artifact cache', 73, 'faction', 'Legendary', 1524, 0),
(50, 44, 'Mine the xenoforest', 31, 'faction', 'Hard', 1839, 1),
(51, 168, 'Escort the artifact cache', 5, 'raid', 'Hard', 3635, 0),
(52, 75, 'Infiltrate the artifact cache', 198, 'puzzle', 'Easy', 10436, 1),
(53, 222, 'Decode the xenoforest', 46, 'puzzle', 'Very Hard', 18472, 0),
(54, 11, 'Investigate the smuggler convoy', 127, 'escort', 'Very Hard', 12990, 0),
(55, 5, 'Evacuate the research lab', 178, 'raid', 'Normal', 16525, 0),
(56, 208, 'Chart the artifact cache', 32, 'story', 'Legendary', 9281, 0),
(57, 39, 'Steal the wormhole gate', 175, 'side', 'Very Hard', 17162, 0),
(58, 107, 'Repair the wormhole gate', 124, 'survival', 'Hard', 19936, 0),
(59, 115, 'Rescue the wormhole gate', 68, 'faction', 'Legendary', 22514, 0),
(60, 221, 'Mine the black box', 71, 'bounty', 'Very Hard', 4856, 0),
(61, 82, 'Awaken the mining outpost', 35, 'side', 'Normal', 10507, 0),
(62, 187, 'Secure the quantum relay', 16, 'survival', 'Hard', 14616, 0),
(63, 39, 'Scan the wormhole gate', 97, 'bounty', 'Easy', 20153, 0),
(64, 156, 'Stabilize the signal beacon', 119, 'exploration', 'Easy', 11872, 0),
(65, 177, 'Sabotage the black box', 245, 'faction', 'Very Hard', 23431, 0),
(66, 48, 'Track the prison barge', 199, 'bounty', 'Normal', 6432, 0),
(67, 9, 'Recover the orbital station', 210, 'survival', 'Normal', 24425, 0),
(68, 194, 'Escort the rogue AI', 105, 'stealth', 'Legendary', 16154, 0),
(69, 222, 'Infiltrate the quantum relay', 235, 'survival', 'Easy', 20020, 1),
(70, 185, 'Steal the ghost fleet', 161, 'faction', 'Legendary', 17668, 0),
(71, 134, 'Contain the lost survey team', 56, 'story', 'Normal', 17096, 1),
(72, 189, 'Awaken the artifact cache', 21, 'puzzle', 'Easy', 6321, 0),
(73, 113, 'Mine the smuggler convoy', 204, 'stealth', 'Normal', 13943, 0),
(74, 157, 'Investigate the wormhole gate', 28, 'stealth', 'Very Hard', 3063, 0),
(75, 47, 'Steal the quantum relay', 70, 'escort', 'Very Hard', 916, 0),
(76, 117, 'Contain the reactor core', 104, 'raid', 'Hard', 22766, 0),
(77, 184, 'Escort the frontier colony', 64, 'stealth', 'Hard', 2895, 1),
(78, 187, 'Steal the mining outpost', 82, 'survival', 'Easy', 5699, 0),
(79, 145, 'Decode the wormhole gate', 77, 'bounty', 'Easy', 13848, 0),
(80, 80, 'Mine the rogue AI', 229, 'side', 'Normal', 6747, 0),
(81, 160, 'Recover the lost survey team', 130, 'stealth', 'Very Hard', 17909, 0),
(82, 156, 'Infiltrate the xenoforest', 253, 'faction', 'Very Hard', 14968, 1),
(83, 114, 'Stabilize the ghost fleet', 41, 'story', 'Normal', 18035, 0),
(84, 159, 'Defend the rogue AI', 107, 'bounty', 'Easy', 21506, 0),
(85, 10, 'Defend the weather array', 75, 'faction', 'Hard', 10949, 0),
(86, 13, 'Negotiate the rogue AI', 56, 'bounty', 'Hard', 20124, 0),
(87, 117, 'Defend the reactor core', 185, 'raid', 'Hard', 12177, 1),
(88, 210, 'Negotiate the mining outpost', 35, 'side', 'Hard', 15527, 0),
(89, 32, 'Secure the black box', 141, 'survival', 'Legendary', 6976, 0),
(90, 157, 'Scan the weather array', 30, 'puzzle', 'Easy', 15948, 0),
(91, 110, 'Chart the black box', 163, 'faction', 'Legendary', 11695, 0),
(92, 158, 'Investigate the prison barge', 255, 'stealth', 'Normal', 20069, 0),
(93, 182, 'Rescue the derelict carrier', 149, 'side', 'Easy', 15333, 0),
(94, 189, 'Stabilize the quantum relay', 107, 'survival', 'Easy', 11037, 0),
(95, 144, 'Recover the xenoforest', 109, 'raid', 'Hard', 2322, 0),
(96, 77, 'Awaken the dust moon', 260, 'story', 'Easy', 22573, 0),
(97, 88, 'Repair the ghost fleet', 203, 'story', 'Normal', 6457, 0),
(98, 214, 'Track the prison barge', 174, 'story', 'Normal', 15877, 0),
(99, 161, 'Awaken the dust moon', 236, 'stealth', 'Very Hard', 24433, 0),
(100, 214, 'Repair the dust moon', 154, 'puzzle', 'Legendary', 713, 0),
(101, 148, 'Evacuate the reactor core', 170, 'bounty', 'Hard', 1121, 0),
(102, 97, 'Repair the ghost fleet', 85, 'survival', 'Normal', 19603, 0),
(103, 222, 'Secure the crystal vault', 158, 'raid', 'Very Hard', 2944, 1),
(104, 225, 'Evacuate the lost survey team', 122, 'raid', 'Normal', 17306, 0),
(105, 45, 'Evacuate the crystal vault', 58, 'exploration', 'Easy', 14641, 0),
(106, 205, 'Investigate the wormhole gate', 248, 'exploration', 'Hard', 15942, 0),
(107, 199, 'Sabotage the frontier colony', 168, 'puzzle', 'Normal', 6823, 0),
(108, 118, 'Investigate the frontier colony', 199, 'story', 'Hard', 1542, 0),
(109, 86, 'Defend the frontier colony', 240, 'puzzle', 'Hard', 836, 0),
(110, 164, 'Secure the xenoforest', 108, 'exploration', 'Hard', 9165, 0),
(111, 198, 'Scan the orbital station', 226, 'bounty', 'Normal', 9066, 0),
(112, 4, 'Rescue the mining outpost', 53, 'escort', 'Legendary', 10536, 0),
(113, 37, 'Repair the signal beacon', 146, 'bounty', 'Easy', 10303, 0),
(114, 139, 'Defend the wormhole gate', 228, 'story', 'Very Hard', 22234, 0),
(115, 28, 'Defend the reactor core', 197, 'survival', 'Very Hard', 5964, 1),
(116, 158, 'Mine the dust moon', 183, 'exploration', 'Legendary', 2673, 1),
(117, 146, 'Escort the lost survey team', 68, 'side', 'Very Hard', 10270, 1),
(118, 121, 'Infiltrate the wormhole gate', 119, 'faction', 'Hard', 12009, 1),
(119, 47, 'Secure the lost survey team', 170, 'stealth', 'Easy', 2241, 1),
(120, 29, 'Track the lost survey team', 180, 'bounty', 'Hard', 11523, 0),
(121, 131, 'Steal the frontier colony', 53, 'escort', 'Legendary', 21381, 0),
(122, 203, 'Awaken the lost survey team', 155, 'survival', 'Legendary', 13647, 0),
(123, 159, 'Awaken the rogue AI', 125, 'stealth', 'Very Hard', 2264, 0),
(124, 54, 'Negotiate the weather array', 221, 'escort', 'Legendary', 22845, 0),
(125, 45, 'Repair the prison barge', 40, 'side', 'Legendary', 19632, 1),
(126, 84, 'Contain the rogue AI', 50, 'raid', 'Very Hard', 2380, 0),
(127, 176, 'Secure the prison barge', 195, 'story', 'Easy', 7230, 0),
(128, 228, 'Sabotage the wormhole gate', 1, 'stealth', 'Legendary', 9651, 1),
(129, 158, 'Rescue the xenoforest', 229, 'escort', 'Hard', 18786, 0),
(130, 236, 'Evacuate the reactor core', 223, 'faction', 'Easy', 20137, 1),
(131, 217, 'Mine the crystal vault', 66, 'escort', 'Legendary', 1840, 0),
(132, 181, 'Scan the smuggler convoy', 184, 'story', 'Normal', 14246, 1),
(133, 161, 'Steal the artifact cache', 163, 'survival', 'Very Hard', 17962, 0),
(134, 170, 'Track the wormhole gate', 89, 'exploration', 'Legendary', 12702, 0),
(135, 216, 'Sabotage the smuggler convoy', 214, 'bounty', 'Normal', 480, 0),
(136, 166, 'Sabotage the prison barge', 9, 'survival', 'Normal', 2874, 0),
(137, 165, 'Contain the ghost fleet', 213, 'survival', 'Legendary', 5991, 1),
(138, 131, 'Awaken the lost survey team', 218, 'survival', 'Hard', 7497, 0),
(139, 109, 'Repair the prison barge', 4, 'exploration', 'Legendary', 8922, 1),
(140, 238, 'Defend the crystal vault', 188, 'faction', 'Very Hard', 23197, 0),
(141, 29, 'Escort the wormhole gate', 247, 'puzzle', 'Hard', 15335, 0),
(142, 134, 'Infiltrate the prison barge', 46, 'side', 'Legendary', 19093, 0),
(143, 157, 'Secure the mining outpost', 28, 'story', 'Very Hard', 14977, 1),
(144, 147, 'Negotiate the research lab', 170, 'raid', 'Hard', 5588, 0),
(145, 178, 'Repair the orbital station', 156, 'story', 'Very Hard', 19044, 0),
(146, 147, 'Mine the ghost fleet', 27, 'story', 'Hard', 15984, 0),
(147, 33, 'Escort the orbital station', 259, 'raid', 'Normal', 20278, 0),
(148, 71, 'Recover the frontier colony', 132, 'faction', 'Normal', 19491, 0),
(149, 169, 'Evacuate the rogue AI', 229, 'raid', 'Normal', 15989, 0),
(150, 205, 'Secure the reactor core', 17, 'bounty', 'Legendary', 5151, 1),
(151, 193, 'Steal the signal beacon', 212, 'stealth', 'Normal', 7009, 0),
(152, 14, 'Scan the crystal vault', 136, 'bounty', 'Very Hard', 13166, 1),
(153, 78, 'Awaken the signal beacon', 244, 'survival', 'Very Hard', 15651, 0),
(154, 38, 'Recover the smuggler convoy', 223, 'stealth', 'Very Hard', 22332, 0),
(155, 136, 'Scan the mining outpost', 22, 'escort', 'Very Hard', 20104, 0),
(156, 86, 'Chart the frontier colony', 139, 'raid', 'Legendary', 12917, 1),
(157, 198, 'Repair the xenoforest', 124, 'puzzle', 'Hard', 22307, 0),
(158, 81, 'Recover the reactor core', 6, 'story', 'Very Hard', 3301, 0),
(159, 176, 'Evacuate the signal beacon', 229, 'raid', 'Hard', 6426, 0),
(160, 7, 'Defend the ghost fleet', 48, 'exploration', 'Legendary', 21008, 0),
(161, 182, 'Escort the ghost fleet', 62, 'bounty', 'Very Hard', 21608, 0),
(162, 230, 'Decode the orbital station', 57, 'raid', 'Very Hard', 21742, 0),
(163, 164, 'Chart the quantum relay', 233, 'escort', 'Hard', 5407, 0),
(164, 71, 'Steal the artifact cache', 32, 'escort', 'Easy', 8561, 0),
(165, 46, 'Escort the prison barge', 226, 'exploration', 'Legendary', 12965, 0),
(166, 166, 'Scan the wormhole gate', 252, 'puzzle', 'Very Hard', 7256, 0),
(167, 234, 'Chart the frontier colony', 227, 'story', 'Easy', 2407, 0),
(168, 199, 'Recover the prison barge', 229, 'bounty', 'Easy', 1339, 1),
(169, 69, 'Secure the artifact cache', 78, 'faction', 'Easy', 16988, 1),
(170, 123, 'Steal the reactor core', 224, 'puzzle', 'Normal', 208, 1),
(171, 177, 'Scan the weather array', 247, 'puzzle', 'Hard', 11026, 0),
(172, 103, 'Escort the research lab', 29, 'puzzle', 'Hard', 2736, 1),
(173, 195, 'Rescue the rogue AI', 149, 'puzzle', 'Easy', 12688, 0),
(174, 77, 'Scan the research lab', 200, 'stealth', 'Easy', 20835, 1),
(175, 189, 'Sabotage the crystal vault', 98, 'exploration', 'Easy', 23684, 0),
(176, 126, 'Escort the mining outpost', 200, 'raid', 'Very Hard', 17596, 1),
(177, 5, 'Secure the crystal vault', 19, 'escort', 'Easy', 13387, 0),
(178, 55, 'Awaken the wormhole gate', 235, 'faction', 'Normal', 2460, 0),
(179, 189, 'Track the derelict carrier', 73, 'stealth', 'Legendary', 1600, 0),
(180, 180, 'Recover the rogue AI', 67, 'story', 'Hard', 3288, 1),
(181, 157, 'Repair the reactor core', 88, 'side', 'Easy', 16390, 0),
(182, 17, 'Negotiate the dust moon', 104, 'survival', 'Hard', 4058, 0),
(183, 83, 'Defend the weather array', 110, 'bounty', 'Hard', 2171, 0),
(184, 71, 'Negotiate the rogue AI', 73, 'escort', 'Legendary', 5506, 1),
(185, 63, 'Sabotage the frontier colony', 21, 'faction', 'Very Hard', 5269, 0),
(186, 226, 'Escort the derelict carrier', 250, 'story', 'Normal', 3020, 0),
(187, 107, 'Sabotage the xenoforest', 244, 'bounty', 'Hard', 17240, 1),
(188, 106, 'Decode the ghost fleet', 123, 'story', 'Legendary', 5998, 1),
(189, 157, 'Mine the research lab', 46, 'survival', 'Easy', 18375, 0),
(190, 50, 'Investigate the frontier colony', 61, 'faction', 'Hard', 17785, 0),
(191, 119, 'Chart the crystal vault', 107, 'exploration', 'Easy', 4989, 1),
(192, 128, 'Decode the crystal vault', 91, 'story', 'Hard', 9440, 0),
(193, 112, 'Secure the ghost fleet', 129, 'stealth', 'Easy', 3521, 0),
(194, 237, 'Decode the derelict carrier', 91, 'stealth', 'Legendary', 3903, 0),
(195, 230, 'Contain the weather array', 121, 'faction', 'Hard', 13831, 0),
(196, 192, 'Infiltrate the frontier colony', 167, 'escort', 'Normal', 3313, 0),
(197, 189, 'Rescue the artifact cache', 212, 'exploration', 'Easy', 15533, 1),
(198, 14, 'Sabotage the xenoforest', 224, 'faction', 'Very Hard', 5934, 1),
(199, 96, 'Contain the xenoforest', 70, 'escort', 'Hard', 6726, 0),
(200, 33, 'Repair the crystal vault', 17, 'raid', 'Normal', 3740, 1),
(201, 118, 'Decode the dust moon', 215, 'exploration', 'Hard', 19879, 0),
(202, 203, 'Repair the mining outpost', 88, 'exploration', 'Easy', 13590, 1),
(203, 221, 'Repair the prison barge', 111, 'stealth', 'Hard', 575, 1),
(204, 189, 'Infiltrate the dust moon', 127, 'survival', 'Legendary', 7387, 0),
(205, 234, 'Negotiate the crystal vault', 3, 'story', 'Very Hard', 24134, 0),
(206, 109, 'Track the frontier colony', 202, 'stealth', 'Very Hard', 7981, 0),
(207, 143, 'Negotiate the xenoforest', 7, 'bounty', 'Hard', 9792, 0),
(208, 166, 'Recover the prison barge', 47, 'raid', 'Normal', 23145, 1),
(209, 220, 'Contain the lost survey team', 13, 'bounty', 'Very Hard', 6160, 0),
(210, 161, 'Recover the reactor core', 238, 'survival', 'Hard', 17497, 0),
(211, 76, 'Chart the ghost fleet', 219, 'puzzle', 'Legendary', 6887, 0),
(212, 159, 'Defend the black box', 172, 'escort', 'Easy', 3736, 1),
(213, 94, 'Stabilize the crystal vault', 239, 'escort', 'Hard', 5843, 0),
(214, 144, 'Sabotage the dust moon', 105, 'exploration', 'Legendary', 3821, 1),
(215, 189, 'Infiltrate the dust moon', 108, 'escort', 'Hard', 16600, 1),
(216, 71, 'Escort the research lab', 28, 'escort', 'Very Hard', 16032, 0),
(217, 121, 'Contain the ghost fleet', 150, 'escort', 'Easy', 6271, 1),
(218, 23, 'Steal the rogue AI', 42, 'raid', 'Easy', 3683, 0),
(219, 71, 'Sabotage the prison barge', 58, 'bounty', 'Normal', 17161, 0),
(220, 76, 'Awaken the wormhole gate', 214, 'stealth', 'Hard', 13866, 1),
(221, 189, 'Mine the xenoforest', 11, 'side', 'Easy', 7712, 0),
(222, 106, 'Secure the prison barge', 176, 'faction', 'Legendary', 18072, 1),
(223, 118, 'Repair the wormhole gate', 156, 'raid', 'Normal', 8619, 0),
(224, 124, 'Mine the crystal vault', 191, 'bounty', 'Hard', 9418, 1),
(225, 43, 'Awaken the smuggler convoy', 83, 'bounty', 'Normal', 23303, 0),
(226, 42, 'Scan the crystal vault', 122, 'escort', 'Legendary', 4244, 1),
(227, 67, 'Decode the xenoforest', 190, 'puzzle', 'Easy', 21908, 0),
(228, 89, 'Evacuate the lost survey team', 76, 'puzzle', 'Normal', 17586, 0),
(229, 32, 'Steal the prison barge', 13, 'bounty', 'Very Hard', 10592, 0),
(230, 2, 'Secure the smuggler convoy', 260, 'stealth', 'Hard', 24812, 0),
(231, 205, 'Secure the frontier colony', 227, 'stealth', 'Easy', 4668, 0),
(232, 79, 'Steal the ghost fleet', 13, 'exploration', 'Very Hard', 11811, 0),
(233, 84, 'Stabilize the xenoforest', 29, 'faction', 'Legendary', 7379, 0),
(234, 51, 'Escort the mining outpost', 12, 'stealth', 'Easy', 16870, 1),
(235, 50, 'Secure the ghost fleet', 252, 'faction', 'Legendary', 1936, 0),
(236, 102, 'Negotiate the research lab', 76, 'survival', 'Hard', 499, 0),
(237, 89, 'Mine the lost survey team', 180, 'puzzle', 'Easy', 7167, 1),
(238, 190, 'Contain the smuggler convoy', 213, 'bounty', 'Very Hard', 23974, 1),
(239, 36, 'Sabotage the xenoforest', 45, 'raid', 'Very Hard', 17313, 0),
(240, 17, 'Escort the derelict carrier', 193, 'survival', 'Hard', 13682, 0),
(241, 143, 'Repair the wormhole gate', 237, 'exploration', 'Normal', 12609, 0),
(242, 142, 'Defend the smuggler convoy', 252, 'faction', 'Hard', 16290, 1),
(243, 58, 'Recover the wormhole gate', 14, 'raid', 'Hard', 21089, 1),
(244, 32, 'Negotiate the rogue AI', 148, 'stealth', 'Normal', 1032, 0),
(245, 196, 'Track the reactor core', 142, 'faction', 'Hard', 19140, 1),
(246, 145, 'Chart the prison barge', 224, 'side', 'Hard', 16894, 0),
(247, 217, 'Decode the weather array', 133, 'story', 'Normal', 10575, 1),
(248, 225, 'Evacuate the rogue AI', 70, 'story', 'Hard', 11934, 1),
(249, 163, 'Defend the smuggler convoy', 183, 'raid', 'Legendary', 21036, 0),
(250, 132, 'Decode the frontier colony', 100, 'faction', 'Normal', 17916, 0),
(251, 224, 'Mine the orbital station', 162, 'escort', 'Easy', 17611, 0),
(252, 211, 'Recover the wormhole gate', 74, 'puzzle', 'Hard', 12322, 1),
(253, 106, 'Decode the frontier colony', 175, 'exploration', 'Normal', 16594, 0),
(254, 213, 'Awaken the ghost fleet', 97, 'puzzle', 'Legendary', 23448, 0),
(255, 107, 'Escort the frontier colony', 236, 'bounty', 'Easy', 15812, 0),
(256, 80, 'Sabotage the lost survey team', 186, 'faction', 'Legendary', 11308, 0),
(257, 182, 'Recover the frontier colony', 156, 'exploration', 'Normal', 22848, 0),
(258, 177, 'Mine the wormhole gate', 117, 'exploration', 'Normal', 2675, 1),
(259, 177, 'Escort the derelict carrier', 58, 'stealth', 'Very Hard', 1493, 0),
(260, 28, 'Investigate the weather array', 17, 'story', 'Very Hard', 3996, 0),
(261, 12, 'Mine the derelict carrier', 34, 'side', 'Easy', 19819, 0),
(262, 151, 'Decode the research lab', 103, 'story', 'Easy', 4869, 0),
(263, 149, 'Evacuate the rogue AI', 179, 'puzzle', 'Legendary', 8024, 0),
(264, 26, 'Investigate the xenoforest', 8, 'exploration', 'Hard', 5728, 0),
(265, 186, 'Rescue the black box', 51, 'stealth', 'Hard', 22976, 0),
(266, 113, 'Decode the research lab', 55, 'survival', 'Very Hard', 7121, 0),
(267, 105, 'Secure the frontier colony', 58, 'stealth', 'Easy', 17130, 0),
(268, 127, 'Mine the mining outpost', 185, 'story', 'Easy', 10851, 1),
(269, 30, 'Mine the lost survey team', 198, 'faction', 'Hard', 22613, 1),
(270, 58, 'Mine the quantum relay', 209, 'exploration', 'Easy', 15686, 0),
(271, 46, 'Track the frontier colony', 7, 'survival', 'Very Hard', 17226, 0),
(272, 31, 'Steal the artifact cache', 74, 'faction', 'Easy', 24395, 0),
(273, 17, 'Rescue the dust moon', 187, 'exploration', 'Legendary', 13347, 0),
(274, 60, 'Track the orbital station', 218, 'faction', 'Legendary', 9044, 1),
(275, 92, 'Stabilize the artifact cache', 244, 'stealth', 'Legendary', 9238, 0),
(276, 197, 'Scan the frontier colony', 233, 'raid', 'Very Hard', 16394, 0),
(277, 161, 'Recover the frontier colony', 69, 'story', 'Easy', 16422, 0),
(278, 46, 'Stabilize the dust moon', 196, 'bounty', 'Hard', 20480, 0),
(279, 195, 'Investigate the prison barge', 40, 'stealth', 'Normal', 9719, 1),
(280, 126, 'Chart the mining outpost', 259, 'escort', 'Legendary', 18011, 0),
(281, 196, 'Negotiate the frontier colony', 17, 'survival', 'Very Hard', 10407, 1),
(282, 114, 'Defend the crystal vault', 236, 'bounty', 'Legendary', 21707, 0),
(283, 227, 'Track the quantum relay', 85, 'bounty', 'Hard', 23552, 1),
(284, 125, 'Repair the prison barge', 57, 'puzzle', 'Legendary', 18850, 1),
(285, 122, 'Investigate the crystal vault', 81, 'survival', 'Hard', 16310, 1),
(286, 158, 'Mine the dust moon', 181, 'story', 'Easy', 19448, 0),
(287, 33, 'Evacuate the weather array', 188, 'story', 'Hard', 12570, 0),
(288, 110, 'Evacuate the quantum relay', 177, 'escort', 'Easy', 21767, 0),
(289, 64, 'Mine the weather array', 121, 'side', 'Easy', 10091, 0),
(290, 87, 'Recover the mining outpost', 87, 'escort', 'Easy', 15203, 1),
(291, 146, 'Chart the derelict carrier', 216, 'stealth', 'Legendary', 828, 0),
(292, 97, 'Secure the weather array', 200, 'side', 'Very Hard', 3378, 0),
(293, 87, 'Investigate the dust moon', 255, 'bounty', 'Legendary', 9914, 0),
(294, 112, 'Track the reactor core', 104, 'puzzle', 'Normal', 9516, 0),
(295, 13, 'Repair the artifact cache', 153, 'exploration', 'Legendary', 24442, 0),
(296, 184, 'Repair the dust moon', 49, 'raid', 'Easy', 18660, 1),
(297, 110, 'Evacuate the reactor core', 108, 'raid', 'Legendary', 9927, 1),
(298, 170, 'Rescue the quantum relay', 161, 'survival', 'Hard', 20578, 1),
(299, 172, 'Recover the black box', 93, 'bounty', 'Legendary', 16457, 0),
(300, 170, 'Chart the mining outpost', 240, 'faction', 'Very Hard', 18650, 0),
(301, 134, 'Evacuate the lost survey team', 103, 'bounty', 'Normal', 5030, 0),
(302, 217, 'Negotiate the dust moon', 223, 'side', 'Normal', 13614, 0),
(303, 211, 'Decode the orbital station', 147, 'faction', 'Normal', 13399, 0),
(304, 30, 'Rescue the derelict carrier', 77, 'exploration', 'Hard', 15309, 1),
(305, 144, 'Negotiate the crystal vault', 224, 'exploration', 'Normal', 9036, 0),
(306, 8, 'Chart the mining outpost', 133, 'bounty', 'Easy', 23774, 1),
(307, 201, 'Defend the reactor core', 11, 'escort', 'Legendary', 9864, 0),
(308, 231, 'Evacuate the reactor core', 209, 'survival', 'Normal', 7834, 0),
(309, 147, 'Scan the black box', 257, 'faction', 'Legendary', 8351, 1),
(310, 227, 'Infiltrate the ghost fleet', 47, 'side', 'Hard', 10890, 1),
(311, 207, 'Negotiate the xenoforest', 121, 'bounty', 'Easy', 5839, 0),
(312, 71, 'Negotiate the orbital station', 226, 'faction', 'Easy', 16168, 0),
(313, 180, 'Secure the mining outpost', 58, 'survival', 'Very Hard', 22471, 0),
(314, 72, 'Evacuate the prison barge', 75, 'escort', 'Hard', 790, 0),
(315, 216, 'Infiltrate the orbital station', 28, 'puzzle', 'Very Hard', 10234, 0),
(316, 232, 'Awaken the signal beacon', 63, 'stealth', 'Very Hard', 357, 1),
(317, 238, 'Mine the reactor core', 131, 'exploration', 'Hard', 6993, 0),
(318, 235, 'Secure the quantum relay', 225, 'story', 'Hard', 2724, 1),
(319, 121, 'Secure the quantum relay', 212, 'side', 'Normal', 22987, 0),
(320, 130, 'Evacuate the quantum relay', 34, 'faction', 'Legendary', 24275, 0);


-- Example practice ideas for students:
-- 1. Find all games released after 2018.
-- 2. Show each game title with its studio name.
-- 3. Count how many characters belong to each species.
-- 4. Find the average Metacritic score by genre.
-- 5. Show all missions in a given game ordered by reward.
-- 6. Find playable characters whose power_rating is above 80.
-- 7. Join missions -> characters -> games to see who gives missions in each game.