For question 4 we need to look at different results (Win, Draw, Loss) rather than looking at scorelines. We can also use the knowledge of the English football league structure to know that since WW2 there have only been divisions with certain numbers of teams (e.g. 20, 22 or 24 teams, which correspond to 38, 42 or 46 matches). Therefore, only one where we can have the equal number of results is the middle one in the list above (i.e having 14W, 14D, 14L in a 42 match season).
Using this domain knowledge we croatia phone number example can set up an aggregation as follows, and we need each result type to be exactly 14 (since a 46 match season could have 14-15-16 for instance), and this needs to happen for all of the 3 possible result types.
Table with details in
We find there are 15 separate teams who have achieved this since WW2, but no team has ever done it twice. Coventry City are the most recent team to do this, but that is now over 25 years ago! This is primarily because there have been no divisions with 22 teams for many seasons now.
Table with details in
Taking a closer look at Coventry’s records by season we see that they did indeed have the required property in the 1993 season.
Table with details in
Conclusions
Interesting English football statistics aside, new analytical capability for analysing transactions when they are initially grouped into categories. It should enable clients to look more closely and differentiate their customers based on their transactional activity and take appropriate action from this insight.