Cricket query

Highest lowest cumulative average

This shows the lowest average each player had at the end of any innings in their career, and ranks them by that low point.

SQL

Format:

Gender:

(Help)

Men's Test

player total_runs lowest_cumulative_average
H Sutcliffe 4,555 60.73
PHKD Mendis 1,556 53.61
Javed Miandad 8,832 51.75
FMM Worrell 3,860 49.49
SM Gavaskar 10,122 47.70
KD Walters 5,357 47.03
YBK Jaiswal 2,612 45.14
HL Collins 1,352 45.07
AI Kallicharran 4,299 44.31
M Azharuddin 6,215 43.96

549ms

Women's Test

player total_runs lowest_cumulative_average
S Agarwal 1,110 50.45
ME Maclagan 1,007 40.50
CM Edwards 1,676 32.50
E Bakewell 1,078 31.50
KL Rolton 1,002 23
DA Hockley 1,301 14
R Heyhoe-Flint 1,594 13.78
EA Perry 1,006 13.50
JA Brittin 1,935 11.33
CA Hodges 1,164 8

25ms

Men's ODI

player total_runs lowest_cumulative_average
HE van der Dussen 2,657 48.31
MEK Hussey 5,297 47.89
Imam-ul-Haq 3,152 47.03
TLW Cooper 1,239 45.48
MG Bevan 6,873 42.33
T Bavuma 2,168 42.14
KP Pietersen 4,336 39.83
AJ Lamb 3,975 39.31
GS Chappell 2,309 39.10
RN ten Doeschate 1,541 39

539ms

Women's ODI

player total_runs lowest_cumulative_average
Pratika Rawal 1,189 40
NE Bolton 1,896 39.67
P Litchfield 1,536 37.29
M Raj 7,691 37.11
CM Edwards 5,992 34.12
BJ Clark 4,844 33.25
SJ Taylor 4,056 30.50
DA Annetts 1,100 29.80
BA Daniels 1,249 26.24
RL Haynes 2,585 26

160ms

Men's T20I

player total_runs lowest_cumulative_average
Sami Sohail 2,127 42.98
Babar Azam 4,526 38.95
DJ Malan 1,892 36.38
Sohail Ahmed 1,739 35.35
S Davizi 1,373 35.03
DP Conway 1,839 34.80
G Mckeon 1,002 33.76
Muhammad Tanveer 1,886 33
SA Yadav 3,272 32.31
LA Dunbar 1,171 32.14

450ms

Women's T20I

player total_runs lowest_cumulative_average
RL Blake 1,179 38
SR Taylor 3,666 31.70
M Raj 2,364 28
SJ Bryce 1,803 27.86
Theertha Satish 2,328 25.50
CM Edwards 2,605 25.33
SL Kalis 2,617 25.31
CS Mugeri-Tiripano 1,321 24.86
L Barnett 1,297 24
JI Rodrigues 2,761 21.50

324ms

By Sean McGivern