Equilibrium: Contest - By Class

SELECT any(class) as class,
countIf(1, completed = 1 and completionReason = 0) as clears,
round(sum(timePlayedSeconds)/60/60/24) as time_played_days,
sum(kills) as kills,
sum(deaths) as deaths
FROM pgcr.ventries
WHERE referenceId = 1754635208  -- Equilibrium: Contest
AND player.classHash != 0
GROUP BY player.classHash
ORDER BY clears desc