How can Ruby on Rails group data from a model by a specific time (month)?

Question

Ruby on Rails

For example, there is a User model (it has a standard field :created_at).
So is it possible to find out the number of users in December, for example?

Answer 1

It is possible like this:

User.where(created_at: Date.parse('December')...Date.parse('December')+1.month).count

Answer 2

User.where("strftime('%m', created_at) = ?", '12').count

for sqlite