NBA Stituational Bet, SDQL

Not much for me today, but like this one (bounce back game) for a normal size play: Looking for SDQL translation here fellas! Who can get if first!

1. Road team
2. Salty offense ave 102 more a game
3. Against an OK offense av btwn 98-92
4. after 42+ games
5. after a blowout loss of 15 or more.

Originally Posted by JMon

Not much for me today, but like this one (bounce back game) for a normal size play: Looking for SDQL translation here fellas! Who can get if first!

1. Road team
2. Salty offense ave 102 more a game
3. Against an OK offense av btwn 98-92
4. after 42+ games
5. after a blowout loss of 15 or more.

A and tA(points)>102 and 98>=oA(points)>=92 and game number>42 and p:margin<=-15

and under play if anyone is interested

P:HL and AD and 212>total>204 and rest=0 and p: points>110 and rest < o:rest

Originally Posted by cofaga

A and tA(points)>102 and 98>=oA(points)>=92 and game number>42 and p:margin<=-15

and under play if anyone is interested

P:HL and AD and 212>total>204 and rest=0 and p: points>110 and rest<o:rest< html=""></o:rest<>

bol

Originally Posted by cofaga

and under play if anyone is interested

P:HL and AD and 212>total>204 and rest=0 and p: points>110 and rest < o:rest

Thanks,
Nevermind.
Spacing issue...

Originally Posted by 19th Hole

An error occurred (104). Please check your SDQL and try again.

Query Fundamentals:

Hey 19th, you need to take out the space between the p: points so it reads points.

rest=0 and 207>total>199 and o:rest=0 and p: points>100 and op: points>100 and pp: points>100

over play, again use at your own risk

Originally Posted by cofaga

A and tA(points)>102 and 98>=oA(points)>=92 and game number>42 and p:margin<=-15

nice cofaga.. guess I need to be eliminated you from the session. But I did state "after 42+ games" which cover the 42 mark and you didn't in your query. All is well...talking about a 1% difference, but!

In my description....Salty offense ave 102 more a game. I should have stated 102 or more

this one is for NHL,if you parlayed favorite/over you would be 68-27 with results that show,im rigth jmon ??

line > 0 and p:margin < 3 and o:WP >= 40 and p:goals > 0 and pp:LD and pp:margin < 3 and pp:goals + o:goals > total and p:W

Originally Posted by figue

this one is for NHL,if you parlayed favorite/over you would be 68-27 with results that show,im rigth jmon ??

line > 0 and p:margin < 3 and o:WP >= 40 and p:goals > 0 and pp:LD and pp:margin < 3 and pp:goals + o:goals > total and p:W

Looks nice, will definitely save. Not seeing a result for today, I'm not doing it wrong am I? Also dropped "line>0" still great results, larger sample size.

Originally Posted by figue

this one is for NHL,if you parlayed favorite/over you would be 68-27 with results that show,im rigth jmon ??

line > 0 and p:margin < 3 and o:WP >= 40 and p:goals > 0 and pp:LD and pp:margin < 3 and pp:goals + o:goals > total and p:W

without checking, but "o:goals" without a summative is not predictive. Thus present time you will see.

Originally Posted by JMon

without checking, but "o:goals" without a summative is not predictive. Thus present time you will see.

so,what is the rigth query here ??

Originally Posted by figue

so,what is the rigth query here ??

fig, I don't know. I didn't make it! Surly you know what the game reference "p" is by now? Plug it in and see what happens. I already gave you the inaccurate parameter.

New to this but I have been trying to build my own lately.

Here is one but I'm not sure on the sample size. Looking at Wizards ML in particular

AF and p:WHD and op:AL and rest>o:rest

Here's one for tomorrow:

H and season>2009 and line>5 and p:margin<-15 and op:margin>5 and p:A and pp:A

Thanks, hyahya, nice trend!