There is a table matches which has team 1,team 2 and winner columns. Sample data like ind pak pak and pak ind ind and sl ban sl. So a team can play mutliple matches. Final output should be team, no of matches won and no of matches lost

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.

There is a table matches which has team 1,team 2 and winner columns. Sample data like ind pak pak and pak ind ind and sl ban sl. So a team can play mutliple matches. Final output should be team, no of matches won and no of matches lost

Top Chubb Senior Data Analyst interview questions & answers

Popular interview questions of Senior Data Analyst

Top HR questions asked in Chubb Senior Data Analyst