Cricket query

Integer average before last match

Men who had a batting average that was an integer before they played their last Test.

SQL

Format:

Gender:

(Help)

Men's Test

player_id player total innings average
p625383 JJ Bumrah 280 59 7
p36603 EJ Chatfield 180 53 9
p51481 CD Collymore 168 50 7
p32345 BKV Prasad 189 45 7
p20393 H Strudwick 224 40 8
p46569 A Nel 330 40 10
p7663 FR Spofforth 210 27 10
p12454 JL Denly 780 26 30
p14127 DW Headley 168 25 8
p1158088 Naseem Shah 105 23 7
p46196 CN McCarthy 24 22 3
p29299 ND Hirwani 54 20 6
p486679 D Olivier 50 19 5
p669855 JC Archer 144 18 8
p21464 R Tattersall 50 17 5
p27622 RK Chauhan 98 17 7
p31813 CS Nayudu 126 17 9
p38742 W Watson 60 17 5
p34215 V Subramanya 260 14 20
p51258 OAC Banks 300 14 30
p32965 MM Patel 56 13 7
p5385 DR Gilbert 56 11 8
p18389 G Onions 30 10 10
p50836 KPJ Warnaweera 35 10 5
p51098 EE Achong 72 10 8
p1027781 MJ Potts 70 9 10
p43706 Zulfiqar Ahmed 200 9 40
p51228 MI Black 12 9 2
p1193685 T Murphy 70 8 10
p316363 Imran Khan 6 8 1
p5143 E Evans 70 8 10
p10739 EW Clark 32 7 8
p26829 L Balaji 49 7 7
p39005 Arshad Khan 30 7 5
p44956 GD Elliott 60 7 10
p49870 PDRL Perera 18 7 9
p52930 GC Shillingford 42 7 7
p52960 CEL Stuart 24 7 4
p806241 R Ngarava 50 7 10
p1210511 Nahid Rana 12 6 4
p268845 PLS Gamage 3 6 1
p28774 D Ganesh 18 6 6
p30154 UN Kulkarni 12 6 4
p433614 Zahid Mahmood 20 6 5
p51898 AH Gray 35 6 7
p1158175 Mohammad Ali 0 5 0
p1176959 Akash Deep 45 5 9
p13362 ESH Giddins 10 5 5
p15388 MC Ilott 28 5 7
p20182 K Shuttleworth 25 5 5
p230368 JM Holland 1 5 1
p28770 DJ Gandhi 200 5 50
p28864 S Guha 12 5 3
p29533 KS Indrajitsinhji 32 5 8
p33088 CR Rangachari 0 5 0
p37710 TG McMahon 5 5 5
p3975 J Angel 24 5 6
p41246 Liaqat Ali 24 5 6
p48458 GRA de Silva 27 5 9
p53218 CD Watson 12 5 3
p55691 SG Peall 30 5 10
p13324 JER Gallian 32 4 8
p16978 AJW McIntyre 12 4 3
p17092 F Morley 4 4 2
p18625 RM Prideaux 80 4 20
p20105 MWW Selvey 10 4 5
p20167 M Sherwin 30 4 30
p20270 TPB Smith 32 4 8
p24599 WB Rankin 36 4 9
p30030 AR Kapoor 80 4 20
p301847 Subashis Roy 0 4 0
p310958 A Mithun 120 4 30
p31795 MV Narasimha Rao 16 4 4
p37530 RJ Kennedy 24 4 8
p44731 JP Duminy 16 4 4
p47737 CH Vintcent 20 4 5
p50429 KJ Silva 6 4 2
p55269 GB Brent 28 4 7
p55714 JA Rennie 24 4 8
p5663 JC Hill 12 4 6
p7656 SB Smith 32 4 8
p8499 U Afzaal 24 4 8
p928059 B White 1 4 1
p1159495 Khurram Shahzad 12 3 6
p13446 T Greenhough 2 3 1
p15380 AP Igglesden 5 3 5
p235519 TS Chisoro 18 3 6
p29280 Harvinder Singh 0 3 0
p33152 B Reddy 21 3 7
p36829 GR Dickinson 24 3 8
p37230 RI Harford 6 3 6
p40872 Jalal-ud-Din 3 3 3
p42648 Shakeel Ahmed jnr 12 3 4
p45991 JD Lindsay 12 3 6
p4600 DJ Colley 30 3 10
p46674 AL Ochse 10 3 5
p495964 RP Burl 24 3 8
p49769 RAP Nissanka 18 3 9
p53152 JO Taylor 4 3 4
p547092 Ehsan Adil 21 3 7

884ms

Women's Test

player_id player total innings average
p55107 S Bayley 81 11 9
p53854 AM Starling 30 10 6
p54544 BL Bevege 350 8 50
p54239 S Braganza 21 7 7
p53856 A Stinson 18 6 6
p54547 CM Oyler 200 6 50
p54618 SN Nefdt 200 6 40
p54623 Y van Mentz 60 6 10
p53805 M Lowe 27 5 9
p53468 M Baylis 16 4 8
p53524 L Kutcher 16 4 8
p53827 JE Partridge 27 4 9
p54308 S McLauchlan 4 4 1
p54348 VE Burt 32 4 8
p54653 JF McNaughton 16 4 4
p883405 JI Rodrigues 180 4 60
p273004 RM Farrell 20 3 10
p482506 A Bosch 30 3 10
p53520 T Juhasz 4 3 4
p53631 SJ Andrews 18 3 9
p53776 JM Greenwood 16 3 8
p53812 JE May 6 3 3
p54277 S Sridhar 12 3 6
p1039421 CE Dean 12 2 6
p453370 CL Tryon 30 2 30
p483484 L Lee 6 2 3
p53479 J Bath 8 2 8
p53518 M Jones 2 2 2
p53540 F McClintock 14 2 7
p53545 R Monaghan 8 2 4
p53567 IH Shevill 12 2 6
p53571 J Stockton 120 2 60
p53582 A Wegemund 6 2 3
p53685 E Liddell 0 2 0
p53770 JL Godman 12 2 6
p53779 MJ Haddelsey 10 2 5
p53878 E Wulcko 14 2 7
p53890 HA Wardlaw 40 2 20
p53972 B Goyal 0 2 0
p54081 SA Paranjpe 2 2 2
p54271 R Punekar 2 2 1
p54311 EM Sinclair 8 2 4
p54387 BJ Legg 4 2 4
p54390 SM Gilchrist 7 2 7
p54485 RJ Steele 16 2 8
p54592 SSD van Zyl 3 2 3
p54984 Deebah Sherazi 2 2 1
p55003 Sajjida Shah 2 2 1
p709635 RS Gayakwad 0 2 0
p276681 T Chetty 2 1 2
p276682 MM Letsoalo 3 1 3
p276683 S Loubser 3 1 3
p53506 GJ Hall 5 1 5
p53546 W Napier 9 1 9
p53549 B Orchard 4 1 4
p53561 KA Raymond 6 1 6
p53570 O Smith 0 1 0
p53652 MJ Bulow 20 1 20
p53767 CA Evans 3 1 3
p53802 M Lockwood 0 1 0
p53823 CM Mowat 0 1 0
p53847 GA Smith 0 1 0
p54268 J Patel 2 1 2
p54429 MH Peters 0 1 0
p54504 NJ Browne 1 1 1
p54506 LE Milliken 6 1 6

66ms

Men's ODI

player_id player total innings average
p300619 Rubel Hossain 140 52 5
p38133 C Pringle 189 40 9
p49363 SHT Kandamby 870 35 30
p50240 CPH Ramanayake 210 35 10
p30873 S Madan Lal 400 34 20
p429981 Mohammad Irfan 48 33 4
p52817 AME Roberts 230 31 10
p6903 CJ McKay 189 30 9
p34274 S Sreesanth 44 21 4
p937953 Bilal Khan 30 21 3
p990039 Shoriful Islam 84 21 7
p399259 AC Evans 100 18 10
p55610 BA Murphy 72 17 8
p784375 CBRLS Kumara 60 17 6
p33044 SLV Raju 32 16 4
p524075 T Lungameni 49 16 7
p210279 AD Poynter 240 15 20
p446101 ST Gabriel 21 15 3
p55666 J Nyumbu 45 13 5
p5779 RJ Harris 48 13 8
p14152 EE Hemmings 30 12 5
p33963 SK Sharma 80 12 10
p401057 Taijul Islam 110 12 10
p5679 TG Hogan 72 12 9
p40082 Ehsan Khan 80 11 10
p47232 WF Stelling 180 11 30
p4923 SP Davis 20 11 5
p51479 PT Collins 30 11 5
p6460 JN Maguire 42 11 7
p6534 TBA May 36 11 9
p51898 AH Gray 45 10 9
p670045 G Motie 120 10 20
p25481 JD Nel 20 9 10
p267454 RJ Trott 120 9 20
p40043 Danish Kaneria 6 9 3
p1156689 RN Bhatia 48 8 8
p15461 RD Jackman 49 8 7
p24703 AS Luseno 18 8 9
p12923 BN French 32 7 8
p226493 HK Bennett 10 7 5
p23848 A Codrington 42 7 6
p36826 RP de Groen 12 7 3
p37222 DR Hadlee 40 7 8
p37237 MN Hart 49 7 7
p511532 Al-Amin Hossain 4 7 2
p55463 TR Gripper 63 7 9
p55502 AG Huckle 9 7 3
p1194795 M Pathirana 10 6 2
p230852 D Elgar 100 6 20
p25535 Imtiaz Abbasi 12 6 6
p317252 Sohail Khan 25 6 5
p323244 Rahat Ali 8 6 4
p36303 SL Boock 18 6 9
p43707 Zulqarnain 18 6 6
p481979 A Nortje 30 6 6
p49870 PDRL Perera 8 6 2
p4999 G Dymock 21 6 7
p51485 CEH Croft 18 6 9
p52687 BA Parchment 120 6 20
p5420 SF Graf 24 6 4
p672775 CT Mumba 21 6 7
p8526 PJW Allott 15 6 3
p854909 BM Tickner 10 6 10
p917159 M Prasidh Krishna 2 6 1
p1147980 S Dhakal 6 5 6
p1353033 Muhammad Jawadullah 14 5 7
p16885 DE Malcolm 9 5 3
p245373 A Martin 10 5 10
p28107 DR Doshi 9 5 3
p34085 ED Solkar 25 5 5
p39821 Aizaz Cheema 24 5 8
p45419 M Hayward 12 5 3
p457279 OP Stone 15 5 5
p48465 SKL de Silva 160 5 80
p55485 JG Heron 50 5 10
p55582 EZ Matambanadzo 8 5 4
p7898 PM Siddle 21 5 7
p8566 GG Arnold 30 5 10
p941959 Qadeer Ahmed 8 5 4
p1136106 Jay Odedra 9 4 3
p1168049 J Fraser-McGurk 80 4 20
p1205559 Mohammad Haris 27 4 9
p22380 AG Wharf 16 4 8
p24945 RH Scholte 32 4 8
p268845 PLS Gamage 3 4 3
p30149 NM Kulkarni 10 4 5
p303349 PC Connell 40 4 40
p32540 CA Pujara 24 4 6
p37255 HJ Howarth 18 4 9
p379776 SSB Magala 12 4 4
p38745 PN Webb 30 4 10
p39956 Bazid Khan 80 4 20
p41026 Kabir Khan 10 4 10
p440968 Yamin Ahmadzai 8 4 4
p450101 RA Reifer 36 4 9
p467420 SP Terry 32 4 8
p48967 KHRK Fernando 40 4 40
p52413 JJC Lawson 10 4 5
p533042 B Stanlake 4 4 2
p55602 DT Mutendera 20 4 10

937ms

Women's ODI

player_id player total innings average
p54817 SI Galagedara 231 34 7
p420314 M Schutt 105 27 7
p54397 JE Harris 99 23 9
p53578 P Verco 300 17 20
p1135028 C Murray 54 15 6
p53814 GE McConway 65 15 5
p55192 KN Alexander 70 13 7
p1229018 J Maguire 35 12 5
p335241 HHC Gunaratne 40 12 8
p469886 A Hartley 10 12 10
p478278 M Daniels 40 12 10
p54485 RJ Steele 40 11 8
p701751 RA Mair 30 11 6
p914839 C de Lange 70 11 10
p1208952 FC Jonas 12 10 4
p54235 V Bhagat 63 10 9
p1268281 Zaida James 48 9 6
p538592 A Mazvishaya 54 9 9
p272814 APS Lakshika 56 8 8
p53609 EM Sampson 27 8 9
p55148 GE Greaves 32 8 4
p1135025 L Phiri 40 7 8
p220673 Sabahat Rasheed 10 7 5
p53620 L Hamilton 54 7 9
p53892 MC Godliman 36 7 6
p55137 D Luke 42 7 6
p581029 Shaila Sharmin 60 7 10
p629578 R Ntozakhe 8 7 2
p1119417 F Chipare 20 6 5
p272026 P Mujaji 60 6 10
p381266 HL Ferling 9 6 3
p381268 GM Harris 15 6 3
p53534 D Martin 12 6 3
p53859 HJ Stother 4 6 1
p544428 TMM Newton 50 6 10
p54687 M Toussaint 18 6 6
p54906 RA Hardiman 30 6 5
p54924 AMF McDonald 10 6 5
p1283439 IM Vaghela 45 5 9
p54281 K Dhokarikar 24 5 6
p54362 KD Brown 18 5 9
p54408 EM Ryan 15 5 5
p54598 N Ndzundzu 10 5 5
p54785 GL Kariyawasam 6 5 2
p54980 I Neilsen 20 5 20
p55115 E Caesar 28 5 7
p761027 Maham Tariq 8 5 2
p1026413 L Maritz 32 4 8
p1093308 GP Tom 18 4 6
p1094718 L Little 12 4 4
p1271055 I van der Woning 12 4 6
p1302733 L Mabhero 0 4 0
p1323130 V Buruka 0 4 0
p430391 S Ravikumar 18 4 6
p504891 LFM Cullen 18 4 6
p526975 LK Bennett 2 4 1
p530139 AK Peters 4 4 1
p53424 JK Garey 9 4 3
p53499 K Fazackerley 14 4 7
p53558 J Potter 110 4 110
p53766 S Ellis 32 4 8
p53837 L Read 10 4 5
p53919 V Raffel 16 4 4
p543488 GA Guy 2 4 2
p54438 JM Saulbrey 60 4 60
p54571 AL Bezuidenhout 20 4 10
p54578 L Korkie 20 4 5
p54706 I Koppe-V-Dishoek 8 4 8
p54761 KADC Lakmalee 28 4 7
p54933 T Skoyles 20 4 10
p54944 JC Day 3 4 3
p54978 P Thomsen 15 4 5
p55103 Mariam Anwar 3 4 3
p55123 E Emmanual 20 4 5
p55132 D Hobson 6 4 2
p55140 L McIntosh 28 4 7
p55150 J Sammy 16 4 4
p55198 AM Galvin 3 4 1
p55213 K Kato 8 4 4
p55223 K Uchibori 0 4 0
p924289 S Nisansala 20 4 10
p941805 Aiman Anwer 15 4 5
p1095834 HRA Rainey 9 3 9
p1289936 B Leephatthana 30 3 10
p1425916 S Immadi 4 3 4
p212709 JK Watts 1 3 1
p351841 A le Breton 4 3 4
p362356 Sidra Amin 18 3 9
p416017 AC Mol 9 3 3
p475907 N Symmons 9 3 3
p53520 T Juhasz 24 3 8
p53590 LM Albon 21 3 7
p53598 V Farrell 80 3 40
p53604 TL Russell 0 3 0
p53775 L Green 14 3 7
p54279 P Choudhary 20 3 20
p54439 JA Russell 8 3 4
p54444 RJ Signal 12 3 6
p54710 S Melchers 2 3 1
p54867 AM Budd 10 3 10

269ms

Men's T20I

player_id player total innings average
p325026 GJ Maxwell 2,580 103 30
p308710 K Motlhanka 990 37 30
p552760 Mohamed Azzam 256 35 8
p1204010 Waseem Abbas 120 28 8
p469193 Arjun Vinod 320 20 20
p1286507 DB Loic 80 19 5
p1089938 M Mooketsi 39 16 3
p1093676 C Pengkumta 70 16 5
p1273412 I Ntirenganya 28 16 4
p302866 SH Obed 90 16 10
p1153703 Musa Shaheen 98 15 7
p1183914 Murid Ekrami 110 15 10
p379145 T Shamsi 10 14 2
p581584 M Taniyama 72 14 8
p467823 JD Freyone 84 13 7
p974109 Mujeeb Ur Rahman 54 13 9
p1048897 Avi Dixit 90 12 9
p1345188 TM Macalou 60 12 6
p307638 Shafiq Sharif 240 12 20
p637523 D Gim 80 12 8
p793447 Naveen-ul-Haq 42 12 6
p1345187 Mohamed Coulibaly 33 11 3
p19264 LE Plunkett 42 11 6
p515084 M Vaik 81 11 9
p522765 L Shafeeg 48 11 8
p1198871 A Nathwani 27 10 9
p1236058 Asad Ali Rehemtulla 42 10 7
p492707 Vichanath Singh 63 10 7
p775019 A Krishna 32 10 8
p974175 Fazalhaq Farooqi 9 10 3
p1159165 Tian Sen Qun 27 9 3
p1209007 Nazwan Ismail 14 9 7
p1338606 P Kumbhare 15 9 3
p1345178 P Zuze 30 9 5
p288284 JR Hazlewood 27 9 9
p348152 Usman Qadir 36 9 9
p402245 Amir Hamza 40 9 10
p468996 S Jamil 63 9 9
p469121 MJ Ansell 42 9 6
p1116745 Y Naing Tun 56 8 8
p1143154 Mustapha Suwareh 24 8 3
p1167766 S Yeshey 15 8 3
p1280663 C Udekwe 30 8 6
p1284225 Asad Mahmood 72 8 9
p1284540 Ishtiaq Ahmad 21 8 7
p1362921 P Kotoisuva 35 8 5
p370040 JDF Vandersay 20 8 20
p526468 EJB Miles 36 8 9
p55894 Farhad Reza 72 8 9
p1041679 NP Kenjige 10 7 2
p1058213 Mohammed Nadeem 6 7 6
p1143148 Andre Jarju 18 7 3
p1155543 E Ernest 30 7 6
p1314201 BP Adapaka 6 7 2
p1344838 Atif-Ur-Rehman 18 7 9
p1345185 M Malle 14 7 2
p23911 A Khan 49 7 7
p398666 SA Abbott 25 7 5
p710767 Abdul Majid 16 7 8
p1151267 JC Darji 30 6 5
p1182026 S Pillai 42 6 7
p1230627 A Manepalli 45 6 9
p1275733 A Dhingra 8 6 4
p1318856 Ismaeel Zia 54 6 9
p1397998 Umair Sharif 120 6 30
p1400099 D Dewald 60 6 10
p1434633 Firas Hussain 100 6 20
p1440982 BM Pecic 45 6 9
p235519 TS Chisoro 40 6 10
p235532 C Zhuwao 48 6 8
p324358 N Pradeep 10 6 10
p352292 Imran Ismail 60 6 10
p362201 L Gregory 35 6 7
p36331 IG Butler 5 6 5
p379887 LB Williams 6 6 2
p40582 Imran Farhat 60 6 10
p48835 CRD Fernando 24 6 6
p506612 MJ Henry 12 6 4
p514768 I Katzarski 15 6 3
p520256 SE Aquilina 30 6 6
p1155576 B Khumalo 10 5 5
p1156425 Waqas Ali 50 5 10
p1156478 SMK Waththage 14 5 7
p1161457 Aung Ko Ko 6 5 3
p1198884 S Rakshit 40 5 10
p1230025 F Clarke 12 5 4
p1271982 Ibrahim Jabarkhel 20 5 10
p1280697 J Baguma 27 5 9
p1283124 SR Rocket 10 5 2
p1283125 S Udhayan 40 5 10
p1295879 J Kariko 12 5 6
p1323450 Sohail Ahmad 50 5 10
p1333968 T Ritawa 16 5 4
p1349476 Manish Sharma 20 5 5
p1382797 Gagandeep Singh 27 5 9
p1411885 Ibrahim Sesay 24 5 8
p1447960 S Gantulga 10 5 2
p212175 H Osinde 27 5 9
p296180 S Ravoka 21 5 7
p379927 BE Hendricks 18 5 6

582ms

Women's T20I

player_id player total innings average
p1196334 R Immadi 147 24 7
p1158390 T Luka 126 21 6
p588219 YS To 162 19 9
p1337669 AISD Kainoco 85 18 5
p1182756 O Matsolo 72 17 6
p1182780 M Carlot 55 17 5
p593936 L Goodall 280 17 20
p1306438 I Nandakumar 35 16 5
p914839 C de Lange 60 16 6
p1268911 DL Graham 48 15 4
p646693 LK O'Reilly 63 15 7
p1289496 SA Panayan 56 14 7
p442048 E Bisht 40 14 5
p1210715 JKD Andreano 39 13 3
p1265241 T Motlhabaphuti 32 13 4
p1351966 G Uwase 44 13 4
p1172355 J Efosa 56 12 8
p478278 M Daniels 20 12 5
p1213627 Javed Hina 77 11 7
p1283423 E de Souza 70 11 7
p1326684 IE Mulhovo 88 11 8
p1399073 T Ariuntsetseg 50 11 5
p1093515 M Tarimiala 35 10 7
p1150581 I Toua 30 10 6
p1179942 M Ochieng 56 10 8
p1228989 E Guehoada 8 10 4
p1447744 TRR Sharfudheen 45 10 5
p1447748 Likitha Yadav 42 10 7
p769517 K Ramharack 16 10 4
p1095834 HRA Rainey 12 9 2
p1158373 M Ramafifi 14 9 2
p1161454 DS Vlachopoulou 56 9 8
p1395422 MM Mabathoana 18 9 2
p1441585 LAR Bommareddy 45 9 9
p465599 Saniyah Zia 42 9 6
p522736 Thae Thae Po 15 9 5
p1161407 FA Galvez 16 8 4
p1203213 L Moises 16 8 4
p1306416 S Prakash 15 8 3
p1307966 R Asumadu 24 8 4
p1307972 M Eshun 35 8 5
p1395393 S Vaia 56 8 7
p1395413 KM Chingaipe 40 8 5
p1395423 NM Mokhachane 4 8 1
p220678 N Niranjana 42 8 7
p274569 SEA Ruck 15 8 5
p307837 CA Greloni 21 8 3
p577190 Nuzhat Tasnia 40 8 8
p725879 Anam Amin 3 8 3
p971203 N Mlaba 12 8 3
p1116778 P Haryanti 7 7 1
p1158380 P Pheko 21 7 3
p1175167 Madeeha Zuberi 4 7 1
p1196246 M Marchello-Nizia 9 7 9
p1196249 M Cargouet 14 7 2
p1213656 A Bose 15 7 3
p1229018 J Maguire 9 7 3
p1311480 S Akiteng 9 7 3
p1318453 Chado Om 20 7 5
p1333941 M Vervitsioti 30 7 6
p1354165 Phoup Srey Pheak 12 7 2
p1394107 L Dalbina 40 7 10
p1116785 NW Sariani 6 6 1
p1121133 Su Jin Kim 20 6 5
p1146665 AS van Beuge 18 6 6
p1182060 EFB Estrada 32 6 8
p1196336 S Raveendrakumar 15 6 3
p1204960 Syeda Aroob Shah 21 6 7
p1213629 Sameera Khan 6 6 2
p1354167 Sok Srey Maov 4 6 2
p1354174 Heal Theara 12 6 3
p1390777 I Muntean 28 6 7
p1399071 J Erdenesuvd 12 6 2
p1454976 K Srandeva 24 6 4
p364374 S Simic 2 6 1
p54254 DP David 12 6 3
p587167 MK Chaudhary 25 6 5
p1027871 Divya Kandpal 6 5 2
p1140105 R Choden 27 5 9
p1161409 JC Guardia 10 5 2
p1161412 T Pueye 24 5 6
p1171473 AE Moe 4 5 1
p1182053 G Morales 3 5 1
p1182757 J Sainda 20 5 4
p1189314 Y Sangare 0 5 0
p1189317 T Konate 8 5 2
p1190583 A Meyenborg 9 5 9
p1195124 Fariha Trisna 4 5 2
p1196331 KA Bhatti 25 5 5
p1201046 Kiyo Fujikawa 12 5 4
p1203204 MSE Linares 20 5 5
p1203253 C Valdes 4 5 1
p1208764 Sumayya Abdul 24 5 6
p1213631 N Jagadish 14 5 7
p1275230 S Elmesioo 4 5 2
p1289497 KE Pounsett 35 5 7
p1306414 D Bhaskara 15 5 5
p1318489 Archara Supriya 4 5 2
p1318943 SA Nono 4 5 1
p1352120 M Faisal 16 5 4

413ms

By Sean McGivern