A tournament is being held where several matches takes place between a player from team 1 and a player from team 2. After every match one of the players is declared as the winner. However there are some players in Team2 who are known cheaters. Write an SQL Query to find the percentage of matches Won by Team1 against a non cheater from team 2 on every day. percentage of wins=(total games won against non cheaters)/(total games played against non cheaters). The percentage of wins should be rounded upto 4 decimals.
Also the name of the output coloumn should be ‘Percentage Wins’. Also the output should be order ascending order of the Dates.
Table:Team1
Id is primary key.
Table: Team2 (Cheater will be 1 if that player from Team2 is a cheater, 0 otherwise).
Id is primary key.
Table:Matches (Result would be 1 if PlayerId1 wins the match, 0 if PlayerId2 wins the match).
Also PlayerId1 is foreign key to Team1 and PlayerId2 is foreign key to Team2.
NOTE : The name of the output column should be ‘Percentage Wins’ .
Example :
NOTE: You only need to implement the given function. Do not read input, instead use the arguments to the function. Do not print the output, instead return values as specified. Still have a question? Checkout Sample Codes for more details.