How to get number of reply in specific duration of time?

Hi, I just looking into get the users and number of replies they have posted since from the last 1 month period of time. I have tried the below query , select * from messages But seems it's not r...