PDA

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



anter
08-01-2009, 04:10 AM
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. I've been told that the compiledplayers tables are empty, but don't know how to procede.

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

anter
08-02-2009, 12:20 PM
Problem solved using some work-around