Closed ThomasDekeyser closed 9 years ago
SELECT team_teamName, count( * ) FROM lf_player_has_team GROUP BY team_teamName HAVING count( * ) >4
lf_player_has_team
4GHENT 1H 5 4GHENT 2D 8 4GHENT 2H 5 De Mintons 5H 8 Deinze 1D 6 Lokerse 6H 6 Stekene 1D 6 Stekene 1H 6 Wetteren 2D 5 Wetteren 5H 5 Wit-Wit 3H 6
SELECT team_teamName, count( * ) FROM
lf_player_has_team
GROUP BY team_teamName HAVING count( * ) >44GHENT 1H 5 4GHENT 2D 8 4GHENT 2H 5 De Mintons 5H 8 Deinze 1D 6 Lokerse 6H 6 Stekene 1D 6 Stekene 1H 6 Wetteren 2D 5 Wetteren 5H 5 Wit-Wit 3H 6