Every team appearance across matches — DBMS OPPE Question
Every team appearance across matches
00:00
From the matches table, list every team appearance, where each match contributes two rows: its host (host_team_id) and its guest (guest_team_id). Duplicate team ids must be kept (a team that appears in many matches appears many times).
Return one column: team_id. Order does not matter.
Database schema
primary keyforeign keyarrow points to the referenced columndrag to pan