SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Coureurs (Genre TEXT, Epreuve TEXT, TempsPassage int, name TEXT);
INSERT INTO Coureurs VALUES
    ('M','125km',600,'Fred'),('M','125km',610,'Bert'),('M','125km',630,'Harry'),('M','125km',620,'Albert'),('M','125km',575,'David')
    
    ,('F','125km',615,'Mary'),('F','125km',625,'Anne'),('F','125km',601,'Betty'),('F','125km',625,'Sue'),('F','125km',670,'Shelia')
    
    ,('F','80km',450,'Louise'),('F','80km',460,'Celia'),('F','80km',425,'Debra'),('F','80km',475,'Diana')
    
    ,('F','65km',350,'Zara'),('F','65km',360,'Yvonne'),('F','65km',325,'Wilma'),('F','65km',375,'Ursurla')
    
    ,('F','40km',250,'Tracy'),('F','40km',260,'Rhona'),('F','40km',225,'Samantha'),('F','40km',275,'Karen')
    
    ,('M','80km',450,'Lou'),('M','80km',460,'Colin'),('M','80km',425,'Danny'),('M','80km',475,'Eddy')
    
    ,('M','65km',350,'Zed'),('M','65km',360,'Mark'),('M','65km',325,'William'),('M','65km',375,'Tom')
    
    ,('M','40km',250,'Jim'),('M','40km',260,'Larry'),('M','40km',225,'Peter'),('M','40km',275,'Ronald')
;
SELECT *
FROM (
  SELECT *, ROW_NUMBER() OVER (PARTITION BY Epreuve, Genre ORDER BY TempsPassage) rn
  FROM Coureurs
  WHERE TempsPassage IS NOT NULL
)
WHERE rn <= 3
ORDER BY Epreuve + 0, Genre, rn


Genre
Epreuve
TempsPassage
name
rn


F
40km
225
Samantha
1

F
40km
250
Tracy
2

F
40km
260
Rhona
3

M
40km
225
Peter
1

M
40km
250
Jim
2

M
40km
260
Larry
3

F
65km
325
Wilma
1

F
65km
350
Zara
2

F
65km
360
Yvonne
3

M
65km
325
William
1

M
65km
350
Zed
2

M
65km
360
Mark
3

F
80km
425
Debra
1

F
80km
450
Louise
2

F
80km
460
Celia
3

M
80km
425
Danny
1

M
80km
450
Lou
2

M
80km
460
Colin
3

F
125km
601
Betty
1

F
125km
615
Mary
2

F
125km
625
Anne
3

M
125km
575
David
1

M
125km
600
Fred
2

M
125km
610
Bert
3

Genre	Epreuve	TempsPassage	name	rn
F	40km	225	Samantha	1
F	40km	250	Tracy	2
F	40km	260	Rhona	3
M	40km	225	Peter	1
M	40km	250	Jim	2
M	40km	260	Larry	3
F	65km	325	Wilma	1
F	65km	350	Zara	2
F	65km	360	Yvonne	3
M	65km	325	William	1
M	65km	350	Zed	2
M	65km	360	Mark	3
F	80km	425	Debra	1
F	80km	450	Louise	2
F	80km	460	Celia	3
M	80km	425	Danny	1
M	80km	450	Lou	2
M	80km	460	Colin	3
F	125km	601	Betty	1
F	125km	615	Mary	2
F	125km	625	Anne	3
M	125km	575	David	1
M	125km	600	Fred	2
M	125km	610	Bert	3