Need to find number of wickets fallen/dismissed in between the period of any three consecutive overs (per innings) where runs decreased gradually ?

[shekhar_analyti]

Hi All ,

How to find number of wickets fallen in between the period of any three consecutive overs where runs decreased gradually ?

In season 2008 match id 1 , in the 1st inning , over 7 , 8 and 9 witnessed gradual decrease in RUNS . I need to find number of wicket fallen in between this period .

Note : Field  " dismissal_kind " ... gives fall of wicket .

Thanks & Regards

Shekar

[shekhar_analyti]

stalwar1‌   .  Hi Sunny , Adding you to old problem which was solved by Andrew . But i also wanted to add ref line or any highlighting that a wicket had fallen in that over ... You know , they way it shows in commentary