Query: Spain-France Nations League semifinal by Paulo Sousa

1select me.minute, me.stoppage_time, teams.name, me.event_type, me.description, me.notes
2from @blt.ultimate_soccer_dataset.match_events me
3inner join @blt.ultimate_soccer_dataset.teams teams ON (me.team_id = teams.team_id)
4where me.match_id = 'f1598530-2d28-5684-9c22-3fa6d65a1e34'
5order by 1, 2
6limit 100

minute	stoppage_time	name	event_type	description	notes
22	null	Spain	goal	Normal Goal	None
25	null	Spain	goal	Normal Goal	None
33	null	Spain	card	Yellow Card	Tripping
44	null	Spain	var	Goal Disallowed - offside	None
51	null	France	card	Yellow Card	Tripping
54	null	Spain	goal	Penalty	None
55	null	Spain	goal	Normal Goal	None
59	null	France	goal	Penalty	None
63	null	France	subst	Substitution 1	None
63	null	France	subst	Substitution 2	None
63	null	France	subst	Substitution 3	None
64	null	Spain	subst	Substitution 1	None
64	null	Spain	subst	Substitution 2	None
67	null	Spain	goal	Normal Goal	None
72	null	France	subst	Substitution 4	None
76	null	France	subst	Substitution 5	None
77	null	Spain	subst	Substitution 3	None
77	null	Spain	subst	Substitution 4	None
79	null	France	goal	Normal Goal	None
82	null	France	card	Yellow Card	Holding
84	null	France	goal	Own Goal	None
90	1	Spain	subst	Substitution 5	None
90	3	France	goal	Normal Goal	None
90	4	France	card	Yellow Card	Roughing
90	6	Spain	card	Yellow Card	Unsportsmanlike conduct
90	7	France	card	Yellow Card	None