let me make an example
consider a database with over one million of records, i.e. all nba
boxscores since 1940-something
consider just a few fields, i.e.
playerID, gameID, date, points, rebounds
records are sorted by gameID
I apply a couple of filters, i.e. points >= 30 and rebounds >=20
how would you make a query to get the "streaks" of consecutive games
for one player that fit the filters?
How can I check if between two filtered records there is at least one that doesn't match the criteria and breaks the streak?
does anyone of you work for Elias Sports Bureau? ;) :P
or for www.basketball-references.com ...
let me make an example
consider a database with over one million of records, i.e. all nba
boxscores since 1940-something
consider just a few fields, i.e.
playerID, gameID, date, points, rebounds
records are sorted by gameID
I apply a couple of filters, i.e. points >= 30 and rebounds >=20
how would you make a query to get the "streaks" of consecutive games
for one player that fit the filters?
How can I check if between two filtered records there is at least one that doesn't match the criteria and breaks the streak?
how would you make a query to get the "streaks" of consecutive games
for one player that fit the filters?
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 296 |
Nodes: | 16 (2 / 14) |
Uptime: | 54:50:38 |
Calls: | 6,650 |
Calls today: | 2 |
Files: | 12,200 |
Messages: | 5,330,746 |