🟨 Rozhodcovia – karty
SQL
SELECT rozhodca, krajina, COUNT(červené) AS cervene_karty FROM Rozhodcovia JOIN Krajiny JOIN Karty JOIN Zapasy GROUP BY rozhodca HAVING červené > 0 ORDER BY cervene_karty DESC
| # | Rozhodca | Krajina | 🔴 Červené | 🟡 Žlté | Celkom | Zápasy |
|---|
| 1 |
Szymon Marciniak |
Poľsko |
3 |
5 |
8 |
5 |
| 2 |
Danny Makkelie |
Holandsko |
2 |
2 |
4 |
4 |
| 3 |
Slavko Vinčić |
Srbsko |
2 |
0 |
2 |
2 |
| 4 |
Mustapha Ghorbal |
Maroko |
1 |
5 |
6 |
5 |
| 5 |
Raphaël Claus |
Brazília |
1 |
3 |
4 |
3 |
| 6 |
Fernando Rapallini |
Argentína |
1 |
3 |
4 |
2 |
| 7 |
Clément Turpin |
Francúzsko |
0 |
7 |
7 |
6 |
| 8 |
Wilton Sampaio |
Brazília |
0 |
6 |
6 |
4 |
| 9 |
Abdulrahman Al Jassim |
Katar |
0 |
4 |
4 |
4 |
| 10 |
Facundo Tello |
Argentína |
0 |
3 |
3 |
3 |
| 11 |
Ismail Elfath |
USA |
0 |
3 |
3 |
2 |
| 12 |
Bakary Gassama |
Senegal |
0 |
3 |
3 |
3 |
| 13 |
Michael Oliver |
Anglicko |
0 |
2 |
2 |
2 |
| 14 |
Maurizio Mariani |
Taliansko |
0 |
2 |
2 |
2 |
| 15 |
Janny Sikazwe |
Kamerun |
0 |
2 |
2 |
2 |
| 16 |
Alireza Faghani |
Irán |
0 |
2 |
2 |
2 |
| 17 |
Chris Beath |
Austrália |
0 |
2 |
2 |
2 |
| 18 |
Piero Maza |
Ekvádor |
0 |
1 |
1 |
1 |
| 19 |
Ivan Barton |
Kostarika |
0 |
1 |
1 |
1 |
| 20 |
Victor Gomes |
Senegal |
0 |
1 |
1 |
1 |