Posted:
#1
Hi All,
I'm messing around with sportsdatabase and trying to query some data and something just isn't adding up. For example, I'm running this query:
R1 > 0 and n:R1 = 0 and date=20100426
I'm trying to test something with runs scored in the 1st inning. The query I'm intending is:
if a run is scored in the 1st inning of a game, what's the record of it not scoring in the 1st inning of the next game. I used April 26, 2010 as a start date.
The results show SU: 7-0, but the actual results are 5-2 (which are represented by results from April 27 because I'm basing April 26th as the 1st day of data where I'm getting see if there was a run scored in the 1st inning). The Boston and Colorado games both scored a run in the 1st inning. Why are the results not showing 5-2? What do i need to change in the query to get this data to correctly show up? Thanks for any help
I'm messing around with sportsdatabase and trying to query some data and something just isn't adding up. For example, I'm running this query:
R1 > 0 and n:R1 = 0 and date=20100426
I'm trying to test something with runs scored in the 1st inning. The query I'm intending is:
if a run is scored in the 1st inning of a game, what's the record of it not scoring in the 1st inning of the next game. I used April 26, 2010 as a start date.
The results show SU: 7-0, but the actual results are 5-2 (which are represented by results from April 27 because I'm basing April 26th as the 1st day of data where I'm getting see if there was a run scored in the 1st inning). The Boston and Colorado games both scored a run in the 1st inning. Why are the results not showing 5-2? What do i need to change in the query to get this data to correctly show up? Thanks for any help
0
Hot Forum Topics
