finding total values for each month in postgres

Question

I need to find the total number of "wentto" trips for each month of the year . Assume all the months of 2010 are represented in the dataset.

adf_hunter · Accepted Answer · 2021-02-09 10:45:03Z

1

You can use conditional aggregation:

select date_trunc('month', date) as tt,
       count(*) filter (where event = 'wentto')
from t
where date >= '2010-01-01' and date < '2011-01-01'
group by tt
order by tt;

edited Feb 9, 2021 at 10:45

adf_hunter

92 bronze badges

answered Feb 7, 2021 at 16:02

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

finding total values for each month in postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related