Query: Germany-Portugal Nations League semifinal by Paulo Sousa

select matches.*, home_teams.name as home_team, away_teams.name as away_team, *
from @blt.ultimate_soccer_dataset.matches matches
inner join @blt.ultimate_soccer_dataset.teams home_teams ON (matches.home_team_id = home_teams.team_id)
inner join @blt.ultimate_soccer_dataset.teams away_teams ON (matches.away_team_id = away_teams.team_id)
where matches.match_id = '9fdc13ab-d0b2-53ed-a26a-be578b2b217f'

match_id	season_id	date	home_team_id	away_team_id	venue_id	referee_id	status	home_score	away_score	home_extratime_score	away_extratime_score	home_penalty_score	away_penalty_score	home_halftime_score	away_halftime_score	home_manager_name	away_manager_name	home_formation	away_formation	home_team	away_team	match_id_1	season_id_1	date_1	home_team_id_1	away_team_id_1	venue_id_1	referee_id_1	status_1	home_score_1	away_score_1	home_extratime_score_1	away_extratime_score_1	home_penalty_score_1	away_penalty_score_1	home_halftime_score_1	away_halftime_score_1	home_manager_name_1	away_manager_name_1	home_formation_1	away_formation_1	team_id	name	team_type	country	stadium_id	founded_year	team_id_1	name_1	team_type_1	country_1	stadium_id_1	founded_year_1
9fdc13ab-d0b2-53ed-a26a-be578b2b217f	303aa2bc-6fba-5c17-825f-40b2cccd7126	2025-06-04 00:00:00+00	ee9be42a-0a4a-5e0c-8885-c64e414827a3	421512b8-7304-5373-ac02-70b4452113b0	4b4d8f39-1e8e-5d78-8ef1-d0627e4e0ab0	null	Match Finished	1	2	null	null	null	null	0	0	J. Löw	Roberto Martínez	3-4-2-1	4-3-3	Germany	Portugal	9fdc13ab-d0b2-53ed-a26a-be578b2b217f	303aa2bc-6fba-5c17-825f-40b2cccd7126	2025-06-04 00:00:00+00	ee9be42a-0a4a-5e0c-8885-c64e414827a3	421512b8-7304-5373-ac02-70b4452113b0	4b4d8f39-1e8e-5d78-8ef1-d0627e4e0ab0	null	Match Finished	1	2	null	null	null	null	0	0	J. Löw	Roberto Martínez	3-4-2-1	4-3-3	ee9be42a-0a4a-5e0c-8885-c64e414827a3	Germany	national	Germany	61bedc4e-1c06-5f83-94b6-a03bd908528d	1900	421512b8-7304-5373-ac02-70b4452113b0	Portugal	national	Portugal	e68390d8-96e2-57aa-8ec9-9e599c6b01ff	1914