Table with details in
We can then add the expression containing this aggregation to the selection and choose teams who have at least 1 such scoreline. If we also add a second version showing the number of populated scorelines in the grid we can then see the 47 teams separated by the number of different scorelines that have occurred at least 1 time in every season, as follows:
Table with details in
Crewe Alexandra and Rochdale only managed to achieve 3 of their 4 scorelines in the curtailed 2019-20 season, so will drop down to join Port Vale on 3!
From the initial aggregation if we croatia phone number example now change the minimum value from 1 to 2 we change the question to look for teams which have had a scoreline 2 times in every season. We can then see that there are only 12 teams have had a scoreline 2 times in ever y season since WW2.
Table with details in
Repeating the above technique we would find that there are no teams who have had the same scoreline 3 times in every season.
We can work out which ones was closest function, and we find the following:
Table with details in
Bristol City have done it in 72 of the seasons, and only fell short by recording just 2 1-1 draws in the 1957 season. They have also achieved this feat in the (now completed) 2019-20 season.