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: Mostrar dados de desempenho do atleta, juntando as tabelas 'athlete_stats' e 'team_performances'
 ###Tabelas: 
CREATE TABLE athlete_stats (athlete_id INT, name VARCHAR(100), team VARCHAR(50), position VARCHAR(50), games_played INT, goals_scored INT); CREATE TABLE team_performances (team VARCHAR(50), games_played INT, goals_scored INT); INSERT INTO athlete_stats (athlete_id, name, team, position, games_played, goals_scored) VALUES (1, 'John Doe', 'Team A', 'Forward', 20, 15), (2, 'Jane Smith', 'Team B', 'Defender', 25, 5); INSERT INTO team_performances (team, games_played, goals_scored) VALUES ('Team A', 20, 30), ('Team B', 25, 20);
SELECT athlete_stats.name, team_performances.games_played, athlete_stats.goals_scored FROM athlete_stats INNER JOIN team_performances ON athlete_stats.team = team_performances.team;