1. Carey Tilden
  2. WhatHappened

Commits

Carey Tilden  committed e4d9904

Added a column to show an average minutes per life for each time group

  • Participants
  • Parent commits 22addac
  • Branches default

Comments (0)

Files changed (1)

File share/SuperHostile08-deaths.sql

View file
     time_segment,
     deaths,
     minutes,
-    round(deaths/minutes, 1) as "d/min"
+    round(deaths/minutes, 1) as "d/min",
+    round(minutes/(deaths+1), 1)::real as "mins/life"
 from (
     select
         timestamp with time zone 'epoch' + interval '1 second'