diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-02-07 20:46:16 +0100 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-02-07 20:46:16 +0100 |
| commit | f72d816f8d5bb6f363b1ae43debdcff4dafef074 (patch) | |
| tree | 3d95b058efced83297b881e648a5c816f1eaacc6 /queries/hero-winrates.sql | |
| parent | da71062508f53d2674e1b9ea90764b7ba650c412 (diff) | |
| download | apigrabber-f72d816f8d5bb6f363b1ae43debdcff4dafef074.tar.gz apigrabber-f72d816f8d5bb6f363b1ae43debdcff4dafef074.zip | |
remove code not related to API data fetching
Diffstat (limited to 'queries/hero-winrates.sql')
| -rw-r--r-- | queries/hero-winrates.sql | 18 |
1 files changed, 0 insertions, 18 deletions
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 |