Identify games with bad ranks.
authorAnt Zucaro <azucaro@gmail.com>
Fri, 1 Feb 2013 21:21:26 +0000 (16:21 -0500)
committerAnt Zucaro <azucaro@gmail.com>
Fri, 1 Feb 2013 21:21:26 +0000 (16:21 -0500)
queries/identify_bad_rank_games.sql [new file with mode: 0644]

diff --git a/queries/identify_bad_rank_games.sql b/queries/identify_bad_rank_games.sql
new file mode 100644 (file)
index 0000000..fa59513
--- /dev/null
@@ -0,0 +1,5 @@
+select game_id 
+from player_game_stats 
+where create_dt >= '2013-01-01' 
+group by game_id 
+having min(rank) = 2;