00:00:00

Description

Editorial

Double Round-Robin League Fixtures

EASY10 pts

A sports operations platform stores the participating clubs of a league season in a Teams table. The scheduling service needs a complete list of directed fixtures for a double round-robin stage, where each pair of clubs plays twice with swapped home and away roles.

Table: Teams

team_name: unique team name

Task: Generate all valid home-away fixtures.

Fixture rules:

For every two different teams A and B, include:
- A as home, B as away
- B as home, A as away
Do not include self fixtures where home_team equals away_team.

Output requirements:

Return exactly two columns: home_team, away_team
Output order is not graded.

Supported submission environments:

SQL (SQLite 3.27.2)
Pandas (Python)

Example

Input

Teams:
| team_name     |
|---------------|
| Harbor United |
| Metro Stars   |
| Redwood FC    |

Output

[
  {"home_team":"Harbor United","away_team":"Metro Stars"},
  {"home_team":"Harbor United","away_team":"Redwood FC"},
  {"home_team":"Metro Stars","away_team":"Harbor United"},
  {"home_team":"Metro Stars","away_team":"Redwood FC"},
  {"home_team":"Redwood FC","away_team":"Harbor United"},
  {"home_team":"Redwood FC","away_team":"Metro Stars"}
]

Explanation

Three teams produce 3 * (3 - 1) = 6 directed fixtures, with both directions included for each team pair.

Example

Input

Teams:
| team_name |
|-----------|
| Alpha     |
| Beta      |

Output

[
  {"home_team":"Alpha","away_team":"Beta"},
  {"home_team":"Beta","away_team":"Alpha"}
]

Explanation

With two teams, exactly two matches exist, one in each direction.

Example

Input

Teams:
| team_name |
|-----------|
| SoloClub  |

Output

[]

Explanation

A single team cannot play itself, so no valid fixture rows exist.

Accepted0/0·0% Acceptance

Constraints

0 <= number of rows in Teams <= 30
1 <= len(team_name) <= 30
team_name values are unique within Teams
team_name contains only letters, digits, spaces, underscore, or hyphen
Return columns exactly as: home_team, away_team
Each output row must satisfy home_team != away_team
For every unordered team pair, both directed rows must be present
For SQL submissions, use SQLite 3.27.2 semantics
For Pandas submissions, return a DataFrame with columns: home_team, away_team

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

Teams =

[{"team_name":"Metro_Stars"},{"team_name":"Harbor_United"},{"team_name":"Redwood_FC"}]

Loading problem...

101

00:00:00

Description

Editorial

Double Round-Robin League Fixtures

EASY10 pts

Table: Teams

team_name: unique team name

Task: Generate all valid home-away fixtures.

Fixture rules:

For every two different teams A and B, include:
- A as home, B as away
- B as home, A as away
Do not include self fixtures where home_team equals away_team.

Output requirements:

Return exactly two columns: home_team, away_team
Output order is not graded.

Supported submission environments:

SQL (SQLite 3.27.2)
Pandas (Python)

Example

Input

Teams:
| team_name     |
|---------------|
| Harbor United |
| Metro Stars   |
| Redwood FC    |

Output

[
  {"home_team":"Harbor United","away_team":"Metro Stars"},
  {"home_team":"Harbor United","away_team":"Redwood FC"},
  {"home_team":"Metro Stars","away_team":"Harbor United"},
  {"home_team":"Metro Stars","away_team":"Redwood FC"},
  {"home_team":"Redwood FC","away_team":"Harbor United"},
  {"home_team":"Redwood FC","away_team":"Metro Stars"}
]

Explanation

Three teams produce 3 * (3 - 1) = 6 directed fixtures, with both directions included for each team pair.

Example

Input

Teams:
| team_name |
|-----------|
| Alpha     |
| Beta      |

Output

[
  {"home_team":"Alpha","away_team":"Beta"},
  {"home_team":"Beta","away_team":"Alpha"}
]

Explanation

With two teams, exactly two matches exist, one in each direction.

Example

Input

Teams:
| team_name |
|-----------|
| SoloClub  |

Output

[]

Explanation

A single team cannot play itself, so no valid fixture rows exist.

Accepted0/0·0% Acceptance

Constraints

0 <= number of rows in Teams <= 30
1 <= len(team_name) <= 30
team_name values are unique within Teams
team_name contains only letters, digits, spaces, underscore, or hyphen
Return columns exactly as: home_team, away_team
Each output row must satisfy home_team != away_team
For every unordered team pair, both directed rows must be present
For SQL submissions, use SQLite 3.27.2 semantics
For Pandas submissions, return a DataFrame with columns: home_team, away_team

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

Teams =

[{"team_name":"Metro_Stars"},{"team_name":"Harbor_United"},{"team_name":"Redwood_FC"}]

Double Round-Robin League Fixtures

Hints

Double Round-Robin League Fixtures

Hints