i need this query in lucid. i tried many way but failed

[dmostafiz]

I need a immediate help.

SELECT count(*) as count, DATE_FORMAT(created_at,"%Y-%m") as cmonth FROM clicks GROUP BY cmonth

i need this query in lucid ORM. i tried many way but failed. please

[thetutlage]

Can you share what you have tried so far?

[dmostafiz]

I am just trying to get records from database for certain time like, last 7days, last month, last year etc.

the table model named Clicks has 2 fields. *1) user_id *2) created at

its a affiliate system. if you come to the website using my invitation link then a new click recored will be stored in the clicks table.
[ database -> clicks -> newRecord( my_id, created_at) ]