1 files changed, 18 insertions, 0 deletions
diff --git a/queries/hero-winrates.sql b/queries/hero-winrates.sql
new file mode 100644
index 0000000..51f40e1
--- /dev/null
+++ b/queries/hero-winrates.sql
@@ -0,0 +1,18 @@
+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