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: Encontrar as equipes com a maior diferença nas vendas de ingressos entre os jogos em casa e fora no México.
 ###Tabelas: 
CREATE TABLE teams (team_id INT, team_name VARCHAR(100)); INSERT INTO teams (team_id, team_name) VALUES (1, 'Club America'), (2, 'Chivas de Guadalajara'); CREATE TABLE matches (match_id INT, team_home_id INT, team_away_id INT, tickets_sold INT); INSERT INTO matches (match_id, team_home_id, team_away_id, tickets_sold) VALUES (11, 1, 2, 30000), (12, 2, 1, 35000);
SELECT team_name, home_sales - away_sales as diff FROM (SELECT team_home_id, SUM(tickets_sold) as home_sales FROM matches WHERE location = 'Mexico' GROUP BY team_home_id) home_sales JOIN (SELECT team_away_id, SUM(tickets_sold) as away_sales FROM matches WHERE location = 'Mexico' GROUP BY team_away_id) away_sales JOIN teams t ON home_sales.team_home_id = t.team_id OR away_sales.team_away_id = t.team_id ORDER BY diff DESC;