Work out last race winner 2

[Sammy145]

I need help in working out of a list of 100000 dog races, which dog has won there races what i need is

1. winner of Previous race (needed as coloumn (Yes/No)
2. winner of previous 3 races (needed as coloumn (Yes/No)
3. winner of previous 6 races (needed as coloumn (Yes/No)

Finish position = 1 is WINNER
There could be gaps in race iD

Data format

dogID | Finish position | Race ID |
1 | 1 3
1 | 1 4
1 1 5
1 4 6
1 1 7


Thanks

 

[drlex]

Thanks for the star!
When you've worked out the betting plan on the dogs and make your $$$$, come back and tell us...



soi là, soi carré