Cricket Fixtures Without Repeats | Dataford Interview Questions

Given a table of cricket teams, find all possible match fixtures without repetition (Ind vs NZ and NZ vs Ind count as the same fixture).

Asked in the Round 2: Client Interview (PySpark + SQL) stage.

Output

cricket_teams

Column	Type	Description
team_idPK	INT	Unique identifier for each cricket team
team_name	VARCHAR(100)	Cricket team name
country_code	VARCHAR(10)	Optional short country or board code

Your question is Cricket Fixtures Without Repeats. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Given a table of cricket teams, find all possible match fixtures without repetition (Ind vs NZ and NZ vs Ind count as the same fixture).

Asked in the Round 2: Client Interview (PySpark + SQL) stage.

cricket_teams

Column	Type	Description
team_idPK	INT	Unique identifier for each cricket team
team_name	VARCHAR(100)	Cricket team name
country_code	VARCHAR(10)	Optional short country or board code

Your question is Cricket Fixtures Without Repeats. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.