Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Adicionar novos jogadores e seus jogos às tabelas.
 ###Tabelas: 
CREATE TABLE players (id INT PRIMARY KEY, name VARCHAR(100)); CREATE TABLE games (id INT PRIMARY KEY, player_id INT, game_name VARCHAR(100), last_played TIMESTAMP); INSERT INTO players VALUES (1, 'Alice'), (2, 'Bob'), (3, 'Carol'); INSERT INTO games VALUES (1, 1, 'GameA', '2021-01-01 12:00:00'), (2, 1, 'GameB', '2021-02-15 14:30:00'), (3, 3, 'GameA', '2021-06-20 09:15:00'); CREATE TABLE new_players (id INT PRIMARY KEY, name VARCHAR(100), game_name VARCHAR(100), last_played TIMESTAMP);
INSERT INTO players (id, name) SELECT id, name FROM new_players WHERE id NOT IN (SELECT player_id FROM players); INSERT INTO games (id, player_id, game_name, last_played) SELECT new_players.id, players.id AS player_id, new_players.game_name, new_players.last_played FROM new_players JOIN players ON players.name = 'Eve' OR players.name = 'Frank';