Given a table 'matches' with columns 'team1', 'team2', and 'winner', where each row represents a match between two teams and the winner, how would you determine the number of matches won and lost by each team?

Question

Accepted Answer

Calculate the number of matches won and lost by each team based on the given data in the matches table.

Group the data by team and count the number of matches won and lost for each team.
Use the winner column to determine the outcome of each match.
Create a query to calculate the number of matches won and lost for each team.
Example: Team A won 2 matches and lost 1 match.
Example: Team B won 1 match and lost 2 matches.

Given a table 'matches' with columns 'team1', 'team2', and 'winner', where each row represents a match between two teams and the winner, how would you determine the number of matches won and lost by each team?

Chubb Senior Data Analyst interview questions & answers