1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| SELECT T1.NumGeny, T1.DateReunion, T1.LieuCourse, T1.NumReunion, T2.NumCourse, Numero, PlaceArrivee, CoteDef, PourcentDef,
(
SELECT COUNT(*) as NbSRC
FROM Chevaux ST3
INNER JOIN Courses ST2 ON ST3.NumGeny=ST2.NumGeny
INNER JOIN Reunions ST1 ON ST2.NumGeny=ST1.NumGeny AND ST1.DateReunion = '2023-01-07'
WHERE PourcentDef > 0 AND ST2.NumCourse = ST3.NumCourse AND
T1.NumGeny=ST1.NumGeny AND
T1.DateReunion=ST1.DateReunion AND
T1.LieuCourse=ST1.LieuCourse AND
T1.NumReunion=T1.NumReunion AND
T2.NumCourse=ST2.NumCourse
GROUP BY ST1.NumGeny, ST1.DateReunion, ST1.LieuCourse, ST1.NumReunion, ST2.NumCourse
)
FROM Chevaux T3
INNER JOIN Courses T2 ON T3.NumGeny=T2.NumGeny
INNER JOIN Reunions T1 ON T2.NumGeny=T1.NumGeny AND T1.DateReunion = '2023-01-07'
WHERE PourcentDef > 0 AND PlaceArrivee > 0 AND PlaceArrivee < 4
AND T2.NumCourse = T3.NumCourse
ORDER BY T1.NumGeny, T1.DateReunion, T1.LieuCourse, T1.NumReunion, T2.NumCourse, PourcentDef DESC |
Partager