PGexercises.com | Bookings by month

-- https://pgexercises.com/questions/date/bookingspermonth.html
-- again, date_trunc works, date_part does not
-- not surprisingly, as they solve different problems

select date_trunc('month',starttime) as month,
count(starttime)
from cd.bookings
group by 1
order by 1 asc