[Stefan Pochmann]

OK. In den Comps auf denen ich bis jetzt war, waren immer nur 12 in Finale, deshalb wunderte es mich,

Anzahl 3x3-Finalisten und in wie vielen Meisterschaften das vorkam:

Code:

3    1
4    16
5    18
6    88
7    23
8    388
9    29
10    253
11    29
12    358
13    30
14    24
15    24
16    81
17    7
18    15
19    12
20    31
21    4
22    10
23    6
24    11
25    9
27    1
28    4
29    3
30    7
31    3
32    3
34    2
35    2
38    1
39    2
40    1
42    2
55    1

select finalists, count(*) competitions from
(select count(distinct personId) finalists
from Results
where eventId='333' and roundId in ('f','c')
group by competitionId) tmp
group by finalists

Bzw wenn man die Meisterschaften nicht mitzählt, wo's nur eine Runde 3x3 gab:

Code:

4    16
5    18
6    88
7    22
8    388
9    29
10    251
11    28
12    356
13    29
14    24
15    23
16    81
17    6
18    14
19    10
20    31
21    4
22    10
23    5
24    10
25    9
27    1
28    4
29    3
30    7
31    2
32    2
34    1
35    2
38    1
39    2
42    1

select finalists, count(*) competitions from
(select competitionId, count(distinct roundId) rounds, sum(roundId in ('f','c')) finalists
from Results
where eventId='333'
group by competitionId) tmp
where rounds > 1
group by finalists;