Skip to content

Instantly share code, notes, and snippets.

@fightbulc

fightbulc/user-bet-stats.sql

Created December 23, 2011 09:53
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fightbulc/1513757 to your computer and use it in GitHub Desktop.
Save fightbulc/1513757 to your computer and use it in GitHub Desktop.
Download ZIP
User Bet Stats
Raw
user-bet-stats.sql
SELECT
b.status,
count(b.id)
FROM
bets AS b
WHERE
708150929 IN (b.challenger_fbuser_id, opponent_fbuser_id)
GROUP by b.status
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment