Teams that both hosted and visited

Using matches and teams, find the names of teams that have both hosted at least one match and appeared as the guest in at least one match. Match a team to host_team_id for the hosting side and to guest_team_id for the guest side, and keep only names common to both sides.

Return one column: name, sorted alphabetically (ascending).

---

Database schema

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