blob: 05a96973cf6f07d49376301c07bbc1277502f397 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
WITH stats AS (
SELECT
api_id,
CASE WHEN roster.hero_kills=0
THEN 0
ELSE (kills+assists)/roster.hero_kills::float
END AS kill_participation
FROM participant JOIN roster ON roster.api_id=participant.roster_api_id
)
INSERT INTO participant_stats(participant_api_id, kill_participation)
SELECT * FROM stats
ON CONFLICT(participant_api_id) DO
UPDATE SET(participant_api_id, kill_participation) = (SELECT * FROM stats)
|
