ID Date Sales

1 6/22/2022 603
2 6/21/2022 478
3 6/20/2022 679
4 6/19/2022 443
5 6/18/2022 540
6 6/17/2022 740
7 6/16/2022 850
8 6/15/2022 604
9 6/14/2022 339
10 6/13/2022 905
ID Date Sales
1 6/22/2022 603
2 6/21/2022 478
3 6/20/2022 679
4 6/19/2022 443
5 6/18/2022 540
6 6/17/2022 740
7 6/16/2022 850
8 6/15/2022 604
9 6/14/2022 339
10 6/13/2022 905
ID State Date Sales
1 Jharkhand 6/22/2022 603
2 Jharkhand 6/21/2022 478
3 Jharkhand 6/20/2022 679
4 Jharkhand 6/19/2022 443
5 Jharkhand 6/18/2022 540
6 Jharkhand 6/17/2022 806
7 Jharkhand 6/16/2022 939
8 Jharkhand 6/15/2022 803
9 Jharkhand 6/14/2022 440
10 Jharkhand 6/13/2022 444
11 Bihar 6/22/2022 563
12 Bihar 6/21/2022 371
13 Bihar 6/20/2022 881
14 Bihar 6/19/2022 541
15 Bihar 6/18/2022 829
16 Bihar 6/17/2022 846
17 Bihar 6/16/2022 653
18 Bihar 6/15/2022 531
19 Bihar 6/14/2022 327
20 Bihar 6/13/2022 717
21 Maharastra 6/22/2022 925
22 Maharastra 6/21/2022 896
23 Maharastra 6/20/2022 647
24 Maharastra 6/19/2022 419
25 Maharastra 6/18/2022 762
26 Maharastra 6/17/2022 415
27 Maharastra 6/16/2022 834
28 Maharastra 6/15/2022 822
29 Maharastra 6/14/2022 887
30 Maharastra 6/13/2022 828
ID State Date Sales
1 Jharkhand 6/22/2022 603
2 Jharkhand 6/21/2022 478
3 Jharkhand 6/20/2022 679
4 Jharkhand 6/19/2022 443
5 Jharkhand 6/18/2022 540
6 Jharkhand 6/17/2022 806
7 Jharkhand 6/16/2022 939
8 Jharkhand 6/15/2022 803
9 Jharkhand 6/14/2022 440
10 Jharkhand 6/13/2022 444
11 Bihar 6/22/2022 563
12 Bihar 6/21/2022 371
13 Bihar 6/20/2022 881
14 Bihar 6/19/2022 541
15 Bihar 6/18/2022 829
16 Bihar 6/17/2022 846
17 Bihar 6/16/2022 653
18 Bihar 6/15/2022 531
19 Bihar 6/14/2022 327
20 Bihar 6/13/2022 717
21 Maharastr 6/22/2022 925
22 Maharastr 6/21/2022 896
23 Maharastr 6/20/2022 647
24 Maharastr 6/19/2022 419
25 Maharastr 6/18/2022 762
26 Maharastr 6/17/2022 415
27 Maharastr 6/16/2022 834
28 Maharastr 6/15/2022 822
29 Maharastr 6/14/2022 887
30 Maharastr 6/13/2022 828
ID Date Sales ID Department Salary
1 6/22/2022 603 1 SALES 1000
2 6/21/2022 478 2 IT 1500
3 6/20/2022 679 3 SALES 2000
4 6/19/2022 443 4 SALES 1700
5 6/18/2022 540 5 IT 1800
6 6/17/2022 740 6 ACCOUNTS 1200
7 6/16/2022 478 7 ACCOUNTS 1100
8 6/15/2022 604
9 6/14/2022 478
10 6/13/2022 603
Player Name Stadium Name Year Runs Country
P1 Eden Gardens 2018 421 India
P1 Wankhede 2018 450 India
P2 Eden Gardens 2018 360 India
P3 Eden Gardens 2018 393 Eng
P3 Wankhede 2018 324 Eng
P5 Wankhede 2018 311 India
P5 Eden Gardens 2018 349 NZ
P9 Wankhede 2018 229 NZ
P1 Eden Gardens 2019 469 India
P4 Wankhede 2019 412 India
P2 Eden Gardens 2019 89 India
P3 Eden Gardens 2019 471 Eng
P7 Wankhede 2019 128 Eng
P5 Wankhede 2019 234 India
P9 Eden Gardens 2019 471 NZ
P9 Wankhede 2019 464 NZ
P7 Eden Gardens 2021 356 India
P2 Wankhede 2021 88 India
P2 Eden Gardens 2021 463 India
P3 Eden Gardens 2021 273 Eng
P7 Wankhede 2021 112 Eng
P5 Wankhede 2021 292 India
P8 Eden Gardens 2021 154 NZ
P8 Wankhede 2021 389 NZ
filter indians
Partition by ground
partition by ground,year
order by
apply rank partiton by ground year
using first value top run scorer in ground/year
get diff between top scorer and player
last run scorer partition by ground year
Train Number Station Time
22863 Howrah 10:50:00
22863 Kharagpur 12:30:00
22863 Balasore 13:52:00
22863 Cuttack 15:47:00
22863 Bhubaneswar 16:25:00
12262 Howrah 5:45:00
12262 Tatanagar 9:00:00
12262 Bilaspur 15:05:00
12262 Raipur 16:37:00
12262 Nagpur 20:55:00

Player Year Runs

Virat 2008 159
Virat 2009 325
Virat 2010 995
Virat 2011 1381
Virat 2012 1026
Virat 2013 1268
Virat 2014 1054 odi
Virat 2015 623
Virat 2016 739
Virat 2017 1460
Virat 2018 1202
Virat 2019 1377
Virat 2020 431
Virat 2021 129
Virat 2022 142
Rohit 2008 532
Rohit 2009 102
Rohit 2010 504
Rohit 2011 611
Rohit 2012 168
Rohit 2013 1196
Rohit 2014 578
Rohit 2015 815
Rohit 2016 564
Rohit 2017 1293
Rohit 2018 1030
Rohit 2019 1490
Rohit 2020 171
Rohit 2021 90
Rohit 2022 78
time to next station
elapsed time till now