From f72d816f8d5bb6f363b1ae43debdcff4dafef074 Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Tue, 7 Feb 2017 20:46:16 +0100
Subject: remove code not related to API data fetching

---
 queries/hero-winrates.sql | 18 ------------------
 1 file changed, 18 deletions(-)
 delete mode 100644 queries/hero-winrates.sql

(limited to 'queries/hero-winrates.sql')

diff --git a/queries/hero-winrates.sql b/queries/hero-winrates.sql
deleted file mode 100644
index 51f40e1..0000000
--- a/queries/hero-winrates.sql
+++ /dev/null
@@ -1,18 +0,0 @@
-﻿SELECT ARRAY_TO_JSON(ARRAY(
-SELECT
-  JSONB_BUILD_OBJECT(
-  'actor', actors.actor,
-  'winrate', (SELECT
-    SUM((CASE WHEN (participant.data->'attributes'->'stats'->>'winner')='true' THEN 1 ELSE 0 END))::float
-    /
-    COUNT(*)::float
-    FROM participant
-    WHERE (participant.data->'attributes'->>'actor') = actors.actor)
-  )
-FROM
-(SELECT
-  DISTINCT participant.data->'attributes'->>'actor'
-  AS actor
-  FROM participant)
-AS actors)
-) AS data;
\ No newline at end of file
-- 
cgit v1.3.1

