Click here to Skip to main content
16,018,518 members

Comments by Prasad Dds (Top 2 by date)

Prasad Dds 24-Apr-15 12:50pm View    
My expected output for above data is :

name no_hattricks
aditya 1
Prasad Dds 24-Apr-15 12:48pm View    
here streak means result, if streak 1 means won and 0 means lost. so if a person won 3 in a row then count is 1, if won 4 in a row then count is 1, if won 5 in a row count 1, if won 6 in a row then 2, 7 in a row 2, 8 in row 2 , 9 in a row 3. if he won 5 in a row and 6th one lost then its count is 1. hope it gives some idea