Players with their team

Using an inner join between the players and teams tables, list every player alongside the team they belong to.

Return three columns: the player's name as player_name, the player's jersey_no, and the team's name as team_name.

Order the rows by team_name, then by player_name.

---

Database schema

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