Match scorelines with team names

Each row in matches references a host team and a guest team by their team_id. Join matches to the teams table twice to replace both ids with the actual team names.

Return five columns: match_num, the host team's name as host_team, the guest team's name as guest_team, host_team_score, and guest_team_score.

Order the rows by match_num.

---

Database schema

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