anter
07-31-2009, 03:10 PM
I've been trying to create a query that shows me the number of people in my database with pfr% > 15 and pfr% < 20, but I haven't succeded. I hope you guys can help me out.
Here is my best attempt (no lines are returned).
SELECT players.player_id
FROM players
JOIN compiledresults
ON compiledresults.player_id = players.player_id
JOIN compiledplayerresults
ON compiledplayerresults.compiledplayerresults_id = compiledresults.compiledplayerresults_id
WHERE totalhands > 100
AND pfrhands / totalhands > 0.15
AND pfrhands / totalhands < 0.20
Here is my best attempt (no lines are returned).
SELECT players.player_id
FROM players
JOIN compiledresults
ON compiledresults.player_id = players.player_id
JOIN compiledplayerresults
ON compiledplayerresults.compiledplayerresults_id = compiledresults.compiledplayerresults_id
WHERE totalhands > 100
AND pfrhands / totalhands > 0.15
AND pfrhands / totalhands < 0.20