diff options
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 |