Teams and their away fixtures

Using a LEFT JOIN from teams to matches on the guest side, list every team together with the match_num of each match they played as the guest team. Teams that never appeared as the guest team must still appear once, with match_num shown as NULL.

Return two columns: the team's name as team_name and match_num.

Order the rows by team_name, then match_num.

---

Database schema

−+Fit
primary keyforeign keyarrow points to the referenced columndrag to pan