From 15bcf935c314a2806ceb84075e3add1500081828 Mon Sep 17 00:00:00 2001
From: Ant Zucaro <azucaro@gmail.com>
Date: Fri, 1 Feb 2013 16:21:26 -0500
Subject: [PATCH] Identify games with bad ranks.

---
 queries/identify_bad_rank_games.sql | 5 +++++
 1 file changed, 5 insertions(+)
 create mode 100644 queries/identify_bad_rank_games.sql

diff --git a/queries/identify_bad_rank_games.sql b/queries/identify_bad_rank_games.sql
new file mode 100644
index 0000000..fa59513
--- /dev/null
+++ b/queries/identify_bad_rank_games.sql
@@ -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;
-- 
2.39.2