PDA

View Full Version : QUERY: number of players with 15% < pfr < 20%



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

netsrak
07-31-2009, 05:43 PM
I don't know the exact database structure but the compiledplayers tables are empty in my database so you can't use them.

You should look / ask in the custom reports area: http://www.holdemmanager.net/forum/forumdisplay.php?f=10