Unnamed
public sql v1 · immutableSELECT team.tid, team.name AS tname, tag, player.name AS lnameFROM player, teamLEFT JOIN leader ON team.tid = leader.tidWHERE leader.pid = player.pidORDER BY tnameSELECT team.tid, team.name AS tname, tag, player.name AS lnameFROM player, teamLEFT JOIN leader ON team.tid = leader.tidWHERE leader.pid = player.pidORDER BY tname