blob: 51f40e1a1fa89b618c4fa72414c5b50a58b428b7 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
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;
|
