1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| SELECT classes, s.numCompet, SUM(s.Expr1) AS nbr0, SUM(s.Expr2) AS nbr1, SUM(s.Expr3) AS nb9
FROM (SELECT classes, numCompet, COUNT(resultats) AS Expr1, 0 AS Expr2, 0 AS Expr3
FROM tabResultats
WHERE (classes = 'VAM') AND (resultats = '0')
GROUP BY classes, numCompet
UNION
SELECT classes, numCompet, 0 AS Expr1, COUNT(resultats) AS Expr2, 0 AS Expr3
FROM tabResultats
WHERE (classes = 'VAM') AND (resultats = '1')
GROUP BY classes, numCompet
UNION
SELECT classes, numCompet, 0 AS Expr1, 0 AS Expr2, COUNT(resultats) AS Expr3
FROM tabResultats
WHERE (classes = 'VAM') AND (resultats = '9')
GROUP BY classes, numCompet) AS s
GROUP BY classes, s.numCompet |
Partager