PostgreSQL如何获取某些行的总和

PostgreSQL如何获取某些行的总和

我认为您希望将总数除以天数：

SELECt l.login,       (SUM(l.duration) FILTER (WHERe l.state NOT IN ('lunch', 'break1', 'break2')) /        COUNT(DISTINCT date_trunc('day', l.started_at)       ) AS labor_averageFROM log lGROUP BY l.login