Query para extrair informações de partidas do European Soccer Database

query.sql

select
	c.name as country,
	l.name as league,
	t.team_long_name as home_team,
	t2.team_long_name as away_team,
	m.*

from "Match" m
inner join Country c ON c.id = m.country_id
inner JOIN League l ON l.id = m.league_id
inner JOIN Team t ON t.team_api_id = m.home_team_api_id
inner JOIN Team t2 ON t2.team_api_id = m.away_team_api_id